You’re offline. This is a read only version of the page.
193
Just as the topic title reads, I setup a flow which adds a row to an existing sheet. Everything seems good to go except that it appears to be returning the data with a time which is 4 hours later as if its transposed to PST from the native EST.
Below I've entered an example:
| Forms Results Data | Flow Return Data |
| 3/31/20 19:53:30 | 3/31/2020 23:53 |
| 3/31/20 20:37:38 | 4/1/2020 0:37 |
| 3/31/20 20:55:12 | 4/1/2020 0:55 |
| 3/31/20 21:06:05 | 4/1/2020 1:06 |
| 3/31/20 22:00:52 | 4/1/2020 2:00 |
This is a really straight forward flow, but this is also my first one. Maybe I'm missing something simple.
@RodM Microsoft products don't always store data data in the same format. The data in the top cell is in normal Excel date format although it actually stores it as an integer. The cell below it is in Universal Coordinated Time (UTC) format.
Rob
Los Gallardos
@RodM I have the same experience (as I think most users do) with the timezone issue.
Many Microsoft apps, tools, and sites default to Pacific time unless otherwise formatted.
It isn't very convenient for those of us in any other timezone, but it is reality.
thanks,
Kyle
Hi @RodM ,
You could format the date time with expression below:
Share
Report
All responses (
Answers (
formatDateTime(addHours(outputs('Compose'),-4),'MM/dd/yyyy HH:mm')
If your problem is solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is now how the data is returned for the same flow:
| 17956 | 4/6/2020 13:29 |
| 17956 | 2020-04-06T09:29:03.0000000 |
The data displayed is a weird format. Any more suggestions on how to get it to show as the top cell?
Your help is greatly appreciated so far. Any understanding why any of this is needed in the first place?
Hi @RodM ,
Please refer to my screenshot and take a try again.
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RodM ,
Have you add a Compose action to save the Date time?
Please share the screenshot of the flow when the flow would run fail.
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RodM ,
Please refer to screenshot below to create the flow:
Expression in the flow:
addHours(outputs('Compose'),-4)
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
