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.