cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Annnika
Frequent Visitor

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

Hello,

 

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?

 

 

FlowFlow

3 REPLIES 3
RobElliott
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.

Rob
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 dd.mm.yyyy . 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.

 

 

Flow2.JPGFlow3.JPG

Annnika
Frequent Visitor

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

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,327)