Showing results for 
Search instead for 
Did you mean: 

Sort by date Sharepoint list

I want to create a flow that sends an email to a specific person based on an upcoming date within SharePoint.

We have a SharePoint page with11 columns of with one says "period of performance". As an examle: there are two dates in the Period of Performance column "1/1/2019 - 1/31/2020". I'd like to create a Flow that will automatically send an email to the owner of the task up to 6 months prior to the final date telling him the task will end in 6 months. 

On June 30,2019  an automatic email is sent saying something like - "John Doe, Task DO 1234 will be ending 1/31/2020.


Status: New