Automation of Emails using power automate

[SriGaG]

Hello Experts,

I have a power bi report which tracks abusive emails. in each day, it just generates a report regarding these. Employee name, email subject, email body. so when the report updates, an email should be delivered to their manager. lets say the report generates the emails of 10 employees. 6 are reporting to Manager A, and the rest reports to manager B. So two emails should generate to both of these managers saying their employees who are working under them, email subject and email body content etc respectivelu. I want to automate this using power automate. How to do it in powr automate and automate the procedure?

Is this possible via power automate?

If yes , how to do it? cn you tell me step wise to achieve the above reuest pkesse? 

[lbendlin]

1. Create a DAX query that groups the data the way you want.  Use CONCATENATEX if needed to list the employees per manager

2. Run that DAX query in Power Automate

3. Iterate over the results and send an email for each row (manager) with the list in the email body