Afternoon
I have a holiday approval flow running. It fires when a user selects a date in a SP list. The approval works fine but when the data comes through the day before is showing, so when an Outlook event is created it's the wrong date. Is there a regional date setting in Power Automate I can check, or has anyone encountered this before?
Thanks in advance.
You Can also use Convert time zone action instead of expression.
please Share your convert time zone expression. Correct way to use it in expression-
convertTimeZone(utcnow(),'UTC','India Standard Time','dd/MM/yyyy')
Thanks
Hardesh
I'm getting the following error: Unable to process template language expressions for action 'Convert_time_zone_2' at line '1' and column '35910': 'The template language function 'converttimezone' expects its fourth parameter to be a string that contains a date time format. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#ConvertTimeZone for usage details.'.
Thanks @Hardesh15 I'll try it out and check back in
Select Source time : Coordinated Universal Time
Then check if it solves your problem.
Thanks
Hardesh
Thanks @Hardesh15
The SP site is set to London UTC as is Outlook, so I'm a little confused as to what and how I convert the dates to. I've configured the action as below but I'm not sure of it.
Two things-
1. SharePoint site regional settings.
2. Flow uses UTC time zone. it is advised that use convert time zone action or function in expression.
Thanks
Hardesh