Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

What is the Power Automate expression for today's date in NZ time?

Like (0) ShareShare
ReportReport
Posted on 26 Nov 2020 20:45:05 by

I want to update the file properties of the Date Published column with today's date (the date the flow runs) but it keeps returning US time, which is yesterday's date in NZ.  Here's what I've got:  None of the dynamic content is picking up on NZ time and I can't for the life of me work out the expression to return the date in NZ Time.

 

Screen Shot 2020-11-27 at 9.43.01 AM.jpg

  • Community Power Platform Member Profile Picture
    on 02 Dec 2020 at 21:16:54
    Re: What is the Power Automate expression for today's date in NZ time?

    Thanks, I tried that, I couldn't get the (UTC) Coordinated Universal Time without + or - hours option, it didn't work and the flow kept timing out as well, so I took it out.  Luckily there are only 2 fields to complete, so not a big deal to just put today's date in at the same time so we've decided to leave it at that. 

  • abm abm Profile Picture
    32,464 Most Valuable Professional on 26 Nov 2020 at 21:13:11
    Re: What is the Power Automate expression for today's date in NZ time?

    Hi @Anonymous 

     

    Check your SharePoint regional settings as well.

     

    Thanks

  • tom_riha Profile Picture
    10,093 Most Valuable Professional on 26 Nov 2020 at 21:07:14
    Re: What is the Power Automate expression for today's date in NZ time?

    Hello @Anonymous ,

    try to use the 'Convert time zone' action to convert the date.image.png

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 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…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 310 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 271 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 253

Overall leaderboard
Loading started