Power Platform Community Forum Thread Details

I'm trying to build a collection that is made with JSON. That collection is then displayed in a Gallery where it takes a column and splits it by ";". Once this data is split, it needs to look up the Group IDs and grab all the users stored into a Multiselect People Picker field, and store it back into the collection under the group IDs field.

I've tried multiple things, but I need help getting the lookup to work and grab all member's emails or update the collection.

Group Table

----------------------------------

ID Title Members

The top portion works with no semi colon found, but forall looping is still a bit funky to me.

If(
 ThisItem.ActionType <> "User",
 Patch(
 ColListRouting,
 LookUp(
 ColListRouting,
 Id = ThisItem.Id
 ),
 {
 ActionID: 
 If(
 IsBlank(Find(";", ThisItem.ActionID)), 
 LookUp('List Routing Groups', ID = Value(ThisItem.ActionID), Concat(Members, Email, ";")),
 ForAll(
 Split(Text(ThisItem.ActionID), ";"),
 ThisItem.ActionID & LookUp('List Routing Groups', ID = Value(ThisRecord.Value), Concat(Members, Email, ";"))
 )
 )
 }
 ); 
);

Categories:

Building Power Apps