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

[Michal]

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?

 

 

 

[v-yujincui-msft · Accepted solution]

Hi  @Michal , 

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

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')

Result Screenshots:

Best Regards,

Charlie Choi

[Michal]

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!