Answered

Power automate flow filling a list in sharepoint

(0) Share

Report

Posted on by JII

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:

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

JII 22 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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>'?)

https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/default-time-zones?view=windows-11#time-zones

Result Screenshots:

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
JII 22 on at

Like (0)

Report
Copy link

Link copied!

Thanks! that was it.

Was this reply helpful? Yes No