Unanswered

Multi filter with a combobox

(0) Share

Report

Posted on by Capucine_Sophie

Hello,

I would like to filter a collection with multiple combobox:

ClearCollect(
ColFitlerAlerts,
Filter(VarAlert,
Or(!IsEmpty(Filter(CBMarket.SelectedItems, Value = MARKET_ID)), IsEmpty(CBMarket.SelectedItems)),
Or(!IsEmpty(Filter(CBStatus.SelectedItems, INT_STATUS_ID = INT_STATUS_ID ) ), IsEmpty(CBStatus.SelectedItems)
)))

The first filter with the Market is working well.

For the second, I can't figure it out.

The items of my Combobox is

And in my collection I have a column INT_STATUS_ID

Can you please help me ?

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Capucine_Sophie ,

Could you please tell me what you want with combo boxes?
I think it will be better to show some examples or screenshots.

Thanks.
Rimmon
Capucine_Sophie on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Rimmon,

I want to filter my Collection VarAlert with this formula using 2 combobox.

ClearCollect(
ColFitlerAlerts,
Filter(VarAlert,
Or(!IsEmpty(Filter(CBMarket.SelectedItems, Value = MARKET_ID)), IsEmpty(CBMarket.SelectedItems)),
Or(!IsEmpty(Filter(CBStatus.SelectedItems, INT_STATUS_ID = INT_STATUS_ID ) ), IsEmpty(CBStatus.SelectedItems)
)))

The first filter with the Market is working. The items of my combobox is

The second part in red with the alert Status is not working. Here is the combobox set up

I column I want to filter in my collection is named INT_STATUS_ID
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
If combo box is single selection, please try this:
ClearCollect(ColFitlerAlerts, If(IsBlank(CBMarket.Selected)&&IsBlank(CBStatus.Selected),VarAlerts,Filter(VarAlerts,MARKET_ID=CBMarket.Selected.Value&&INT_STATUS_ID=CBStatus.Selected.INT_STATUS_ID)))
If combo box is multiple selection, please try this:
ClearCollect(ColFitlerAlerts, If(IsEmpty(CBMarket.SelectedItems)&&IsBlank(CBStatus.SelectedItems),VarAlerts,Filter(VarAlerts,MARKET_ID in CBMarket.SelectedItems.Value&&INT_STATUS_ID in CBStatus.SelectedItems.INT_STATUS_ID)))
Capucine_Sophie on at

Like
a
(0)

Report
Copy link

Link copied!

I would like to keep this formula structure as I will add other filters.

ClearCollect(
ColFitlerAlerts,
Filter(VarAlert,
Or(!IsEmpty(Filter(CBMarket.SelectedItems, Value = MARKET_ID)), IsEmpty(CBMarket.SelectedItems)),
Or(!IsEmpty(Filter(CBStatus.SelectedItems, INT_STATUS_ID = INT_STATUS_ID ) ), IsEmpty(CBStatus.SelectedItems)
)))
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi!
Have you tried just use second condition to filter data?
ClearCollect( ColFitlerAlerts, Filter(VarAlert, Or(!IsEmpty(Filter(CBStatus.SelectedItems, INT_STATUS_ID = INT_STATUS_ID ) ), IsEmpty(CBStatus.SelectedItems) )))
If it cannot filter data, please check the data type: INT_STATUS_ID = INT_STATUS_ID
If they are different types, I suggest change them to same data type:
Text(INT_STATUS_ID) = Text(INT_STATUS_ID)
Or
Value(INT_STATUS_ID) = Value(INT_STATUS_ID)
Capucine_Sophie on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

The Market alone is working well

ClearCollect(
ColFitlerAlerts,
Filter(VarAlert,
Or(!IsEmpty(Filter(CBMarket.SelectedItems, Value = MARKET_ID)), IsEmpty(CBMarket.SelectedItems))))

With the drop down set up like this :

If I do the status alone it's not working - (I tried with Text and value too):
ClearCollect(
ColFitlerAlerts,
Filter(VarAlert,
Or(!IsEmpty(Filter(CBStatus.SelectedItems, INT_STATUS_ID = INT_STATUS_ID ) ), IsEmpty(CBStatus.SelectedItems))))

Here is how the drop down is set up:

In my data base I have INT_STATUS_ID which I want to filter
Cat Schneider 488 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not sure if this is of much help for your situation, but I previously answered a question related to multiple multi-field choice columns, and did a blog post breaking down some of the logic used to get to the solution (🪄🐈‍⬛ TnT #4 🧨 | Yer a wizard, Cat! (yerawizardcat.com)).
Capucine_Sophie on at

Like
a
(0)

Report
Copy link

Link copied!

@ANB or @SpongYe Do you have any idea on how to solve this by any chance if you have time ? 🙂