Forum Discussion
Akshayraj
1 year agoNew Member
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...
rajendraongole1
Super User
1 year agoHi 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.