Forum Discussion
Send Email through power automate
I have a dataset in Power BI like
Name City Email
raj. Pune [email protected]
shiva. Mumbai. [email protected]
I want to send email to users only for the records belong to them
for example my email id is Raj@abc then i will receive only first record from the table
1 Reply
- rajendraongole1Super User
Hi Akshayraj -Open Power Automate (accessible from the Power BI Service or directly from Power Automate).
Choose "Create" > "Automated Cloud Flow".
Set a trigger as "When a data-driven alert is triggered" or "Recurrence" depending on when you want emails to be sent.Use the Power BI connector in the flow to pull data.
Add a List rows or Query dataset action to fetch records.
4. Filter Data for Each User
Add a Condition step to filter rows where the Email column matches the recipient's email address.
You can use the "Filter array" step to dynamically filter records by email.Solved threads FYR:
Send email with (filtered) data in Power BI using the new Power Automate visual – powerbinerd
Hope this helps.