Unanswered

Send one email based on Excel table

(0) Share

Report

Posted on by helpneededtake2

I'm working on creating an email notification task reminder. The source file to be used is an Excel file saved on SharePoint.

I'm trying to have the email contain a html table with the tasks each individual is responsible for and send one email to them. Currently, I'm able to get the flow to work but, instead of receiving one email with each task I'm receiving X emails for X amount of tasks associated with me. For example if the Excel file has 3 tasks associated with me I get 3 emails with each email having the same html table.

I believe the reason it's sending multiple emails is because I'm not looping through the emails but I'm not sure how to do that. Any help would be appreciated. Thanks.

Below is the Excel table I'm using and the flow.

Due date	ReminderDate	Submission(task)	Comments	Contact	Email
1/11/2023	1/10/2023	testing 1	Need to provide feedback for IT	EM	EM@email.com
1/11/2023	1/10/2023	needs submissions	Feedback for testing	DA	DA@email.com
1/11/2023	1/10/2023	123	testing	EM	EM@email.com
1/11/2023	1/10/2023	123	testing	MM	MM@email.com

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (0)

AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

@helpneededtake2 Use the output from Create HTML table action.

Should you require any further assistance, do let me know.

Hope it helps!!

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
helpneededtake2 22 on at

Like (0)

Report

Thanks for the response but, I'm not trying to create a Word document. I would like to send an email. Would you be able to use what I have done and give me an example of where I need to add or take away? I'm new to power automate and am not understanding why you are suggesting I need to create a Word document.

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

I am not suggesting you to create any word document, it was for reference.

In your case what you need to do is use output from your Create HTML table action in send email action 'TO' field

Was this reply helpful? Yes No
helpneededtake2 22 on at

Like (0)

Report

This is the first flow I've ever created, so I'm not really understanding what exactly you're telling me to do. But I did the following (assuming I followed your direction correctly) and I got an error. Would you be willing you provide an image on what and where I'm suppose to make the changes so that I may follow. Again, I'm new and not understanding.

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

Move send email action out of apply to each

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Take a look at this blog post I wrote on how to do this exact thing. It shows how to get a distinct list of emails from the master list and then send one email with one html table for each distinct email address.

Send One Email per Person in a Mixed List – What Me Pa..Panic? (dontpapanic.com)

Was this reply helpful? Yes No
helpneededtake2 22 on at

Like (0)

Report

I need to include the contact in the body of the email. This being a dynamic content, the step automatically makes it go into apply to each 2. How do I include the dynamic content without is changing on me.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Instead of getting just the distinct email addresses to send out include a field for the display name as well. Then you can use that in the email just like you use the email address.

Was this reply helpful? Yes No
helpneededtake2 22 on at

Like (0)

Report

How would I do that? Apologies if this sounds like a intuitive question but this is the first flow I've created and I don't fully understand how/where I would include that.

Was this reply helpful? Yes No
AS-06081019-0 1,736 Super User 2024 Season 1 on at

Like (0)

Report

If you can wait till tomorrow I can share the flow as it’s late for me.
Also, please share the excel which you are using if you can.

Thanks

Ankesh

Was this reply helpful? Yes No