Hi
Honestly, this has been answered (by me personally by me) dozens of times.
You are simply needing to look for a way to create a Unique list of Emails, so that you can Loop through them
and then filter the data based on that email.
1. Get your data from Power BI
2. Use a select to JUST grab the Email Column
In the key put the name Emaill
in the value put item()['EmailColumninPowerBIname']
3. Use a Compose
-in the compose use a union(body('Select'), body('Select'));
This will get rid off the duplicates for every row that select gave you
4. Add an Apply to each
make the input (From) but the output of your compose action so that it will loop through your 2 email addresses or 3 or 10
however many unique there are
in side the apply to each
4a Add a filter array action
(From)the input should be your Power BI data (body/value or just body, whatever is the Array of data)
left side, should be the Dynamic Email Property from your Power BI Action
so like item()['PowerBIEmailColumnName']
middle = is equal to
end here is a little more. Let's pretend you called your Apply to each (just apply to each)
items('Apply_to_each')['EmailColumnName']
You have to use item on the first value and items on the second or the "item" that can ALSO be used to identify the right side, would cause an issue
4b. Add a Select and get the data from the output of step 4a (FILTER ARRAY)
Put in all the columns you want
you can name them whatever (on the left)
on the right it will always be
item()['ColumnNameInTheOutputOftheFilterArray']
4c. Add a Create HTMl Table
put the input as the output of the select
4d. Add your Email
Now you will ONLY email the person the ones that belong to them
Done.
