Skip to main content

Notifications

Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Send email with a cons...
Power Automate - Building Flows
Unanswered

Send email with a consolidated HTML report -filter list from another list

(0) ShareShare
ReportReport
Posted on by ciprianpopovici 159
I have 2 sharepoint list with this simplified structure:
 
List 1  Managers
 
Column1: Manager (people column)
Column2: SaleAgent (people column)
 
exemple:
 
Manager SaleAgent
Manager1 Agent1
Manager1 Agent2
Manager1 Agent3
Manager2
 Agent4
Manager2 Agent5
 
 
List 2 Actions
 
Column1: SaleAgent (people column)
Column2: Action date
Column3: Action Status
Column4: Action description
 
 
 
I need to create a flow to send a consolidated HTML report to every manager with all the actions of the sub agents.
 
Manager 1 should receive a list of actions grouped per agent : Agent1, Agent2 and Agent3
Manager 2 should receive a list of actions grouped per agent: Agent 4 and Agent5
 
 
If anybody can give me an idea it will be amazing.
Thank you
 
 
 
Categories:
Business Process Flows

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

News and Announcements

Upwork and Microsoft Power Platform Partnership
Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans