automated emails from data in excel

[JVR652]

Hello, 

I am new to Power Automate and would like to know if it is possible to create a flow that will send automated emails based on data from an Excel spreadsheet. More specifically, I would like the emails to be automatically sent 4 months before the expiration date listed in one the rows of the table. 

If this function is possible, an example would awesome!

[PrasadAthalye]

Refer this post

https://powerusers.microsoft.com/t5/Building-Flows/Building-flow-to-send-an-email-once-reminder-date...

[v-LilyW-msft · Accepted solution]

Hi @JVR652 

According to your description, you want to send an email reminder 4 months before the due date.

Because Flow has no function to add months, so suggest that you change it to 120 days.

I set up a simple flow, you can take a try with the screenshots below.

This is my test excel.

Flow in details:

Expression1:formatDateTime(items('Apply_to_each')?['Deadline'],'yyyy-MM-dd')

Expression2:addDays(utcNow(),120,'yyyy-MM-dd')

Expression:formatDateTime(items('Apply_to_each')?['Deadline'],'yyyy-MM-dd')

After flow runs, Test2 will receive an email like this:

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JVR652]

Thank you! Works perfectly 👍