cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dsym
New Member

Auto email specific rows in excel online based on date.

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Jcook
Super User
Super User

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)


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

@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. 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

5 REPLIES 5
Jcook
Super User
Super User

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)


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





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).

Dsym_0-1613059346094.png

Dsym_1-1613059571059.png

 

 

@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. 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Jcook
Super User
Super User

@Dsym 

 

I have tested this, and it works:

Jcook_0-1613060768569.png

item()?['email address']

 

 

Run:

Jcook_1-1613060838563.png

 

 

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

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Dsym
New Member

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (3,813)