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

Like (0) Share

Report

Posted on 26 Nov 2020 20:45:05 by Community Power Pla...

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

All responses (3)

Answers (0)

Community Power Pla... on 02 Dec 2020 at 21:16:54

Like (0)

Report

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 32,464 Most Valuable Professional on 26 Nov 2020 at 21:13:11

Like (1)

Report

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 10,085 Most Valuable Professional on 26 Nov 2020 at 21:07:14

Like (1)

Report

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.