Hi Folks,
I have a dilemma, I have a SharePoint list of member:
Member Name | Access Type |
Denji | 1 |
Aly | 1 |
Aly | 2 |
Maru | 4 |
Aly | 3 |
The function I'm creating is ability to change access. Hence I need to create a combo box that every time change the access will change.
but I need to figure out how to insert items in combo box dynamically. The access type can go up to 9, If the user have only 5 access then it should reflect on the combo box.
Hello @philifova
So let's say you have a collection object
ClearCollect(
_access,
{
MemberName: "Denji",
AccessType: "1"
},
{
MemberName: "Aly",
AccessType: "1"
},
{
MemberName: "Aly",
AccessType: "2"
},
{
MemberName: "Maru",
AccessType: "4"
},
{
MemberName: "Aly",
AccessType: "3"
}
)
Then you have two combobox, one to select the memebr name and the other to select the accesstype
The items property of your cobobox to select the membername is
Distinct(_access,MemberName)
The items property of your combobox to select the access type is
Filter(_access,MemberName=cmbMemberName.Selected.Result)
Like the below screen shots
Best regards,
Alaa