Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SriGaG
Frequent Visitor

Automation of Emails using power automate

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? 

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors