web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Microsoft Forms flow t...
Power Automate
Answered

Microsoft Forms flow to Excel returns later date/time

(0) ShareShare
ReportReport
Posted on by 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 DataFlow Return Data
3/31/20 19:53:303/31/2020 23:53
3/31/20 20:37:384/1/2020 0:37
3/31/20 20:55:124/1/2020 0:55
3/31/20 21:06:054/1/2020 1:06
3/31/20 22:00:524/1/2020 2:00

 

This is a really straight forward flow, but this is also my first one. Maybe I'm missing something simple.

Categories:
I have the same question (0)
  • v-alzhan-msft Profile Picture
    Microsoft Employee on at

    Hi @RodM ,

     

    Could you please share a screenshot of the configuration of your flow?

    I'm afraid that it is caused by the time zone difference between your local time and the utc time.

    If the returned date would always 4 hours late than the expected date time, could you please take a try to add -4 hours to the date time before insert it to the excel table?

     

    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 Profile Picture
    193 on at

    https://ibb.co/2ZTb4Nm 

     

    There is a link to the flow image.

  • RodM Profile Picture
    193 on at

    Capture3.JPG

  • RodM Profile Picture
    193 on at

    @v-alzhan-msft wrote:

    Hi @RodM ,

     

    Could you please share a screenshot of the configuration of your flow?

    I'm afraid that it is caused by the time zone difference between your local time and the utc time.

    If the returned date would always 4 hours late than the expected date time, could you please take a try to add -4 hours to the date time before insert it to the excel table?

     

    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.


    How would I add hours to the return time within the flow?

  • v-alzhan-msft Profile Picture
    Microsoft Employee on at

    Hi @RodM ,

     

    Please refer to screenshot below to create the flow:

    1.png

     

    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.

  • RodM Profile Picture
    193 on at

    The expression provided caused the flow to fail.

     

    Here is another screenshot of my flow:

     Capture4.JPG

     

     

  • v-alzhan-msft Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    193 on at

    Capture5.JPG

  • v-alzhan-msft Profile Picture
    Microsoft Employee on at

    Hi @RodM ,

     

    1.png

    Please refer to my screenshot and take a try again.

    2.png

     

    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 Profile Picture
    193 on at

    This is now how the data is returned for the same flow:

     

    179564/6/2020 13:29
    179562020-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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 248 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 160 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 142 Super User 2026 Season 2

Last 30 days Overall leaderboard