topic Power Automate Create PDF Report-Time Changing in ArcGIS Survey123 Questions

Power Automate Create PDF Report-Time Changing

PTOOffice — Thu, 11 Jul 2024 12:09:19 GMT

I am using Power Automate to create a PDF report from Survey123. When using this feature it is changing the time field in my PDF report. It is adding 4 hours. When I manually export from Survey123, the time field is correct. Any ideas on how to fix this problem?

Thanks!

Re: Power Automate Create PDF Report-Time Changing

abureaux — Thu, 11 Jul 2024 17:43:14 GMT

It isn't changing the time, it is reporting in UTC.

Press "Show advanced options" and use this:

You will need to collect UTC offset in your survey and pass that into this field. That will automatically correct the times.

Alternatively, you can correct times in the Feature Report. You still need to collect UTC offset in the feature report, and it is a lot more involved. I recommend the first approach.

(NOTE: If you only have a single timezone, you can hard-code this value. I work across several time zones, so that isn't an option for me)

Re: Power Automate Create PDF Report-Time Changing

PTOOffice — Mon, 29 Jul 2024 15:01:53 GMT

Thank you for the above response. I am working in the Create Report and my screen looks a little different. I put in my time field from the survey under UTC offset and the time didn't change. Any ideas?

Re: Power Automate Create PDF Report-Time Changing

abureaux — Mon, 29 Jul 2024 15:08:57 GMT

What is the result of the field you are feeding into the UTC field? What I mean by that is:

Open any successful run of this flow
Expand the "When a survey response is submitted" step (I'm assuming that's your first step)
Search json under "OUTPUTS" for your specific field and look at that that field's value.

For example, here is mine:

The format of this text is very important. If you don't have the correct format, it won't work properly.