Unanswered

combine email addresses by company and send single email for each company

(1) Share

Report

Posted on by BBGG

I have a list of email addresses and their associated company name. I want to combine all the emails for each company into a single string, then send an email to each company. See image with sample list and desired output.

I think this would involve two nested "apply to each" actions but not sure how to put it together.

email_flow_proble...

I have the same question (0)

All responses (14)

Answers (0)

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report
Re: combine email addresses by company and send single email for each company

Hi @BBGG

I have designed a sample flow for you to refer, in this flow I have used separate column for storing Company name but if you are taking Title field for company name then pls replace Company field with Title field:

1. Firstly, get the list items from SharePoint list using 'Get items' action:

2. Next, we will create an array of company names present in the SharePoint list using 'Select' action:

Note: If you are using Title field for company name then replace Company field with Title field:

3. Now, we will store the unique company names in an array variable using expression. In the expression, we will use 'Union' formula to get the unique values from the collection of company names:
Expression used to get unique values:
union(body('Select'),body('Select'))

4. Next, we will iterate on unique company names using 'Apply to each' action & store the value of each iterated item temporarily in 'Compose' action:

5. Continue inside 'Apply to each' action, add 'Filter array' to filter out the list items or records based on the company name from current iteration:

6. Next inside the same 'Apply to each' action, add 'Select' action to get only the company email address as a collection from the output of 'Filter array' action:

6. Finally, add 'Send an email' action to send email to company email address:
Expression used in this step:
join(union(body('Select_2'),body('Select_2')),';')
Pls add the text in email body 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
BBGG 37 on at

Like (0)

Report

Re: combine email addresses by company and send single email for each company

Hi @ManishSolanki
Something is off when we try to duplicate. Specifically in steps 4-6. It looks like when we do the "compose" action in step 4 the compose output is coming back as {"PSPL":""} not simply PSPL . As a result, step 5 (filter array) and step 6 (select 2 and email) are basically coming back as null. See our output from Steps 4-6 below.

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

Like (0)

Report

Re: combine email addresses by company and send single email for each company

Hi @BBGG

I would request you to pls share the screenshots of the entire flow, that will better help in locating the issue.

Thanks

Was this reply helpful? Yes No
BBGG 37 on at

Like (0)

Report

Re: combine email addresses by company and send single email for each company

Thanks @ManishSolanki - See entire flow with callouts to all the objects.

Was this reply helpful? Yes No
BBGG 37 on at

Like (0)

Report

Re: combine email addresses by company and send single email for each company

@ManishSolanki . Image from previous post might be too small. Here is the full flow in parts:

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

Like (0)

Report

Re: combine email addresses by company and send single email for each company

Hi @BBGG

Thanks for sharing the screenshots of the entire flow 🙂
There is a common issue in both 'Select' actions, the expression needs to be entered after enabling the action in 'text mode' but not directly in 'Key' box.

To enable text mode, you need to click on the button present on the extreme right side of the 'Map' property:

Next, enter the expression in the textbox:

Similarly, do the changes for 'Select 2' action and test the entire flow.

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
akgravesen 3 on at

Like (0)

Report

Re: combine email addresses by company and send single email for each company

Thanks for this discussion. How would I go about adding an attachment to the email being sent? It seems when I follow this structure and try to add an attachment it adds the attachment multiple times.

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

Like (0)

Report

Re: combine email addresses by company and send single email for each company

Hi @akgravesen

Could you pls provide more details? If possible, pls share the screenshots of the flow in edit mode (mask sensitive info).

Thanks

Was this reply helpful? Yes No
PeerapongS 16 on at

Like (0)

Report

Re: combine email addresses by company and send single email for each company

Hi @ManishSolanki

I've followed your flow but I got error details: Parameter 'To' cannot be null or empty.
clientRequestId: 6003b418-c838-49b0-ae54-f878244569f1 at send email action.

Here is my steps

Here is my excel data

Please help to solve this error

Thanks,
PeerapongS

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

Like (0)

Report
Re: combine email addresses by company and send single email for each company

Hi @PeerapongS

Pls modify "Select" action. You need to click on button on the right side 'Switch Map to text mode'. Once you click it, you need to enter the below expression in the textbox:

item()?['Email']

Same way, pls modify "Select 2" action.

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