cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JII
Regular Visitor

Power automate flow filling a list in sharepoint

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:

JII_0-1660310653719.png

Calendar:

JII_1-1660310696715.png

list:

JII_2-1660310740660.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

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=window... 

vyujincuimsft_0-1660638257870.png

Result Screenshots: 

vyujincuimsft_1-1660638257873.png

vyujincuimsft_2-1660638257875.png

 

 

 

Best Regards, 

Charlie Choi 

View solution in original post

3 REPLIES 3
JII
Regular Visitor

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.

v-yujincui-msft
Community Support
Community Support

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=window... 

vyujincuimsft_0-1660638257870.png

Result Screenshots: 

vyujincuimsft_1-1660638257873.png

vyujincuimsft_2-1660638257875.png

 

 

 

Best Regards, 

Charlie Choi 

Thanks! that was it.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,564)