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?
Solved! Go to 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.
Result Screenshots:
Best Regards,
Charlie Choi
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.
Result Screenshots:
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!
User | Count |
---|---|
88 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |