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 / Condition: Send email ...
Power Automate
Answered

Condition: Send email if date in SharePoint list matches today

(0) ShareShare
ReportReport
Posted on by 13

Hopefully, someone can help.  I'm going bonkers here.  I have a Power Automate flow that passes the checks but fails to send an email.  I want the flow to send an email if the date in SharePoint list matches today's date.

Nils_Stansen_0-1689751324466.png

Nils_Stansen_1-1689750908492.png

The emails addresses are confirmed to be correct.

 

I receive this error...

Nils_Stansen_2-1689750982660.png

I think this means everything is working but because the condition is not met (The date in the list does not match today's date), the email isn't being sent.  I check the data in the list, and it is today.

Nils_Stansen_3-1689751073802.png

I even tried a date conversion step that I saw on earlier posts; no joy!  I am at a loss, please help.

 

Categories:
  • Verified answer
    v-mingkz-msft Profile Picture
    Microsoft Employee on at

    Hi @Nils_Stansen,

    Please convert your date column in SharePoint to the same format with 'MM-dd-yyyy'.

     

    Best Regards,

    Kyrie

  • Verified answer
    pengwei Profile Picture
    139 on at

    Hi @Nils_Stansen ,

     

    The screenshot you have shared was not an error. Instead it's shown that the condition check was false, meaning that the data in your SharePoint list is not matching to the formatdatetime() result.

     

    You can use a compose to verify what would be the result obtained from your GetItems step. In my flow, I obtained the format as ‘yyyy-MM-dd’ instead of 'MM-dd-yyyy'. From there you can change your formatdatetime's format to make sure these two are in the same format and your flow should be good to go.

     

    pengwei_0-1689752249265.png

     

  • Nils_Stansen Profile Picture
    13 on at

    Yes, that did work.  When I downloaded the output from the test...

    Nils_Stansen_1-1689978790539.png

     

    It looks like the data coming in from the list is in the format you described.  So, there was a mismatch of the date format.

     

    Nils_Stansen_0-1689978753227.png

     

    Thank you.

     

  • Nils_Stansen Profile Picture
    13 on at

    I did not go this route but I do agree that should also work.  The problem did lie in the mismatch of the date format.  Thank you for your help.

  • Nils_Stansen Profile Picture
    13 on at

    Another helpful hint.  I had several rules built into my Outlook email for incoming emails.  A couple rules unknowingly had this box checked...

    Nils_Stansen_0-1690068146357.png

    That was doing something to my emails where these emails were either disappearing or not coming through.  Either way, once I deselected this option in my Outlook rules, everything worked well.  Just thought I would post this for anyone else looking for similar solutions.

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 244

#3
Henil Profile Picture

Henil 102

Last 30 days Overall leaderboard