Display Members of Selected Groups in Grid Columns

Question

When selecting one or more groups, I want to display the members of those selected groups in a grid column. 
 Thank you!! 
 . a!localVariables(
 local!selectedGroup: ri!initialGroup,
 local!distinctUsers: if(
 a!isNullOrEmpty(local!selectedGroup),
 "Please select a group",
 getdistinctusers({local!selectedGroup}),
 ),
 local!groupName:a!forEach(
 items: local!selectedGroup,
 expression: getgroupnames(fv!item)
 ),
 local!pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 10 
 ),
 {
 a!sectionLayout(
 label: "User & Group Management",
 contents: { 
 a!pickerFieldGroups(
 label: "Pick Groups",
 labelPosition: "ABOVE",
 maxSelections: 5,
 value: ri!initialGroup,
 saveInto: ri!initialGroup,
 )
 }
 ),
 a!sectionLayout(
 label: "Group members",
 contents: { 
 a!gridField(
 label: "", 
 labelPosition: "ABOVE",
 columns: { 
 a!forEach(
 items: local!groupName,
 expression: a!gridColumn(
 label: fv!item,
 value: a!richTextDisplayField(
 value: local!distinctUsers
 ),
 align: "CENTER",
 width: "NARROW"
 )
 )
 },
 pagingSaveInto:local!pagingInfo
 )
 }
 ) 
 }
)

venkat Avuluri · Answer

a!localVariables(
 local!selectedGroup: ri!initialGroup,
 local!distinctUsers: if(
 a!isNullOrEmpty(local!selectedGroup),
 "Please select a group",
 a!flatten(
 a!forEach(
 items: local!selectedGroup,
 expression:a!localVariables(
 local!group:fv!item,
 a!forEach(
 items: getdistinctusers({fv!item}),
 expression: a!map(id: fv!index, Group:local!group,Members: fv!item )
 ))
 )
 )
 ),
 local!groupName: a!forEach(
 items: local!selectedGroup,
 expression: getgroupnames(fv!item)
 ),
 local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10),
 {
 a!sectionLayout(
 label: "User & Group Management",
 contents: {
 a!pickerFieldGroups(
 label: "Pick Groups",
 labelPosition: "ABOVE",
 maxSelections: 5,
 value: ri!initialGroup,
 saveInto: ri!initialGroup,
 
 )
 }
 ),
 a!sectionLayout(
 label: "Group members",
 contents: {
 a!columnsLayout(
 columns: a!forEach(
 items: local!selectedGroup,
 expression: a!columnLayout(
 a!gridField(
 label: "",
 labelPosition: "ABOVE",
 data: index(
 local!distinctUsers,
 wherecontains(
 touniformstring(fv!item),
 touniformstring(local!distinctUsers.Group)
 )
 ),
 columns: a!gridColumn(
 label: group(
 groupId: togroup(fv!item),
 property: "groupName"
 ),
 value: fv!row.Members
 ),
 pagingSaveInto: local!pagingInfo
 )
 )
 )
 )
 }
 )
 }
) 
 It's not exactly what you looking for but i did few changes to your code (It can be modified to fit for better practices). I used Columns layout have a look into it. FYI: It's not the better approach

Display Members of Selected Groups in Grid Columns

Top Replies