Why would my time be off by 12 hours using this in SharePoint Online?
formatDateTime(triggerBody()?['Start'],'HH:mm')
Hi @ msmith,
The time in Microsoft Flow are in Universal Time (UTC) by default, so the time in your SharePoint Online would display the UTC time by default and the time in the SharePoint Online would 5 hours earlier than your local time.
You could refer to link below to learn more about the UTC time in Microsoft flow:
https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
Regards,
Alice Zhang
I don't know why I said 12 hours off, it is more like 5 hours off. I don't seem to have an option to add any pictures. I just checked on 4 different browsers.
I used the compose action with the the following expression.
formatDateTime(triggerBody()?['Start'],'HH:mm')
Hi @ msmith,
Could you please share a screenshot of the configuration of your flow?
Could you explain more about your issues?
Do you mean the time in the SharePoint Online would 12 hours earlier than your local time?
All times in Microsoft Flow are in Universal Time (UTC) by default.You could refer to link below to learn more about the UTC time in Microsoft flow:
https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
Regards,
Alice Zhang
Central time
Date & Time coming from SharePoint Online to Flow are always in UTC; where is your SharePoint online (UTC zone) ?