Forum Discussion

0R1N7766's avatar
0R1N7766
Copper Contributor
May 30, 2022

MS Lists time zone issue

Hi everyone,

 

Currently I'm using Power Automate, to import every new MS Form response to my Lists.

I know that the MS Form's "Completion time" is based on UTC +0.

So I converted my "Completion time" from UTC +0 to UTC +8 (where I located)

 

For example:

Form No. 43 is completed on 5/30/22 06:41 (UTC+0), I should have successfully converted that to 5/30/22 14:41 (UTC+8)

And when I did a test in Power Automate for this flow. I also observed the Output to be "5/30/22 14:41"

But when I checked the Lists, it's actually showing: 05/30 9:41, with a -5 hour time gap to my output, 14:41. Below is the screenshot:

I had checked my account setting and my region is in UTC+8.

 

I would like to know why that Lists is showing my output differently. And what causes this 5 hour gap.  I know maybe I can just add 5 hour to the time, but there should be a root cause for this. If you know the answer please kindly help, thank you in advance!

 

 

 

4 Replies

Resources