web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Convert to Australian ...

Power Automate

Unanswered

Convert to Australian Time/Date in one expression?

(0) Share

Report

Report

Posted on by Jayendwil

13

Can these two expressions be put together to form one expression? If so, could you please help 🙂

formatdatetime(addhours(utcnow(),'10') 'dd-MM-yyyy'

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (3)

Report
Hi @Jayendwil
very much you can

formatDateTime(addHours(utcNow(),3),'dd-MM-yyyy')

And also if you're looking for a specific time you can also try the below expression
formatDateTime(convertFromUtc(utcNow(),'AUS Eastern Standard Time'),'dd-MM-yyyy')
instead of adding hours to UTC
Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Was this reply helpful? Yes No
Jayendwil 13 on at

Like (0)

Report

Thank you, that has worked!!! @Shujaath_Khan

One more thing - Do you know why my input would show Aus Format, then the output shows Utc Format on my list?

Used this: formatDateTime(convertFromUtc(utcNow(),'AUS Eastern Standard Time'),'dd-MM-yyyy')

Was this reply helpful? Yes No
Verified answer

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (1)

Report

The expression shall give output in AUS specific time
and also if you've proper timezone time you don't need to use convert the time instead directly format and user it.
formatDateTime(variables('vardttime'),'dd-MM-yyyy')

and for SharePoint check column settings once
know more : https://docs.microsoft.com/en-us/troubleshoot/power-platform/power-automate/converting-time-zone-power-automate

Thanks

Was this reply helpful? Yes No

Join the conversation