web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Combo boxes multiple s...
Power Apps
Answered

Combo boxes multiple selection on Gallery won't work

(0) ShareShare
ReportReport
Posted on by 81

i Have a combobox that is suppose to filter a gallery, but i discovered, when i select multiple data, it only pulls the last data selected and not all that was selected. e.g in my combobox, i have A,B,C,D. if i select A, it shows A in my Gallery, if i select A,B, it shows B only in my Gallery instead of A and B. the below is my combobox expression and Gallery expression

cmb_InformationType(Item Properties)=Filter(Choices('Class Information'.'Information Type'),Trim(Value) in "Mathematics|Geography|Physics|Anatomy")

Informationgallery(Items Properties)= Filter(colInformation,cmb_InformationType.Selected.Value in 'Information Type'.Value || IsBlank( cmb_InformationType.Selected.Value)

 

my Collection formula = ClearCollect(colInformation,'Information Management');

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Tbabe 

    So to be clear...

    You have a choice column in your datasource that allows multiple selections and you want to be able to filter by a multiple selection combobox.  Is that correct??

     

    Also, what is your datasource?

  • Tbabe Profile Picture
    81 on at

    yes and my Datasource is Sharepoint (Library)

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Tbabe 

    Your formula then will need to be this:

    Filter(colInformation,
     Sum(
     ForAll(cmb_InformationType.SelectedItems, If(Value in 'Information Type'.Value, 1, 0)),
     Value
     ) > 0
     || IsBlank( cmb_InformationType.Selected.Value)
    )

    This is just one of a couple ways to approach this.  The concept is to look at each selected item and then see if it is in the table of choices in the column.  If so, then it all gets summed up and if the sum is greater than 0, then there was a match and thus the row should be returned.

  • Tbabe Profile Picture
    81 on at

    it didn't give errors, but when i select from the combobox it doesn't return anything. The formula you shared was used in the itemgallery

  • Tbabe Profile Picture
    81 on at

    thank you, this worked, guess it was a bug initially.. you just saved me as usual..😀

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Tbabe 

    Good deal!  Happy to help!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard