Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id : 7q2JgCNFTm724pnnVGex6o
Power Platform Community / Forums / Power Automate - Building Flows / Convert to Australian ...
Power Automate - Building Flows
Answered

Convert to Australian Time/Date in one expression?

Like (0) ShareShare
ReportReport
Posted on 8 Jul 2022 00:27:48 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'

  • Verified answer
    Shujaath_Khan Profile Picture
    Shujaath_Khan 1,111 Super User 2024 Season 1 on 08 Jul 2022 at 06:10:53
    Re: Convert to Australian Time/Date in one expression?

    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

  • Jayendwil Profile Picture
    Jayendwil 13 on 08 Jul 2022 at 05:24:00
    Re: Convert to Australian Time/Date in one expression?

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

    Australian Format.png

  • Verified answer
    Shujaath_Khan Profile Picture
    Shujaath_Khan 1,111 Super User 2024 Season 1 on 08 Jul 2022 at 04:16:45
    Re: Convert to Australian Time/Date in one expression?

    Hi @Jayendwil 

    very much you can

     

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

     

     

    Shujaath_Khan_0-1657253787379.png

     

    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.

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

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

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 > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 130 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 125

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 112 Super User 2025 Season 1

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans