Send Email through power automate

[Akshayraj]

I have a dataset in Power BI like

Name  City        Email

raj.      Pune        Raj@abc.com

shiva.   Mumbai.  Shiva@abc.com

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

[rajendraongole1]

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:

https://community.fabric.microsoft.com/t5/Developer/Send-an-email-to-particular-person-based-on-Valu...

Send email with (filtered) data in Power BI using the new Power Automate visual – powerbinerd

Hope this helps.