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!

4 REPLIES 4
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 🙂

Hi Marika and 

 

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.

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,498)