Skip to main content

Notifications

Community site session details

Community site session details

Session Id : EGUNnu5DMHVcfD4kkHVs7g
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 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
    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
    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
    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

Quick Links

Understanding Microsoft Agents - Introductory Session

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

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,662 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard