Auto email specific rows in excel online based on date.

[Dsym]

I have a flow that logs forms responses into a table on excel online. 

I have successfully created a recurrence flow that runs every day and will auto delete entries that are 7 days old. (7 days after the form submission date). Thanks @Jcook for your help.

Re: Delete Excel Rows X Amount of Days Old - Page 2 - Power Platform Community (microsoft.com)

I am trying to create another flow that will send a reminder to individuals to resubmit the form the day before it is deleted. I have tried using the same format as the flow used for the above but changing the action from "delete row", to "send e-mail", but I am struggling to work out how to get the email addresses of just the rows which are 6 days old. Any help would be appreciated.

[Jcook · Accepted solution]

Hi @Dsym

You can use the same Flow template.

Just change the days to 6. And replace the delete excel row action to a send email action.

If you are storing the email address of the user in excel, then you should be able to grab the email address using dynamic content. If for some reason no dynamic content shows up, you can use the expression

item()?[‘ColumnName’]

(This is in the Send email action - To field)

[Dsym]

Hi @Jcook  I have tried it with the dynamic content (pictured below) but it sends an email to all addresses on the excel sheet regardless of date.

I tried the expression you suggested but I get an error message (2nd picture).

[Jcook · Accepted solution]

@Dsym 

So the issue is when you use the Excel Dynamic content for Email address. Since it creates a second apply to each loop.

Remove the second apply to each loop, and try to use the expression.

For context: We are using a filter array for our excel outputs. This is so we only get records 6 days old. If we use the excel dynamic content then it brings in all records. 

[Jcook]

@Dsym 

I have tested this, and it works:

item()?['email address']

Run:

** If your getting a Bad request error still on the email action, screenshot what your Send email action looks like **

[Dsym]

Many thanks again @Jcook All up and running. I owe you a beer!