Send email from Power BI

[Marika21]

Hi, 

I created a flow in Power BI.

I have a table in Power BI with the following columns:

- name

-status

-email

-company name

When the button is clicked in Power BI the flow sends an automatic email based on the status. However sometimes the email address in the email column is the same and I would like to avoid the user getting two separate emails, rather all the information in one email. Is there any way to do this? 

This is the flow I`m using: 

 Thank you!

[v-bofeng-msft]

Hi @Marika21 :

The key is to obtain a single list of unique email addresses, and then send the email after traversing the data source and filtering according to each address.

Step1: Use select action to get a list of emails

Step2: Use Union to get unique email addresses

Step3: Traverse the list obtained in Step2, filter the metadata in the loop body, and get the records associated with each email address

Step4: send email

I think this link will help you a lot:

Split excel table data to multiple files based on certain field and send file to owners separately

Best Regards,

Bof

[Marika21]

Hi, 

Thank you! I used something similar to the link you send and works perfectly. 

I just need to check the second part, which is to only send to people when the table in Power BI is refreshed every day 🙂

 

[DML1]

Hi Marika and v-bofeng-msft,

In the same flow how to attach files on email which are associated with unique email ID?

I have colum names like this,

Name

Status

Email ID

File name

File name against each email id has to match with one drive folder and respective file has to be attached as part of email.

Thanks in advance for the help.

[Pran]

Hi,

Can you expand 'Filter Array' of the flow shown in the image? I am getting blank values at that step after running successfully. 

-Pranita