Send one email capturing multiple rows of data from Excel

(0) Share

Report

Posted on by Mike789

Hi,

Hoping someone can help. I want to achieve the following automation from this Excel table:

Look at this spreadsheet
Extract the rows related to a specific stakeholder
Combine rows (if a stakeholder has more than 1 activity)
Present data in HTML formatted table
Send 1 email to each stakeholder that contains a table of their related activities

I've looked at other posts but can't achieve what I'm looking to do. I've only just started with Power Automate, so this is a learning curve for me.

Many thanks.

I have the same question (0)

All responses (9)

Answers (1)

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Send one email capturing multiple rows of data from Excel

Hi @Mike789

I had shared a similar solution in the past, pls check it out:
Re: combine email addresses by company and send si... - Power Platform Community (microsoft.com)
The only difference is the data source, but the logic is same. You may need to modify the columns as per your need.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Mike789 7 on at

Like (0)

Report

Re: Send one email capturing multiple rows of data from Excel

Hi @ManishSolanki ,

Many thanks for your reply. I have put together the flow as per the suggested link, but have been given the following error (I have replaced my email address in this text):

The 'inputs.parameters' of workflow operation 'Send_an_email_(V2)' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'emailMessage/To' is required to be of type 'String/email'. The runtime value '"[\test@test.co.uk\,\test@test.co.uk\,\test@test.co.uk\,\test@test.co.uk\];[\test@test.co.uk\]"' to be converted doesn't have the expected format 'string/email'.

Full flow here:

Can you see where I've gone wrong? Any help would be very much appreciated.

Thanks.

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report

Re: Send one email capturing multiple rows of data from Excel

Hi @Mike789

You don't need to have "Apply to each 2" action. Pls drag out "Send an email" action and add inside "Apply to each action" just below "Select 2" action.

You may create a table using "Create html table" by passing the output of filter array action. The output of "Create html table" will show the data in tabular form in the email:
All these actions need to be added inside "Apply to each" action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Mike789 7 on at

Like (0)

Report

Re: Send one email capturing multiple rows of data from Excel

Thanks so much @ManishSolanki. Managed to solve it! Have some tweaking to do, but have got the main result.

Was this reply helpful? Yes No
Matthew-Svee 6 on at

Like (0)

Report

Re: Send one email capturing multiple rows of data from Excel

I'm trying to do something similar, but the filter array action always returns a blank array.

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Send one email capturing multiple rows of data from Excel

Hi @Matthew-Svee

Pls share the screenshot(s) of the flow in edit mode.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Matthew-Svee 6 on at

Like (0)

Report

Re: Send one email capturing multiple rows of data from Excel

@ManishSolanki Here ya go!

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Send one email capturing multiple rows of data from Excel

Hi @Matthew-Svee

There is small correction in "Select" action.

You need to first remove the dynamic value in Map textbox and then click 'Switch Map to text mode' button on the right side of the Map parameter:

Post that, select the dynamic value and set it in the Map textbox:

Save the flow & retest it.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Matthew-Svee 6 on at

Like (0)

Report

Re: Send one email capturing multiple rows of data from Excel

@ManishSolanki

OK, so I have my array now, but I cannot get the email address I have in the table out of the array. the "Select 2" doesn't give me the columns from my HTML table to use as a dynamic expression.

Was this reply helpful? Yes No