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.
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.
[…] how to do this a few months ago, I found such posts as Pieter Veenstra’s post titled Microsoft Flow – Sending out reminders this was a great start. However, if you are starting a Flow on something that will be more than 30 […]