Group by Email

(1) Share

Report

Posted on by EK-12091222-0

Hi together,

I have a Sharepoint List with two person columns: 1) User 2) Responsible.

In the list are multiple records with lots of users. Each user has a responsible person. The responsible person can have multiple users. So as an example it could look like this:

Users	Responsible
Mark	Thomas
Jeff	Joe
Donald	Thomas
Jose	Thomas
Jenifer	Joe

So in this example Mark, Donald and Jose are under the responsibility of Thomas.

For my Flow I want to send a single email to Thomas and Joe with a list of the users they are responsible of.

I tried many methods, especially the ones that are out there in the internet, but none of them worked. I would really appreciate any help!

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Chriddle 8,685 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Using XML and XPath:

Create an array of unique "Responsible" (In Select's "From")

Select all "User" with this "Responsible" (In Select's "Map Users")

Select

From:

xpath( xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))), '//Responsible[not(preceding::Responsible=.)]/text()' )

Map Responsible:

item()

Map Users:

xpath( xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))), concat('//Item[Responsible="' , item(),'"]/User/text()') )

Was this reply helpful? Yes No