web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Issues matching date o...
Power Automate
Answered

Issues matching date on excel to utcNow

(0) ShareShare
ReportReport
Posted on by 4
I have a flow setup based on an excel sheet to pull data.
 
It is a recurring flow (check once a day).
 
It pulls data from an Excel file using 'List rows present in table'
 
This file has several rows so then I have the Apply to each  with a Condition. As you can see I am pulling a dynamic date (format- yyyy-mm-dd) and comparing it to the utcNow per below. 
 
 
The issue is this error. I have tried adjusting as much as I can but I have no idea why this is occurring. I used to have this working as utcNow('yyyy-MM-dd') but I have to move this to a new account (old work email vs new) and this is what I'm getting. Basically if the condition is met (Run Date is today), then it send out an email. 
 
How do I resolve this?
 
Categories:
I have the same question (0)
  • Verified answer
    David_MA Profile Picture
    13,383 Super User 2025 Season 2 on at
    In the Excel action, do you have the Date Time Format set to ISO 8601? If not, set it to this:
     
     
    Although, based on the error message, I think the issue may be something else. What do you have the condition connected to? Based on your screen shot, it does not look like a value from the Excel spreadsheet. 
  • Suggested answer
    RR-03021712-0 Profile Picture
    4 on at
    Yes, This was one of the adjustments I made, didn't help

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 392 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 284 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 202 Most Valuable Professional

Last 30 days Overall leaderboard