Microsoft Forms flow to Excel returns later date/time

Like (0) Share

Report

Posted on 1 Apr 2020 03:27:11 by RodM

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.

All responses (14)

Answers (1)

RobElliott 10,166 Super User 2025 Season 2 on 14 May 2020 at 13:37:50

Like (1)

Report

Re: Microsoft Forms flow to Excel returns later date/time

@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
Community Power Pla... on 14 May 2020 at 13:30:27

Like (1)

Report

Re: Microsoft Forms flow to Excel returns later date/time

@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
RodM 193 on 07 Apr 2020 at 16:49:25

Like (0)

Report

Re: Microsoft Forms flow to Excel returns later date/time

Thank you for all of your help.

I would appreciate some insight as to why the problem occurs in the first place, but I'm thankful nonetheless.
Verified answer

v-alzhan-msft on 07 Apr 2020 at 05:06:45

Like (1)

Report
Re: Microsoft Forms flow to Excel returns later date/time

Hi @RodM ,

You could format the date time with expression below:

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.
RodM 193 on 06 Apr 2020 at 13:36:22

Like (0)

Report

Re: Microsoft Forms flow to Excel returns later date/time

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?
v-alzhan-msft on 06 Apr 2020 at 01:45:25

Like (1)

Report

Re: Microsoft Forms flow to Excel returns later date/time

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.
RodM 193 on 03 Apr 2020 at 12:15:41

Like (0)

Report

Re: Microsoft Forms flow to Excel returns later date/time
v-alzhan-msft on 03 Apr 2020 at 01:25:10

Like (1)

Report

Re: Microsoft Forms flow to Excel returns later date/time

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.
RodM 193 on 02 Apr 2020 at 16:27:12

Like (0)

Report

Re: Microsoft Forms flow to Excel returns later date/time

The expression provided caused the flow to fail.

Here is another screenshot of my flow:
v-alzhan-msft on 02 Apr 2020 at 01:34:01

Like (1)

Report
Re: Microsoft Forms flow to Excel returns later date/time

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.