You’re offline. This is a read only version of the page.
8
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
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!
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
| 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. |
Please share the flow.
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. |
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
