Record | Reference | Annotation | |
user1@email.com | 1 | Ref-1 | Remarks1 |
user1@email.com | 2 | Ref-2 | Remarks2 |
user2@email.com | 3 | Ref-3 | Remarks3 |
user2@email.com | 4 | Ref-4 | Remarks4 |
user2@email.com | 5 | Ref-5 | Remarks5 |
user3@email.com | 6 | Ref-6 | Remarks6 |
user3@email.com | 7 | Ref-7 | Remarks7 |
Using Power Automate, I want to send an email to each of the users (1 email only), summarizing their details in a table format like:
To: user1@email.com
Subject: Pending Records
Body:
Hi, the following records are pending:
Record | Reference | Annotation |
1 | Ref-1 | Remarks1 |
2 | Ref-2 | Remarks2 |
Kindly complete.