I have a SharePoint list created with the following for contracts:
Flow layout is:
On my flow, I have a "Filter_Array" that should only send me an email message when the days left is less than 30 - that does not seem to be working - am not sure if I am missing something?
I have it like this "days left" is less than "adddays(utcnow('yyyy-MM-dd'),30)"
Do I need a condition action?
Solved! Go to Solution.
Hi @abm, I'm looking for the filter to filter out the SharePoint list and only send me an email with items that have less than 30 days until they expire. If more than 30 days, don't want to receive that email. The Days Left column shows that but I can't get that part right to only send me an email for less than 30 days.
Thanks for your reply so you need to compare against the expiry date using the below expression
Please see below:
I cannot seem to get it right - all emails are still coming through and not only the ones less than 30 days - can you please assist?
I just noticed that you have an apply to each loop in your screenshot. Could you please explain? Also a full screenshot of your flow is helpful.