cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KoichiAkamine
Regular Visitor

Timezones of the timestamp

Is it able to control timezone of the timestamp of a Flow press-button event ?

And if it is possible, could you tell me what I should do ?

 

 

I created a Flow that when a user press the Flow Button, runs actions below:

  1. Send an email: body contains timestamp of the press-button event.
  2. Create a SharePoint list item with the data: saves timestamp of the press-button event to a field of single-line text.

Checking the email and the list item, timestamps are displayed with 2 different timezones.

When I pressed the button on 2017-07-19  18:03:01 (+0900, Japanese Standard Time), timestamp is shown:

  • Email: 2017-07-19T18:03:01
  • SharePoint list item: 07/19/2017 02:03:01

"07/19/2017 02:03:01" is PDT (-0700) when it's "2017-07-19T18:03:01" in Japanese JST.

 

I want both to show in JST.

 

Another factor(s)

  • The site collection that contains the list was created with timezone PDT, and after creation, modified to JST.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

Hi @KoichiAkamine,

 

So far flow will return timestamp in UTC. To correct it to your timezone, you could add a compose action and modify the timestamp using formatDateTime as documented at https://docs.microsoft.com/en-us/rest/api/logic/definition-language

 

We are considering conversions to specified time zones in the future, as a function or as an extra action. Please stay tuned!

 

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.

View solution in original post

4 REPLIES 4
v-monli-msft
Community Support
Community Support

Hi @KoichiAkamine,

 

So far flow will return timestamp in UTC. To correct it to your timezone, you could add a compose action and modify the timestamp using formatDateTime as documented at https://docs.microsoft.com/en-us/rest/api/logic/definition-language

 

We are considering conversions to specified time zones in the future, as a function or as an extra action. Please stay tuned!

 

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.

View solution in original post

Hi @v-monli-msft

 

Thank you very much, I succeeded to disply in JST.

(Calculated timezone of Japan +0900 with addHours. Argument 9 for addHours was hard-coded, but OK because the flow is used only in Japan.)

@v-monli-msft

 

any eta for conversions for specified time zones?

Thank you. That doesnt seem simple. Could you write a template of such a compose action returning any date format but with timeoffset calculated properly?

utcNow() returns also hour offset?

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (29,953)