Power Platform Community Forum Thread Details

In a Power Automate flow, I use the Get Rows V2 action (SQL Server), which outputs a body/value that looks like this:

Mail	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 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:

Building flows