You’re offline. This is a read only version of the page.
Announcements
2
Hi,
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,
@equals(item()?['Item_x0020_Expires_x0020_On'],utcnow('yyyy-MM-dd')).
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
Ravi
Hi,
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?
Reference:
https://msdn.microsoft.com/en-us/library/system.timezone.tolocaltime(v=vs.110).aspx
Thanks
Share
Report
All responses (
Answers (
