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 / Date condition always ...
Power Automate
Answered

Date condition always FALSE

(0) ShareShare
ReportReport
Posted on by 12

Hi there, 

 

I'm trying to create a simple flow that sends an email based on a date within an Excel column named "Richiesta CV2", so I set up a conditional to check when the values (dates) in the "Richiesta Cv2" column are equal to today, if YES send an email.

However, I seems that the condition never results in "true", therefore the email is not sent.

This is the flow I created:

Screenshot 2023-10-17 163023.pngScreenshot 2023-10-17 163120.pngFrom the Compose action, the output seems to be correct (the date from the "Richiesta CV2" column) but the Conditional is still "false".

Screenshot 2023-10-17 163219.pngScreenshot 2023-10-17 163239.png Hope anyone can help, thanks in advance! Bye!

Categories:
I have the same question (0)
  • Verified answer
    wskinnermctc Profile Picture
    6,519 Moderator on at

    The condition is comparing text strings.

    "2023-10-17T00:00:00.000Z" does not equal "2023-10-17"

     

    Also the utcNow('yyyy-mm-dd') is incorrect since "mm" is minute. You need to have "MM" for months.

    utcNow('yyyy-MM-dd') is 'year-month-day'

    utcNow('yyyy-mm-dd') is 'year-minute-day'

     

    So you need to format the outputs of the Excel to be the same as the utcNow().

    formatDateTime(outputs('Compose'),'yyyy-MM-dd') is equal to utcNow('yyyy-MM-dd')

  • AnnaC Profile Picture
    12 on at

    Thank you very much, with your corrections the flow works perfectly.

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 62 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 58

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard