Skip to main content

Notifications

Power Automate - General Discussion
Answered

Time Format

(0) ShareShare
ReportReport
Posted on by

Why would my time be off by 12 hours using this in SharePoint Online?

 

formatDateTime(triggerBody()?['Start'],'HH:mm')
Categories:
  • Verified answer
    v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: Time Format

     

     

    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

  • Re: Time Format

    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')

     

     

     

  • v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: Time Format

    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

  • Re: Time Format

    Central time

  • sergeluca Profile Picture
    sergeluca 500 on at
    Re: Time Format

    Date & Time coming from SharePoint Online to Flow are always in UTC; where is your SharePoint online (UTC zone) ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard