cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Flow Button generates inconsistent date (UTC) vs timestamp (local time)

I'm trying to use some of the parameters from the Flow Button, but I've noticed that the datetime values it generates are inconsistent:

 

key-button-timestamp shows me current timezone time

key-button-date shows me UTC date.

 

Is this behavior intentional?

 

Flow-button-date-utc.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Flow Button generates inconsistent date (UTC) vs timestamp (local time)

Hi @michowl,

 

The behavior you observed is by design. The initial idea was to have the date in UTC to get a unifor representation. However, we are now considering changing that to avoid cunfusion.

 

Thanks for your input,

-nimrod

View solution in original post

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: Flow Button generates inconsistent date (UTC) vs timestamp (local time)

Hi Michowl,

 

We have successfully reproduced this issue. I have submitted this to the product team. They will have a look into this.

 

Thanks for reporting.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Microsoft
Microsoft

Re: Flow Button generates inconsistent date (UTC) vs timestamp (local time)

I'm also unable to extract the timezone information from the timestamp, even though it's local time.

formatDate(triggerBody()['timestamp'],'zzzzzz') returns +00:00 when it should be -08:00

Highlighted
Microsoft
Microsoft

Re: Flow Button generates inconsistent date (UTC) vs timestamp (local time)

Hi @michowl,

 

The behavior you observed is by design. The initial idea was to have the date in UTC to get a unifor representation. However, we are now considering changing that to avoid cunfusion.

 

Thanks for your input,

-nimrod

View solution in original post

Highlighted
Frequent Visitor

Re: Flow Button generates inconsistent date (UTC) vs timestamp (local time)

Even I'm facing same issue, dates show is UTC, where as what I want is local time.

Highlighted
Anonymous
Not applicable

Re: Flow Button generates inconsistent date (UTC) vs timestamp (local time)

I'm also having the same issue.

 

My Flow works this way:

1. Trigger from button

2. Get timestamp and inset timestamp into Excel row

 

Inputs: 2017-04-19T13:57:07+10:00

Output: 2017-04-19T03:57:07Z

 

 

The correct time should be the input value (13:57)

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,221)