I am searching for months a flow that allows me to send an html table with several rows to an email.
For example I have this excel table in One Drive.
| Process | Code | Owner | Owner Mail |
| Process 1 | Code 1 | Cristiano Ronaldo | cristiano@mail.com |
| Process 2 | Code 2 | Messi | messi@mail.com |
| Process 3 | Code 3 | Messi | messi@mail.com |
| Process 4 | Code 4 | Neymar | neymar@mail.com |
| Process 5 | Code 5 | Neymar | neymar@mail.com |
| Process 6 | Code 6 | Cristiano Ronaldo | cristiano@mail.com |
| Process 7 | Code 7 | Cristiano Ronaldo | cristiano@mail.com |
| Process 8 | Code 8 | Neymar | neymar@mail.com |
| Process 9 | Code 9 | Neymar | neymar@mail.com |
-I manually trigger the flow
2-Get the rows from the One Drive Excel File
3-I Create the hmtl table, and selelect the columns: Process, code, owner
4-Then create the email: I put to send the "Owner mail" an in the body the html table.
But for example Cristiano Ronaldo receives 3 diferent mails(One table with a row per register), and that makes the receiver uncomfortable.
In the case of Cristiano Ronaldo, I hope he receive this table:
| Process | Code | Owner |
| Process 1 | Code 1 | Cristiano Ronaldo |
| Process 6 | Code 6 | Cristiano Ronaldo |
| Process 7 | Code 7 | Cristiano Ronaldo |
Can you help me please.
