May 30 2022 12:19 AM
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!
Mar 01 2023 09:49 PM
@0R1N7766 have we addressed this? I encountered a similar issue now.
Mar 03 2023 01:16 AM
Check this article to understand how date/time columns work in SharePoint: https://julieturner.net/post/sharepoint-datetime/
Similar thread: https://sharepoint.stackexchange.com/questions/283444/why-does-the-sp-sod-executefunc-function-not-w...
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
Mar 03 2023 02:13 AM
Hi @0R1N7766 ;
i don't think you need to do the time conversion....
You get the time from MS Forms as UTC.
Just save that into your SharePoint list.
The regional settings of your SharePoint site will now take care of the time conversion to Taipei time.
Best Regards,
Sven