Contents
Also, the Z you see at the end of the timestring in Flow says that time is being shown in UTC. So if you input that into a SharePoint list it will display in SharePoint as 8 hours earlier (PST is -8 from UTC). I suspect that is what you are seeing. If I have answered your question, please mark your post as Solved.
According to your description, it seems that you are using the SharePoint Calendar list, and you are trying to add the item in another SharePoint list within the same site. So I create a flow likes below to test this issue. When the flow is triggered, the item created in another list has the same End time and Start time with the Calendar list.
Why is the time shown as 8 hours earlier in SharePoint?
Also, the Z you see at the end of the timestring in Flow says that time is being shown in UTC. So if you input that into a SharePoint list it will display in SharePoint as 8 hours earlier (PST is -8 from UTC). I suspect that is what you are seeing.
Go to Solution. 11-15-2019 12:17 PM Check the regional settings in the Site Collection settings in SharePoint. SharePoint online normally defaults to whatever timezone the server is in unless you change the regional settings for the site collection. For me that means Pacific Time, even though my local time zone is Eastern US.
So this issue isn’t caused by the SharePoint settings or the user profile settings, the Microsoft Flow template may actually caused this issue, as the items are created by it. In this case, I’d suggest that you may post this issue in the Microsoft Flow Community to get dedicated support from our Microsoft Flow specialists.
How to import dates from Excel into SharePoint list?
Aug 27 2020 04:38 AM @TSimsD Excel stores dates as an integer of the number of days since 30 December 1899. So you need to convert that integer to a date before your flow can use the output in SharePoint. So you will need to add Compose control. The table in my spreadsheet has a column called Time: