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

Like (1) Share

Report

Posted on 12 Apr 2025 19:55:48 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:

Process Advisor

All responses (5)

Answers (0)

Vivian Sedai 2 on 13 Apr 2025 at 00:26:34

Like (0)

Report

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

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.
w.p 3,944 on 12 Apr 2025 at 23:16:28

Like (1)

Report

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

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

w.p 3,944 on 12 Apr 2025 at 22:50:55

Like (1)

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

@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']