GroupBy Multiple People

(0) Share

Report

Posted on by Rennacker54

I have a gallery of items that can be selected with a checkbox. Each item has one to many people assigned to it. I store the selected items in a collection colMailItems. In a next step I want to mail the assigned items to the respective people, but I want to send one mail only. That means, if 2 or more items have the same people assigned to it, I want one mail to contain 2 or more links to the items.

I tried to use the

GroupBy()

function, but it seems to struggle with multi-select people columns:

GroupBy(colMailItems, AddColumns(colMailItems, "ResponsibilityTEXT", Concat(colMailItems.Responsibility,DisplayName, ", ")))

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Rennacker54 19 on at

Like
a
(0)

Report
Copy link

Link copied!
GroupBy(AddColumns(colMailItems, "ResponsibilityTEXT", Concat(ThisRecord.Responsibility, DisplayName, "; ")), "ResponsibilityTEXT", "_data")
Figured out the solution - in case anyone has a similar issue

Was this reply helpful? Yes No