Answered

Combine Multiple Rows Into One Email Per Recipient: How to CC another recipient??

(1) Share

Report

Posted on by tpcolson

I am following Power Automate and Excel: Combine Multiple Rows Into One Email Per Recipient – Ellis Karim's Blog exactly and it's working perfectly. The problem is I also need to CC a manager for each employee email sent. Example

EMPOYEE	MANAGER
bob@bob.com	tom@tom.com
bill@bill.com	fred@fred.com
bill@bill.com	fred@fred.com
bill@bill.com	fred@fred.com
bill@bill.com	fred@fred.com
nancy@nancy.com	mary@mary.com
nancy@nancy.com	mary@mary.com

In the example from the blog post, each employee in the excel only gets on email (with a list of their tasks). What I need to do is CC each employees manager as well. I've tried initialize variable, compose...nothing works. To be clear, I don't need assistance in making Power Automate and Excel: Combine Multiple Rows Into One Email Per Recipient – Ellis Karim's Blog work: it does. I'm just lost on how to modify it to include a manager CC for each employee.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

If the manager is listed in the same table as the employee's tasks then just grab that value when you get the employee and add it in the email as the CC. If its in another list then you will need to use the employee's email to filter the list with the managers and then grab the email from the first record returned by the filter. I can give you an example if you specify where the managers are stored.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No

tpcolson

80 on at

Like (0)

Report

@Pstork1 "... just grab that value when you get the employee and add it in the email as the CC". Doesn't work. Doing so moves the email action into an apply for each and sends a single email per row, not per employee, generating thousands of emails. The Managers are in the same spreadsheet:

EMPOYEE	MANAGER
bob@bob.com	tom@tom.com
bill@bill.com	fred@fred.com
bill@bill.com	fred@fred.com
bill@bill.com	fred@fred.com
bill@bill.com	fred@fred.com
nancy@nancy.com	mary@mary.com
nancy@nancy.com	mary@mary.com

The employee email is the output of a select and union in order to get one single email per employee regardless of how many rows of the same employee there are (straight from the example at Power Automate and Excel: Combine Multiple Rows Into One Email Per Recipient – Ellis Karim's Blog).

Was this reply helpful? Yes No

Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (1)

Report
@tpcolson

You add the manager here

e.g manager email output

mary@mary.com

mary@mary.com

To get only a single manager's email address for CC, add a compose action

body('Select 2')?[0]?['MANAGER']

Was this reply helpful? Yes No
Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (1)

Report

Power Automate and Excel: Combine Multiple Rows Into One Email Per Recipient

Was this reply helpful? Yes No
Vivian Sedai 2 on at

Like (0)

Report

Hello,

So if I get you correctly.. you want to cc each employee's manger in each mail to send to that employee. not all the mangers in copy.

Was this reply helpful? Yes No