Forum Discussion
Send a reminder email based on a list column value
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.