I have a list that contains driver's license info for multiple people, and would like to trigger 4 email notifications based on the expiration date - 6 months from expiration, then again at 3 months, 30 days, and final notice when it expires. Can anyone help in guiding me to create this workflow?
You can achieve this using Microsoft Power Automate (aka Flow). Here is the idea you can create your logic based on:
- Add a "Recurrence" trigger, Interval and frequency set to your desired values.
- Create 3 views for your list, first to list all driver's licenses expiring in next 6 months, 2nd in 3 months and last, in 30 days. (note: you might be able to achieve it without using the views, but I felt using it will limit the amount of data used)
- Use 'Get Item' to load your data from your SharePoint list using the above views.
- Send email notification when your condition matches.
Let me know if this helps.
Another method is that SharePoint designer workflow “Add Time to Date” , “Pause until date” and “send an email” actions.
We can choose the start option as "start the workflow automatically when an item is created" in the workflow settings.
Similar issue for your reference: