Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Compare date in Sharepoint list with today's date and send out email



I am quite new with Power automate and just teaching myself how to use it. I am trying this for 5 hours now and still struggle with the last bit: The flow below is supposed to send out an email with an attachment on a certain date in a Sharepoint list. I does everything as it should, but I just cant't get the simple condition below to work. I tried so many options on how to enter the expression, I even changed the date in the Sharepoint list +/- one day to see if it's a time zone issue. It is always coming out "false". Does anyone have an idea what I am doing wrong?




Super User
Super User

@Annnika  The problem will be that the date formats in the condition are not the same. utcNow() is in the format 2020-01-06T06:50:09.3187488Z whereas your SharePoint column will have the date in your local format, for example 2020-01-06

So you need to get them into the same format. You could add a compose and in the expression type formatDateTime(utcNow(), yyyy-MM-dd). Then you could use the output of that from the dynamic content box in further actions.

Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Thank you @RobElliott! I now googled how and where to use the compose function, below is how far I got. The format in the Sharepoint list "Kick-Off" is . I experimented with that as well in the compose function, but I think my problem is that I can't wrap my head around where the compose function pulls what from and what the logic behind this is, so so far no luck....I keep on trying.




Oh I did it! I also used the "format" in the equals condition box. I still don't fully understand the logic but I will get there. Next project to not send it on the date but 14 days before the date. Thanks for the help!

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,151)