Skip to main content
Community site session details

Community site session details

Session Id : OkIwdot8SiJuyOofp3S3h7
Power Automate - Using Flows
Unanswered

Time Discrepancy: List Rows Present in a Table date/time output doesn't match the excel column time (adds 5 minutes)

Like (0) ShareShare
ReportReport
Posted on 24 May 2024 16:30:54 by 6

I have a flow where I use "List Rows Present in a Table". The table has date/time columns. When the flow runs, the output of this function shows a date/time that is 5 minutes later than the date time in the excel table columns.  Ex., if the excel table shows 2024-05-24 11:48, the flow output shows 2024-05-24T11:53:32.630Z.

Not sure if I'm doing something wrong?

 

Excel:

FlowExampleTableInput.JPG

 

Flow:

FlowExampleEdit.png

 

Output:

 FlowExampleOutput.png

  • Nived_Nambiar Profile Picture
    17,949 Super User 2025 Season 2 on 25 May 2024 at 16:42:38
    Re: Time Discrepancy: List Rows Present in a Table date/time output doesn't match the excel column time (adds 5 minutes)

    Hi @pbr_ 

     

    Note one point here- Power automate displays time mentioned in excel as UTC format when looking via flows 

    Time which you have mentioned - 2024-05-24T11:53:32.630Z is of UTC format

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete