evaluate a shapreoint list and compose to output

[vipfafen]

Hi all,

I'm trying to create the following flow:

1. get items from sharepoint list (the sharepoint list contains approx 300 user and a handful of managers).

For Example:

DisplayName	UPN	Manager
User1	user1.com	Manager1
User2	user2.com	Manager2

User3	user3.com	Manager1
User4	user4.com	Manager1

2. the managers should receive an email with the list of users assigned to them. There should really only be one e-mail per manager and not one e-mail to the manager per user.

what is the best way to do this?

Start => get items from sharepoint list

regards

[annajhaveri · Accepted solution]

@vipfafen  you can refer to this post https://powerusers.microsoft.com/t5/Building-Flows/Group-BY-in-Flow-to-send-email-of-aggregated-data...