Answered

PowerAutomate time zone incorrect

Like (0) Share

Report

Posted on 3 Apr 2023 15:53:55 by Jambou

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).

I have the same question (0)

All responses (8)

Answers (1)

TheRobRush 11,123 Moderator on 03 Apr 2023 at 16:09:13

Like (0)

Report
Re: PowerAutomate time zone incorrect

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

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

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

Was this reply helpful? Yes No
Jambou on 03 Apr 2023 at 17:18:54

Like (0)

Report

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:

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,123 Moderator on 03 Apr 2023 at 17:36:17

Like (0)

Report

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

Was this reply helpful? Yes No
TheRobRush 11,123 Moderator on 03 Apr 2023 at 17:39:18

Like (0)

Report

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

Was this reply helpful? Yes No
Jambou on 03 Apr 2023 at 17:47:04

Like (0)

Report

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.

Was this reply helpful? Yes No
TheRobRush 11,123 Moderator on 03 Apr 2023 at 17:49:32

Like (0)

Report

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

Was this reply helpful? Yes No
Jambou on 03 Apr 2023 at 17:56:22

Like (0)

Report

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.

Was this reply helpful? Yes No
TheRobRush 11,123 Moderator on 03 Apr 2023 at 18:15:38

Like (0)

Report

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.

Was this reply helpful? Yes No