web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Timezones of the times...
Power Automate
Answered

Timezones of the timestamp

(0) ShareShare
ReportReport
Posted on by 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.

 

Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    Microsoft Employee on at

    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

  • KoichiAkamine Profile Picture
    4 on at

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

  • Grahambo05 Profile Picture
    106 on at

    @v-monli-msft

     

    any eta for conversions for specified time zones?

  • katonage Profile Picture
    71 on at

    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?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard