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--
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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')
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--