News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Converting Timezone fo...

Power Apps - Building Power Apps

Answered

Converting Timezone for Perth Australia

Like (0) Share

Report

Report

Posted on 1 Sep 2023 08:01:59 by AngusWalker

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:

General Questions

All responses Img

All responses (3)

Answers Img

Answers (1)

AngusWalker 164 on 01 Sep 2023 at 16:26:36

Like (0)

Report

Re: Converting Timezone for Perth Australia

@LaurensM You're a life saver.
Thanks.
Verified answer

LaurensM 12,510 Super User 2025 Season 1 on 01 Sep 2023 at 08:17:25

Like (1)

Report
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 Microsoft Employee on 01 Sep 2023 at 08:16:38

Like (1)

Report
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')