Hello @LoufromNH ,
please follow these steps:
1. List the rows, in my case I'm using the Excel "List rows present in a table" action:
2. Add a "Select" action where to grab only the Manager email:
3. Add a "Compose" action in which put the following expression:
union(body('Select'),body('Select'))
4. Add an "Apply to each" control: put the previous Compose outputs in the "Select an output from previous steps" field
5. In the Apply to each loop, add a "Filter array" action where filter the list based on the Manager email:
6. Always in the Apply to each loop, add a "Create HTML table":
- From: body grabbed from the "Filter array" action;
- in the Values please use the following expressions:
item()?['Person Full Name']
item()?['Total Number of Courses']
7. Always within the Apply to each loop, I suggest to add another Compose action and put the following html to format the table:
<style>
table {
border: 1px solid #1C6EA4;
background-color: #EEEEEE;
width: 100%;
text-align: left;
border-collapse: collapse;
}
table td, table th {
border: 1px solid #AAAAAA;
padding: 3px 2px;
}
table tbody td {
font-size: 13px;
}
table thead {
background: #1C6EA4;
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 15px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
</style>
At the end of the HTML, add the HTML table outputs:
8. Always within the Apply to each loop, add the Outlook "Send an email (V2)" action and add the previous Compose outputs in the email body:
Here the full flow:
Here the output:
So, each Manager will receive his own email with the employees list.
If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.
My blog site about Power Automate: https://powerautomatejoy.com/
BR,
Marco
