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

Community site session details

Session Id : qQYZF+SxmewvPVYz6Cwjcz
Power Apps - Building Power Apps
Unanswered

How to combine multiple ComboBoxes for filtering a Gallery?

Like (0) ShareShare
ReportReport
Posted on 12 Jul 2023 08:43:27 by 20

Hello, 

 

I am trying to filter a Gallery with 3 multi-select-Dropdowns. Using one is no problem for me but using 3 it seems not that easy or I did not understand the use of the Filter-Function. 

 

Here is my Code: 

 

Filter(
 Shuffle('DataSource');
 Or(
 IsBlank(CB_Bereich.SelectedItems);
 IsEmpty(CB_Bereich.SelectedItems);
 'ColumnName' in CB_Bereich.SelectedItems
 )
)

 

 Please help me to get this working. 

 

Best regards

  • PowerAppBuilder24 Profile Picture
    20 on 12 Jul 2023 at 11:13:29
    Re: How to combine multiple ComboBoxes for filtering a Gallery?

    Hi @Rajkumar_404 , 

     

    thank you for helping me - I tried your formula but sadly it doesn't work. It might the case that I am wrong: 

    'ColumnName3' in Split(Gallery.Selected.'ColumnName '; ",") ) )

     

    In ColumnName3 I entered the ColumnName of my DataSource which is a MS List. In the Dropdown I removed the Split Function and in the last  'ColumnName' I also wrote the Name of the Column in that MS list mentioned earlier. 

     

    Is that Correct? 

     

    And here I also get a circle reference issue....

  • Rajkumar_M Profile Picture
    3,716 Super User 2025 Season 2 on 12 Jul 2023 at 10:13:30
    Re: How to combine multiple ComboBoxes for filtering a Gallery?

    Try this

    Filter( Shuffle('DataSource');

    Or( IsBlank(CB_Bereich.SelectedItems); IsEmpty(CB_Bereich.SelectedItems); 'ColumnName' in CB_Bereich.SelectedItems );

    Or( IsBlank(CB_Dropdown2.SelectedItems); IsEmpty(CB_Dropdown2.SelectedItems); 'ColumnName2' in CB_Dropdown2.SelectedItems );

    Or( IsBlank(CB_Dropdown3.SelectedItems); IsEmpty(CB_Dropdown3.SelectedItems);

    'ColumnName3' in Split(Gallery.Selected.'ColumnName '; ",") ) )

    Thanks!

  • PowerAppBuilder24 Profile Picture
    20 on 12 Jul 2023 at 09:26:01
    Re: How to combine multiple ComboBoxes for filtering a Gallery?

    Hi @Rajkumar_404 , 

     

    thank you for the quick support. The Link you provided me is already bookmarked 😉 

     

    I tried now you code. But only with 2 Dropdown. To make it simpler to debug. This works fine. 

     

    Now coming to the third one this doesnt work - The Dropdown uses a Split Function: 

     

    Split(Gallery.Selected.'ColumnName ';",")

     

     If I add this third dropdown - I get an error: 

    circle reference

    How can we fix this issue? 

     

    Best regards and many thanks for your help

     

     

  • Rajkumar_M Profile Picture
    3,716 Super User 2025 Season 2 on 12 Jul 2023 at 09:01:51
    Re: How to combine multiple ComboBoxes for filtering a Gallery?

    Hi

    Try this

    Filter( Shuffle('DataSource');
    Or( IsBlank(CB_Bereich.SelectedItems); IsEmpty(CB_Bereich.SelectedItems); 'ColumnName' in CB_Bereich.SelectedItems );
    Or( IsBlank(CB_Dropdown2.SelectedItems); IsEmpty(CB_Dropdown2.SelectedItems); 'ColumnName2' in CB_Dropdown2.SelectedItems );
    Or( IsBlank(CB_Dropdown3.SelectedItems); IsEmpty(CB_Dropdown3.SelectedItems); 'ColumnName3' in CB_Dropdown3.SelectedItems ) )

    Refer this link also : Power Apps Filter Gallery With Multiple Dropdowns - Matthew Devaney

    Thanks!

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete