Forum Discussion
Send a reminder email based on a list column value
Hi can anyone help me with the solution so send reminder emails on the expiry date of a list item. I have a list in which i have a column expiry date and i want to send email reminder to users lets say 7 days before the expiry date of that item. Is there a way to achieve this out of box in SharePoint online. Please help.
You can create and configure a Flow to run on a Schedule as described in the article below:
https://docs.microsoft.com/en-us/flow/run-scheduled-tasks
Within your Flow you can make use of the Get Items action in the SharePoint Connector to retrieve items about to expire using a filter
https://docs.microsoft.com/nl-nl/connectors/sharepointonline/#Get_items
Finally you can send your reminder emails from the Flow
Hope this helps!
3 Replies
You can create and configure a Flow to run on a Schedule as described in the article below:
https://docs.microsoft.com/en-us/flow/run-scheduled-tasks
Within your Flow you can make use of the Get Items action in the SharePoint Connector to retrieve items about to expire using a filter
https://docs.microsoft.com/nl-nl/connectors/sharepointonline/#Get_items
Finally you can send your reminder emails from the Flow
Hope this helps!
Depending on where you have the user email info, you can create a view filtered on "Expiry date" less or equal [Today]+7, and then create a Flow on that view:
Thank you for suggesting solution here but this can only work when you have an event triggered on list like item is update or added. But in my case when a new item is created there is a expiry date and we need to send reminder based upon that expiry date without any modification applied to the list. Please suggest if any solution can work here.
