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

(0) Share

Report

Posted on by pbr_

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:

Flow:

Output:

All responses (1)

Answers (0)

Nived_Nambiar 17,497 Super User 2025 Season 1 on at

Like (0)

Report

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! 🙌