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

Announcements

News and Announcements icon
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 8
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
    14,485 Super User 2026 Season 1 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
    8 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 976

#2
Valantis Profile Picture

Valantis 863

#3
Haque Profile Picture

Haque 547

Last 30 days Overall leaderboard