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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (31,783)