web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : xdYZeXMnNEvtC9DKOFR4Gy
Power Platform Community / Forums / Power Automate - Using Flows / Timezones of the times...
Power Automate - Using Flows
Answered

Timezones of the timestamp

Like (0) ShareShare
ReportReport
Posted on 19 Jul 2017 09:24:55 by KoichiAkamine 4

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.

 

  • katonage Profile Picture
    katonage 71 on 15 Sep 2017 at 20:38:21
    Re: Timezones of the timestamp

    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?
  • Grahambo05 Profile Picture
    Grahambo05 106 on 14 Sep 2017 at 19:29:03
    Re: Timezones of the timestamp

    @v-monli-msft

     

    any eta for conversions for specified time zones?

  • KoichiAkamine Profile Picture
    KoichiAkamine 4 on 28 Jul 2017 at 09:56:02
    Re: Timezones of the timestamp

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

  • Verified answer
    v-monli-msft Profile Picture
    v-monli-msft on 20 Jul 2017 at 09:59:43
    Re: Timezones of the timestamp

    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

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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans