Share via

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')

Community Center | Not monitored

Answer accepted by question author

Anonymous
2020-10-26T21:16:50.723+00:00

They're actively answering Power Flow questions in dedicated forums here.
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

--please don't forget to Accept as answer if the reply is helpful--

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.