I created a flow in Power BI.
I have a table in Power BI with the following columns:
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:
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:
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 🙂
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,
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.
Can you expand 'Filter Array' of the flow shown in the image? I am getting blank values at that step after running successfully.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
The Super User program for 2022- Season 2 has kicked off!