Power Automate - Building Flows

Power BI Report - Send one email per Email Address

Like (1) Share

Report

Posted on 12 Aug 2024 01:31:50 by SD-12080125-0

Good morning

I have looked everywhere and cannot find a YouTube clip or Web Page to advise

Please find below Power BI Table for multiple records in association with only two email addresses

I am wanting to set up a Power Automate flow that sends only one email per email address and displays data only relevant to that email address.

Any assistance would be appreciated.

Cheers,

Stephen

All responses (3)

Answers (0)

Ellis Karim 10,940 Super User 2025 Season 1 on 12 Aug 2024 at 12:39:31

Like (0)

Report
Power BI Report - Send one email per Email Address

For some suggestions, please see:

📧How to Remove Duplicate Email Addresses from a Set of Data Using Power Automate – Ellis Karim's Blog

Excel and Power Automate: How to Combine Multiple Excel Rows into a Single Email for Each Recipient – Ellis Karim's Blog

Ellis
SD-12080125-0 4 on 12 Aug 2024 at 05:46:16

Like (0)

Report

Power BI Report - Send one email per Email Address

PS... If screenshots can be provided, that would be awesome!
Suggested answer

Michael E. Gernaey 42,080 Super User 2025 Season 1 on 12 Aug 2024 at 03:33:14

Like (0)

Report

Power BI Report - Send one email per Email Address

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.

Community site session details

Power BI Report - Send one email per Email Address

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Power BI Report - Send one email per Email Address

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates