OK, so you have a SharePoint list where your users create items.
You would like to be notified by e-mail when items are not modified for a certain amount of days.
So, here goes:
- Go to the PowerAutomate portal: https://flow.microsoft.com
- Chose New/Instant – From Blank:
- Give your flow a name and click “Skip”:
- We set how often our flow will run with the recurrence trigger… let’s say 1 day:
- Then we get all the items from our SharePoint custom list:
- now we need to cycle though all the items in the list using “Apply to each”
- For each item, we will apply a condition:
- We modify the logic to “is less than” and for the value we chose the formula: adddays(utcnow(‘yyyy-MM-dd’),-2), where “-2” means the last 2 days
So, we should get all items that have not been modified for the last 2 days.
- We will continue with the “yes” branch:
• We select “send an e-mail (V2) and fill in the required information:
And finally, here’s our Flow:
and the resulting e-mail:
