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 ) } ) } )
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 ) } ) } )
Discussion posts and replies are publicly visible
Priyanshu Bhavsar
WHat is your usecase? Why do you want to display the members of all the selected group, in a single grid, in various columns?
As part of task. Where I have to use grid to display the members of all the selected group in columns.
It is not a very common use case I would say because Appian doesn't support list of list. Hence, it you try to build a list of list where the outer list signifies groups and inner signifies members, it is bound to fail. And even if you use dicitonaries, you will have to use editable grid.
Alright Thanks!! Then I will try any another way.