Flow condition not working when comparing dates

Reuck, Tracey 21 Reputation points
2020-10-26T20:09:44.037+00:00

Hi - I would like to send email reminders 30 days before a due date. I have a Sharepoint list of items with a future due date. I get the list and compare 30 days before the due date (from a column named 'ReviewDate') to today's date. I read I cannot use a calculated field and I cannot check the ReviewDate against today's date using utcNow() so I set the Condition action as follows but it does not work. What is the best way to do this? Thank you.

addDays(items('Apply_to_each')['Performance_x0020_Review_x0020_D'],-30,'yyyy-MM-dd') is less than addDays(utcNow(),1,'yyyy-MM-dd')

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,815 questions
{count} votes

0 additional answers

Sort by: Most helpful