Share
Report
28In a Power Automate flow, I use the Get Rows V2 action (SQL Server), which outputs a body/value that looks like this:
| Operation | Task | |
| abc@uu.com | 1559 | 1511 |
| abc@uu.com | 1559 | 1625 |
| abc@uu.com | 1559 | 1856 |
| xyz@uu.com | 1255 | 1741 |
| xyz@uu.com | 1255 | 1743 |
| qwe@uu.com | 9875 | 1498 |
What I want to do now is filter this table's data on Mail and send out e-mails in a nice HTML format to the respective e-mails listed in the Mail column.
In this above example, the flow should send out three e-mails in total:
- One email to abc@uu.com
- One email to abc@uu.com
- One email to xyz@uu.com
- One email to qwe@uu.com
The e-mail to send out contains the data for "Operation" and "Task" column in HTML format like this:
"Dear abc@uu.com,
Here is an overview of your pending tasks and their respective operation numbers:
| abc@uu.com | 1559 | 1511 |
| abc@uu.com | 1559 | 1625 |
| abc@uu.com | 1559 |
1856
|
Best regards,
Admin
".
It would be great if someone has an example flow of this or screenshots of a flow that accomplishes this. I have no luck with other google searches and ChatGPT help.
Categories:
I have the same question (0)
All responses (
Answers (
