Hi, I'm having a bit of trouble properly applying the logic for what I need to do.
Let's say I have a table with 3 columns, Name, Supervisor Name, and Supervisor Email.
Each name will be unique, but there can be repeats of Supervisor Name and Supervisor Email.
The goal, is to have an automated process in Flow that will email the Supervisor with a list of every single person that they are supervising in one email.
I am able to get this to work where it will email the supervisor one person at a time, but we need it so that it can send a list in a singular email. How would I go about doing that? It can be a list via text or it can turn into some kind of spreadsheet that would be unique to each supervisor. As long as it is something that can email a Supervisor in one email about every single person they are listed to be supervising in that table, then it's exactly what I need.
Thank you for your help in advance!
Example:
| Name | Supervisor Name | Supervisor Email |
| John Smith | George Washington | gwashington@america.gov |
| William Smith | George Washington | gwashington@america.gov |
| Nathaniel Smith | Andrew Jackson | ajackson@america.gov |
What I'd need this to become:
- One email to GWashington that lists John Smith and William Smith
- One email to AJackson that lists Nathaniel Smith
