Quite a common problem is to send out reminders when SharePoint list items or documents haven’t been modified for a while. The tricky part of this is that there is no trigger for ‘something happened a while back’.
Therefore the only trigger we can use is a When an item is created or modified then wait for a while. Collect the current details of the list item or document and then compare the current data with the trigger data.
The flow that will do this will probably look a bit like this:
In the above example I’m sending out an email for both modified and not modified documents. Most likely you would only have one branch of the condition send out an email, but for the example of this post it helps to document the options.
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/ Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/ You can contact me using contact@sharepains.com
When would you use this instead of using a schedule – recurrence trigger, with a filtered get items, and then for each item, send an email?
You could do that but that will increase your number of unnecessary runs. Also this way the run history of a document stays nicely together.