Send users single email with multiple Excel rows (Power Automate)

Power Automate flows can be used to send reminders to users, but sending multiple emails for each row can be overwhelming. To send a single email with multiple rows, you can follow these steps: 1. Get all the recipients from the Excel file by listing all the rows and selecting the column with email addresses. 2. Use the union() expression to keep only the unique email addresses. 3. Loop through the unique recipients and filter the rows where their email is in the email column. 4. Convert the filtered rows into an HTML table for easier readability. 5. Send the HTML table as an email to each recipient. By sending a single email with all the relevant rows, users will be happier and processes will be more efficient.

Article 18m Tom Riha

---

Login now to access my digest by 365.Training

Login