Showing results for 
Search instead for 
Did you mean: 
New Member

UtcNow and SharePoint Online List's Date Column


I am using flow in Australia.


I have a SharePoint Online List that has an Expiry Date. I have configured Flow to send emails to responsible officers every morning using a condition: If the expiry date is today.

I have used the following syntax,



It appears to be working but the officers are receiving the email a day before the expiry date. If the expiry date is 13th, the emails are getting sent out on the 12th itself.. Iis this due to the utcnow() ? 

Please not that our tenant was hosted in South East Australia and regioinal settings in sharepoint were set to Melbourne, Australia.


Any help would be greatly appreciated.


Thank you


Super User III
Super User III



Can try converting the UTC to localtime using TimeZone.CurrentTimeZone.ToLocalTime(utcnow('yyyy-MM-dd')). I haven't tested this so not sure this is going to work or not?






Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up

Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Helpful resources

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (34,865)