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

SharePoint List: How to evaluate if a date has expired

Hi all,

I have a SharePoint list showing expiry dates for certificates and would like to send an reminder email 7 days before the certificate expires. So far, I’ve created a condition that successfully sends an email when the SharePoint list item ‘CHAS’ is changed to today’s date using the following advanced condition:

 

@equals(triggerBody()?['CHAS'], utcnow ('dd-MM-yyyy'))

 

Do you know how I could track existing dates that only change once a year? And if possible, can Flow send an email 7 days before the expiry date?

 

24 REPLIES 24

I'm sorry, I cannot make it work 😞

 

According to this answer I received this very morning

https://powerusers.microsoft.com/t5/Flow-Forum/Can-we-use-WDL-expressions-i-e-utcnow-adddays-etc-in-...

I guess the format you need should be

 

@greater('coalesce(triggerBody()?['Fecha'],"2000-12-12")', 'adddays(utcnow(),-7,"yyyy-MM-dd")')

 

However, when saving the test flow, an error message is displayed. AS I mentioned in previous replies, I managed to make coalesce work inside a condition in May-June timeframe, since then some format changes have applied.

Let's hope a member of Microsoft Flow support team can help us to clarify if we can keep on using coalesce in Condition blocks or it has been discontinued.

I created a new list with a column for client names and a date column named Fecha. I even tried changing the region to US but on saving I get the following error:

 

The template validation failed: 'The template action 'Condition' at line '1' and column '1102' is not valid: "The template language expression 'greater(coalesce(triggerBody()?['Fecha'],"2000-12-12"), 'adddays (utcnow(),-7,"yyyy-MM-dd")')' is not valid: the string character '"' at position '41' is not expected.".'.

@Eco_Graham

There seems to be a bug when comparing today's date with one stored in sharepoint, please note there are some threads discussing this topic like:

https://powerusers.microsoft.com/t5/Flow-Forum/Today-date-same-as-sharepoint-item-date/m-p/3411/high...

 

On my successful tests in May-June timeframe the "filter array" functionality was not available. Yesterday, I tested it with "condition" since the trigger executed in my flow is "when a sharepoint item is added"

 

Hope this helps

 

 

I think I found the proper format. I should have used double quotes for the trigger parameter, since it is inside an expression:

 

coalesce.png

 

Whith this format, when saving the flow, there are no parse errors.

 

I tried your solution but still get an error. I will leave it for now and try setting up a recurring task, Outlook calendar or 2013 workflow.

 

Many thanks for all your help.

 

Regards,

Graham

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,602)