Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Converting Timezone for Perth Australia

Like (0) ShareShare
ReportReport
Posted on 1 Sep 2023 08:01:59 by 164

I am trying to convert a time (response from an approval) from UTC to the time in Perth Australia.

Here is my code:

 

convertTimeZone(outputs('Start_and_wait_for_an_approval_-_Approver_1')?['body/completionDate'], 'UTC', '(UTC+08:00) Perth', 'dd/MM/yyyy hh:mm')

 

I've tried:

  • (UTC+08:00) Perth
  • Australian Western Standard Time
  • AUS Western Standard Time (this was a guess, as Brisbane was AUS Eastern Standard Time)
  • AWST

All to no avail. Does anyone know what the values should be? 

 

Categories:
  • AngusWalker Profile Picture
    164 on 01 Sep 2023 at 16:26:36
    Re: Converting Timezone for Perth Australia

    @LaurensM You're a life saver.
    Thanks.

  • Verified answer
    LaurensM Profile Picture
    12,510 Super User 2025 Season 1 on 01 Sep 2023 at 08:17:25
    Re: Converting Timezone for Perth Australia

    Hi @AngusWalker,

     

    The following code should do the trick:

     

    convertTimeZone(
     outputs('Start_and_wait_for_an_approval_-_Approver_1')?['body/completionDate'], 
     'UTC',
     'W. Australia Standard Time',
     'dd/MM/yyyy hh:mm'
    )

     

    If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

    Thanks!

  • v-mingkz-msft Profile Picture
    Microsoft Employee on 01 Sep 2023 at 08:16:38
    Re: Converting Timezone for Perth Australia

    Hi @AngusWalker ,

    Please try

    Text(DateAdd( outputs('Start_and_wait_for_an_approval_-_Approver_1')?['body/completionDate'], −TimeZoneOffset( outputs('Start_and_wait_for_an_approval_-_Approver_1')?['body/completionDate']), TimeUnit.Minutes ),'dd/MM/yyyy hh:mm')

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard
Loading started
Loading started