Power BI and Power Automate - E-Mails with Table based on ID#

(0) Share

Report

Posted on by Adam_Milczarski

Hello,

I am trying to construct a flow that does the following:

Looks at Power BI Data that contains
- E-Mail Address
- ID#
- Assignment Codes
Sends an E-Mail to the address in the data for that ID ONLY

e.g.

ID 123

Code ABC

ID 123

Code DEF

ID 456

Code ABC

ID 123 would get 1 e-mail with

ABC

DEF

ID 456 would get 1 e-mail with

ABC

Currently, all of my efforts have resulted in both IDs getting 3 e-mails (number of rows) with both sets of data (ABC, DEF, ABC)

Any suggestions?

Thank You

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

I did a post on my blog that walks through how to do this. The blog post uses data from SharePoint, but after the rows of data are retrieved from Power BI the steps are the same. So you just need to replace the Get Items action for SharePoint with something to get the data from Power BI. here's the blog post: Send One Email per Person in a Mixed List – What Me Pa..Panic? (dontpapanic.com)

Was this reply helpful? Yes No
Adam_Milczarski 12 on at

Like (0)

Report
Thank you...most of this worked out, perfectly.

I'll note this for anyone doing this through Power BI.

There is no need for the Parse JSON step. I'm not quite sure why, though...I guess the way the data is retrieved from Power BI?

I did need to insert a step between selecting the ID#s and the UNION to convert the ID# Selection to an Array.

So the Final Steps were
Power BI button clicked (this step is automatically entered as the first step when you select Power BI)
Select applicable data needed
Select the ID#/E-Mail Address
Array the ID#/E-Mail Address selection
Union the Array
Apply to each
Outputs (Unioned ID#/E-Mail Address)
Filter Array (Power BI Values)
Create HTML Table (from the Filtered Array)
Send an email
Again...thank you very much for the assistance.

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report
The step you call

Array the ID#/E-Mail Address selection

Is the piece I'm using the Parse JSON for. Either approach works.

"

Was this reply helpful? Yes No
Adam_Milczarski 12 on at

Like (0)

Report

Thanks for the clarification...

Was this reply helpful? Yes No