Hello everybody,
I am still new to Power Automate, but I want to access an excel table, pick rows of specific criteria and send one email splitting the table with these criteria, but also adding the criteria (name/email) and as a second criteria the mail of the supervisor in CC (example below). I thought of an 'apply to each' chain, but i'm not sure how to bring that back together in one email.
e.g.:
original table
| Problem | Intern | Supervisor |
| broke projector | Intern 1 | Bob |
| cold coffee | Intern 2 | Susie |
| didn't clean | Intern 1 | Jannet |
| can't copy | Intern 3 | Marley |
| / | Intern 4 | Jannet |
And the mail should be something like this:
"
Mail to: Intern 1, intern 2, intern 3
CC: Bob, Susie, Jannet, Marley
Here's is every interns recent issues:
Intern 1:
| Problem | Intern | Supervisor |
| broke projector | Intern 1 | Bob |
| didn't clean | Intern 1 | Jannet |
Intern 2:
| Problem | Intern | Supervisor |
| cold coffee | Intern 2 | Susie |
Intern 3:
| Problem | Intern | Supervisor |
| can't copy | Intern 3 | Marley |
"
