Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 1s/L9yRgypCsq7OzO11kAS
Power Automate - General Discussion
Answered

MS Flow pulling wrong Date/Time

Like (1) ShareShare
ReportReport
Posted on 29 Dec 2020 21:56:13 by 373

I have a MS flow set up to end an email when an item is created or modified in a SharePoint list. The column date and time format with Standard display format.

 

In the Flow I use a Compose action with the following expression:

compose.png
 
 

The SharePoint list shows the following time: starttime.png

 

Flow is showing a different time: compose2.pngcompose2.png

 

 

What am I missing? Any assistance in this would be greatly appreciated!!

  • Verified answer
    leslie_rivera Profile Picture
    373 on 30 Dec 2020 at 21:44:12
    Re: MS Flow pulling wrong Date/Time

    I found the solution using Convert time zone

    leslie_rivera_0-1609364582176.png

     

    Base time = the column in my list "Start Time"

    Sourcetime zone = UTC

    Destination time zone = the time zone I am in which is MST

    Format string = how I want the output to look like

  • leslie_rivera Profile Picture
    373 on 30 Dec 2020 at 18:20:38
    Re: MS Flow pulling wrong Date/Time

    Sorry I need a little more hand holding than go watch this video.. thanks though.

  • RezaDorrani Profile Picture
    12,141 on 30 Dec 2020 at 16:03:05
    Re: MS Flow pulling wrong Date/Time

    Hi @leslie_rivera 

     

    Its in the link I provided.

    Here is the exact point - https://youtu.be/k-yIhdseTQE?t=1336

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

  • leslie_rivera Profile Picture
    373 on 30 Dec 2020 at 15:23:53
    Re: MS Flow pulling wrong Date/Time

    I thought thats what I was doing above. Do you have an example?

  • RezaDorrani Profile Picture
    12,141 on 30 Dec 2020 at 01:49:05
    Re: MS Flow pulling wrong Date/Time

    Hi @leslie_rivera 

     

    flow only works with dates and times in UTC format. So when it reads the date from SharePoint it gets it in UTC. 
    you would need to use expressions.

     

    check this flow expression video series -

    https://aka.ms/learnexpressions

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

    Thanks,
    Reza Dorrani, MVP
    YouTube
    Twitter

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,083 Most Valuable Professional

Leaderboard
Loading started