Send single email with multiple items from Power BI

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I just started using Power Automate and I'm wondering how to resolve this problem.

I'm trying to create a flow that will send single email to multiple users with multiple items.

My dataset contains information about messages that haven't been answered yet and users responsible for them. I'd like to send an email to every user that is responsible for answering with a list of all messages that are pending on his/her side. At the moment my flows send multiple emails to the users.

Thanks in advance,

Jagoda

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ScottShearer 25,256 Most Valuable Professional on at

Like (0)

Report
Re: Send single email with multiple items from Power BI

@Anonymous

It would be hard to create an example specific to your use case, but here is how you might approach it in general terms.

First, create a collection of unique emails

Use a select() action to select the emails

Use a union() expression and use the output of the Select for both parameters - the result will be an array of unique emails

Loop through the unique emails

In the loop use a select and Filter array action to filter on the email (current item)

Create an HTML table with the output of the filter array

Send the email with the HTML table to the current email address

Here are screen shots for a Flow that does the same thing but uses SharePoint as the data source:

Hope this helps...

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Send single email with multiple items from Power BI

Hello @ScottShearer, thanks for your answer. I modified a few steps as it is shown here - https://www.youtube.com/watch?v=tp0jLnmKcEs and it worked well.

Was this reply helpful? Yes No
gafi_trf 2 on at

Like (0)

Report

Re: Send single email with multiple items from Power BI

I have the same problem as the partner. In the case of data that is extracted from a report in Power BI, what would the flow to create look like? I really appreciate your help

Was this reply helpful? Yes No