Unanswered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello @Anonymous ,
try to use the 'Convert time zone' action to convert the date.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Check your SharePoint regional settings as well.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No