Answered

Filtering using with one or more values

(0) Share

Report

Posted on by Zeslonatrus

Hello,

I would like to ask for advice on creating an application. I have this gallery filter bound to ComboBoxes. The problem starts when I try to apply a filter to only one of the ComboBoxes. At such a moment, the filter does not work, as if it is waiting for the second one to fill.

Please advise how to solve this problem.

My code is this:

Sort(Filter('Hardware Catalogs';'Item Group' in ComboBox2.SelectedItems And 'Vendor' in ComboBox3.SelectedItems);'Created On';SortOrder.Descending)

THANK YOU FOR ANY ADVICE!

Categories:

Building Power Apps

All responses (11)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Sort(Filter('Hardware Catalogs';'Item Group' in ComboBox2.SelectedItems Or 'Vendor' in ComboBox3.SelectedItems);'Created On';SortOrder.Descending)
Joel-Garrison 63 on at

Like
a
(0)

Report
Copy link

Link copied!
Howdy Zeslonatrus,

Can you double check your Syntax for us please?

Looks like you're using close ```;``` in places that it doesn't work. I believe you might want to try using ``` , ``` instead. Now this might have just been a weird Copy and Paste into the Forum.

Sort( Filter( 'Hardware Catalogs', 'Item Group' in ComboBox2.SelectedItems, 'Vendor' in ComboBox3.SelectedItems); 'Created On', SortOrder.Descending );

Sort and SortByColumns functions in Power Apps - Power Platform | Microsoft Learn
Filter, Search, and LookUp functions in Power Apps (contains video) - Power Platform | Microsoft Learn
Zeslonatrus 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response!

But the "Or" function doesn't suit me, because I would like to get a filter that conditions in both cases of the choice. When I use the "Or" function, the result shows more data than I need. I would only like to achieve that when I have only one option filled in, the filter works.
Zeslonatrus 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, but ";" is fine, i think this is just because im from Europe
Joel-Garrison 63 on at

Like
a
(0)

Report
Copy link

Link copied!
I'll defer to you on European Syntax 🙂

However, still take a look at my syntax below. Make sure you're using the correct Filter Syntax using the seperator between your Formulas:

IE: Filter(Table*, Formula1 [, *Formula2*, ... ] )

Sort( Filter( 'Hardware Catalogs', //Table 'Item Group' in ComboBox2.SelectedItems, //Formula1 'Vendor' in ComboBox3.SelectedItems); //Formula2 with Filter Close Par 'Created On', SortOrder.Descending );
Zeslonatrus 48 on at

Like
a
(0)

Report
Copy link

Link copied!

I dont know if we understand each other well, sorry, english is not my main language.

My code woks well for me! But only when i use both of ComboBoxes. If i want use JUST ComboBox2, or JUST ComboBox3, Gallery doesnt show anything. It wait util I fill both of them. And i want make this ComboBoxes work without each other and with each other if you understand 🙂 I was trying your code but its not work and want me make from "," ";".

Thank you for you replies!
madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
You could use something along the lines of:
Sort(Filter('Hardware Catalogs'; If(!IsEmpty(ComboBox2.SelectedItems) And !IsEmpty(ComboBox3.SelectedItems); 'Item Group' in ComboBox2.SelectedItems And 'Vendor' in ComboBox3.SelectedItems; !IsEmpty(ComboBox3.SelectedItems); 'Vendor' in ComboBox3.SelectedItems; !IsEmpty(ComboBox2.SelectedItems); 'Item Group' in ComboBox2.SelectedItems);'Created On';SortOrder.Descending)

which will check if they're both selected, use both, and if only 1 is selected, use that one. I'm not sure my syntax is 100% correct since you're in a different region than me but thats the general idea behind it
Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @Zeslonatrus

I think this is what you might be looking for:

Sort( Filter('Hardware Catalogs'; ('Item Group' in ComboBox2.SelectedItems Or IsEmpty(ComboBox2.SelectedItems))And ('Vendor' in ComboBox3.SelectedItems Or IsEmpty(ComboBox3.SelectedItems)) ); 'Created On'; SortOrder.Descending )
Zeslonatrus 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much!!
Joel-Garrison 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Yep, Zeslonatrus was correct I was missing the Or in his post. 🙂 Thanks for catching that and getting the answers out! Awesome!