Hi,
I have created a flow in power automate for vacation approval which begins in a Form and ends both in a calendar and a list in sharepoint. The problem is that the date ends up in the list in sharepoint one day before it realy is and I don't understand why. Every where else it is correctly.
Approvals:
Calendar:
list:
Thanks! that was it.
Hi @JII ,
The issue seems to be related to timezones.
SharePoint stores all its date/time fields in UTC time and then displays the corresponding local time based on the time zone in the Site setting.
SharePoint time, is not your time, is not their time. – Veni, Vidi, Vici (julieturner.net)
Maybe you could try to use the convertToUtc() function to convert the time zone.
convertToUtc('<timestamp>', '<sourceTimeZone>', '<format>'?)
Result Screenshots:
Best Regards,
Charlie Choi
And in the calendar the end date is wrong as well....
I think it might be with times, but forms does not allow me to select date and time and I don't know how to correct that in power automate so that the list and calendar end up correctly.