web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter & Email Power B...
Power Automate
Unanswered

Filter & Email Power BI reports depending on filter and recipient

(0) ShareShare
ReportReport
Posted on by 4
Hello everyone,
I have a report with sales data. This report should be automatically filtered by store and sent by e-mail to the relevant store managers. This is to be implemented with Power Automate.
 
For example, I have three tables in my report:
* Store (Storeid, Managerid)
* Sales (Quantity, Storeid)
* Employees (managerid, e-mail)
 
 
If everything is to be sent to the same e-mail address everything works perfectly.
1. To get store filter elements: Query to the dataset. 
2. parse JSON
3. apply to all
3.1 Export Power-BI report as file
3.2 Send e-mail with attachment from 3.2.
 
 
How can I now include the information that Store A should be sent to Manager B?
 
 
 
Categories:
I have the same question (1)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard