Скачать или смотреть Advanced SharePoint Document Reminders with Power Automate

How to create an advanced remind solution for SharePoint Document Libraries using Power Automate. This workflow runs on a schedule to send notifications based on a metadata column value and date.

In the workflow I use the AddDays expression to calculate the number of days before sending a reminder e.g. a date column value minus 3 days.
addDays(convertFromUtc(utcNow(),'New Zealand Standard Time'),-3)

I also use FilterValues to limit the number of documents returned by the Get Files action. Note that 'GetDateToCheck' is the output of the date calculation.

(Priority eq 'High') and (Created ge datetime'@{outputs('GetDateToCheck')}')

More details can be found on my blog: https://steveknutson.blog/2022/04/17/...