Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
Announcing Category Subscriptions!
News and Announcements icon
Power Platform Community / Forums / Power Apps - Power Query / filter gallery with mu...
Power Apps - Power Query
Suggested answer

filter gallery with multi select combobox

(0) ShareShare
ReportReport
Posted on by nicklimcs 75
hi everyone,
 
This was the formula that I used to filter the gallery and it works fine. As you can see in the 2nd figure, when I select "Dog" in the CBX, the gallery is showing the expected results.
 
Figure 1
 
Figure 2
 
Now, I enable multi select on the CBX, and changed the formula as below, however it is only returning the first and last row, 2nd row has been skipped.
 
Can someone point me to the right direction please. Many thanks
 
 
Categories:
General Comment
  • nicklimcs Profile Picture
    nicklimcs 75 on at
    filter gallery with multi select combobox
     
    I thought I did by checking this checkbox will mark it as "answered".  Is there another button for me to click on?
  • AndrianaO Profile Picture
    AndrianaO 161 on at
    filter gallery with multi select combobox
    @nicklimcs Happy to help! I would appreciate it if you verify my answer :)
  • nicklimcs Profile Picture
    nicklimcs 75 on at
    filter gallery with multi select combobox
     
    Thank you. It is working fine.
     
     
  • ronaldwalcott Profile Picture
    ronaldwalcott 1,345 on at
    filter gallery with multi select combobox
    What is the items type of the combo box?
  • Suggested answer
    AndrianaO Profile Picture
    AndrianaO 161 on at
    filter gallery with multi select combobox
    Hi! Your formula is not working because you are checking if Animal is in cbx.Selected items, so "Dog;Cat" is neither in "Dog" nor in "Duck". 
     
    You can try this formula:
     
    Filter(AddColumns(colTest As outerTable, test, Sum(ForAll(cbx.SelectedItems As innerTable,innerTable.Animal in outerTable.Animal),Value)),test>0)
     
    Let me know if this works! 

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

News and Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
Announcing Category Subscriptions!

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,174

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans