Answered

Time Zone issues

(0) Share

Report

Posted on by Jerrell

I am using a number of Flows to get responses from Microsoft Forms with Great success. Recently I was adding another flow on a new Microsoft Form and the time reported has increased by 5 hours. The time I am reporting is the submission time of the form. This has worked flawlessly in the past. Forms response has the correct time but email created by flow adds 5 hours to the submission time. If the Form was submitted at 6am then the emails reports the time as 11am.

Can anyone recommend a solution? The last one is exactly the same as the others listing the submission time in the flow, results are a time 5 hours later than the actual submission from Forms.

Thanks Jerrell

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

rsaikrishna

3,703 on at

Like (0)

Report

@Jerrell

Use Convert Time Zone action to convert to get proper time.

https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

Was this reply helpful? Yes No

kmccarron76 3 on at

Like (0)

Report

Please share the flow.

Was this reply helpful? Yes No
Jerrell 8 on at

Like (0)

Report

Was this reply helpful? Yes No

Verified answer

rsaikrishna

3,703 on at

Like (0)

Report

@Jerrell

When the flow reads the date & time values as UTC values. You must change it to your local time by using Convert time zone action as shown below:

In the Base time field, place "Form Submission Date & Time" value.

In Source Time Zone: Select UTC as shown above.

In Destination time zone: Select your local time zone.

Format string as you want.

Give a try and post here.

Regards

Krishna Rachakonda

Was this reply helpful? Yes No

Jerrell 8 on at

Like (0)

Report

Your Solution works, Thank You!
It is very odd to me that I have 19 identical flows all working give me the correct times and this one flow I need to setup date and time formatting to get the correct time. I guess this will be the new normal/template for future flows of this type.

Thanks Again!

Was this reply helpful? Yes No