Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

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

Timezones of the timestamp

(0) ShareShare
ReportReport
Posted on 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 at
    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 at
    Re: Timezones of the timestamp

    @v-monli-msft

     

    any eta for conversions for specified time zones?

  • KoichiAkamine Profile Picture
    KoichiAkamine 4 on at
    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 at
    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

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,658 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans