Power Platform Community Forum Thread Details

Hello.

I have a SQL View where the data look like below

Id | Name | emailAddress |

The general idea is that there are many items. One Owner can be an owner of Many Items.

I need to send out an email to each owner.

I can grab all the data from sql - however, i believe i need to do some sort of group.

I have managed to get all the Unique Owners using the Union parameter. But i am kind of stuck on the next step.

How can i list all the items every owner has, format it as a HTML table and send that HTML table as an email.

So Joe Bloggs has item A and Item B

Jane Smith has Item A and Item B

John Smith has Item A

So far, i have done the following : This just gets the unique users..

Am i followig the right path here?

Can anyone assist?

Categories:

Group By Flow to email unique users