Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Combo Box error

(0) ShareShare
ReportReport
Posted on by 125

Hi Folks,

 

I have a dilemma, I have a SharePoint list of member:

 

Member NameAccess Type
Denji1
Aly1
Aly2
Maru4
Aly3

 

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.

 

 

  • alaabitar Profile Picture
    alaabitar 1,503 on at
    Re: Combo Box error

    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

    alaabitar_1-1675858400226.pngalaabitar_2-1675858421538.png

    Best regards,

    Alaa

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard