cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Marika21
Frequent Visitor

Send email from Power BI

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: 

 

Capture00.JPG

 Thank you!

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

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

Hi, 

 

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

 

Capture00.JPG

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 🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,406)