Unanswered

How to combine multiple ComboBoxes for filtering a Gallery?

(0) Share

Report

Posted on by PowerAppBuilder24

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

Categories:

Using Apps Using Formulas

All responses (4)

Answers (0)

PowerAppBuilder24 20 on at

Like (0)

Report

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_404 6 on at

Like (0)

Report

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 20 on at

Like (0)

Report
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_404 6 on at

Like (1)

Report

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.