Send one email capturing multiple rows of data from Excel

[Mike789]

Hi,

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

1. Look at this spreadsheet
2. Extract the rows related to a specific stakeholder
3. Combine rows (if a stakeholder has more than 1 activity)
4. Present data in HTML formatted table
5. 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.

[ManishSolanki]

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

[Mike789]

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.

[ManishSolanki · Accepted solution]

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

[Mike789]

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

[Matthew-Svee]

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

[ManishSolanki]

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.

[Matthew-Svee]

@ManishSolanki Here ya go!

[ManishSolanki]

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.

[Matthew-Svee]

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