Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

PowerAutomate time zone incorrect

(0) ShareShare
ReportReport
Posted on by

The Created Date in my flow shows the wrong time.  Is this a regional setting that needs to be changed in the Admin Center? 

 

I see lots of posts about using the Convert Time Zone action in my Flow, which I have tried but it doesn't change the Date Created on the flow.  This isn't a date that I'm specifying in my Flow, it's a system created date so I'm assuming it's getting it from the PowerAutomate servers.
That date shows in GMT time, it should be Eastern Time (US and Canada).

 

FlowDateCreated.jpg

  • TheRobRush Profile Picture
    TheRobRush 11,121 on at
    Re: PowerAutomate time zone incorrect

    you might check the settings in your personal instance of teams, and outlook, sharepoint anywhere else. As far as I understand office always stores times in utc but you can change the settings in your individual apps and it will then show the way you want them to.

     

    theres probably a way to force the default setting in each users app but I am not personally aware of how to do that.

  • Jambou Profile Picture
    Jambou on at
    Re: PowerAutomate time zone incorrect

    Would you happen to know where that setting is located?  Is it in the PowerAutomate Admin Center?
    We are new to Office365 and I'm not sure where to look.

  • TheRobRush Profile Picture
    TheRobRush 11,121 on at
    Re: PowerAutomate time zone incorrect

    Yah, it is by default showing Universal Time (aka gmt or Greenwich mean time), which depending on time of year (DST) can be off by either 4 or 3 for EST, here in PST we are off it by 7 or 8. If your entire company is located where you are, you might have them change that

  • Jambou Profile Picture
    Jambou on at
    Re: PowerAutomate time zone incorrect

    Ok, so that appears to be set at the server admin level.  There must be a way to change this because my time is off by 4 hours so it can sometimes show the Created Date as the next day...which is not ideal.

  • TheRobRush Profile Picture
    TheRobRush 11,121 on at
    Re: PowerAutomate time zone incorrect

    Though, to add to that, in my email, and in my teams anytime i create a request and receive it, it shows in proper timezone form my company. So I think they have may have added ability to set default but it's probably at the environment/server admin level

  • Verified answer
    TheRobRush Profile Picture
    TheRobRush 11,121 on at
    Re: PowerAutomate time zone incorrect

    Apologies, did not look at which display date you were trying to change, and was just giving you one you could store / reference later if you want.

     

    The one you are referencing is actually always going to show UTC and cannot be changed, see here around 9:31 where @RezaDorrani  shows the process and mentions this limitation

  • Jambou Profile Picture
    Jambou on at
    Re: PowerAutomate time zone incorrect

    Hi TheRobRush,

     

    I must be missing something, I've been trying to do what you have described and it doesn't change the date/time.  After I add the "Convert Time zone" action, do I have to do anything else?

     

    Here is a screen shot of my flow:

    FlowDateCreated2.jpg

  • TheRobRush Profile Picture
    TheRobRush 11,121 on at
    Re: PowerAutomate time zone incorrect

    In the beginning of your flow set a convert time control like this

    TheRobRush_1-1680537980945.png

     

    TheRobRush_0-1680537927845.png

     

    in base time put the expression (click in box that pops up to right)

    TheRobRush_3-1680538119929.png

     

    formatDateTime(utcNow(), 'g')

     

    then just set format to how you would like it to look,

    source time zone to UTC

    and destination to UTC-5 Eastern

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard