You’re offline. This is a read only version of the page.
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
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (
