cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Michal
Kudo Collector
Kudo Collector

Time shifted 2h ahead when saving in the date/time field in SharePoint

Have a strange problem.

I'm downloading data from Incoming Webhook, from the Teams channel, with the date/time in the UTC format.

I convert it to CEST (as shown in the screenshot) and save it to the SharePoint list in two fields (text and date/time format field).

I have the correct date in the text field but the time in the date/time field is shifted two hours ahead.
The Time Zone for the site is UTC + 01, the same as my Time Zone in my M365 profile.
Do you have any ideas about what it might be?

 

 

d740c07a-492f-48f1-8c34-15aad2eee8bf.png

e30e2965-bca0-4e9c-916f-781ab08e2e84.png

3q.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi  @Michal , 

 

Maybe it's caused by the fact that the timestamp passed by flow to the SharePoint list is in UTC format.

vyujincuimsft_0-1651137643879.png

In addition, i have made a test for your reference.

addHours(formatDateTime(timestamp,'yyyy-MM-ddThh:mm:ss'),2)
formatDateTime(timestamp,'yyyy-MM-ddThh:mm:ss')
vyujincuimsft_0-1651138255715.png

 

Result Screenshots:

vyujincuimsft_2-1651137924489.png

Best Regards,

Charlie Choi

View solution in original post

2 REPLIES 2
v-yujincui-msft
Community Support
Community Support

Hi  @Michal , 

 

Maybe it's caused by the fact that the timestamp passed by flow to the SharePoint list is in UTC format.

vyujincuimsft_0-1651137643879.png

In addition, i have made a test for your reference.

addHours(formatDateTime(timestamp,'yyyy-MM-ddThh:mm:ss'),2)
formatDateTime(timestamp,'yyyy-MM-ddThh:mm:ss')
vyujincuimsft_0-1651138255715.png

 

Result Screenshots:

vyujincuimsft_2-1651137924489.png

Best Regards,

Charlie Choi

Thx @v-yujincui-msft,

so what you are saying is that whatever time/date I pass to SPO list it should be in the UTC format?

Well, it seems you are right. 

Case fixed. Thank you!

21.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,519)