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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Date Comparison Error ...
Power Automate - Building Flows
Suggested answer

Date Comparison Error in Condition

(0) ShareShare
ReportReport
Posted on by JM-18112356-0

I’m creating a flow to send reminder emails when:

  • Meeting date is within 5 days
  • Pre-meeting materials = No
  • Sign-up status = Filled
 
SharePoint columns:
  • Date_x002f_TimeofMeeting (Date/Time)
  • Pre_x0024_MeetingMaterialsSent (Yes/No)
  • Sign_x0024_upStatus (Choice)
 
Condition setup in Basic Mode:
 
  • Row 1: Date_x002f_TimeofMeeting → is less or equal to → addDays(utcNow(), 5)
  • Row 2: Pre_x0024_MeetingMaterialsSent → is equal to → No
  • Row 3: Sign-up Status: Value → is equal to → Filled
 
Error Message: "Comparing a numeric value with a non-numeric value is not supported."
 

Tried:


  • formatDateTime(addDays(utcNow(), 5), 'yyyy-MM-ddTHH:mm:ssZ')

  • ticks(addDays(utcNow(), 5))

  • string(ticks(addDays(utcNow(), 5)))
 
I am still learning how to make flows so any insight is helpful. I need to make this one and another one that does something very similar but it would be the opposite where it would be 5 days after a meeting date happens.
Categories:
Business Process Flows
PA Screenshot of ...
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 52,323 Super User 2025 Season 2 on at
    Date Comparison Error in Condition
     
    WAIT: Is this from Excel???? if so then thats the problem, the left side would be a numeric due to non-conversion to 8601 and the right side would be a Date so it would fail (aka non-numeric).. if this is excel thats why
     
    So when I look Date_x002f_TimeofMeeting → is less or equal to → addDays(utcNow(), 5)
     
    A couple of things sorry for the color.
     
    Is DateTime actually a Date or is it a string, can you verify for sure because 
     
    Either way is less or equal to is expecting an int value. 
     
    Is the addDays was that typed into an Expression? because it doesn't look like it should in the Ux.
     
     

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

News and Announcements

Welcome to the Power Platform Communities
Coming soon: forum hierarchy changes
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 535 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 348 Moderator

#3
developerAJ Profile Picture

developerAJ 262

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans