Answered

Filter Gallery with Multiple Selection ComboBox

(0) Share

Report

Posted on by NHammond37

Hello,

I have a Gallery that is filtered by 4 different ComboBoxes. Currently it works in this state if the user is only choosing one option per ComboBox. The ComboBoxes I currently have are set to use multiple selections per ComboBox. I was wondering if this can be done. I am trying to use ForAll in the Filter statement but that does not seem to work. Notice the ForAll in the middle section in the Filter statement.

Switch(true, IsBlank(ComboBox1.Selected.Value) && IsBlank(ComboBox2.Selected.Value) && IsBlank(ComboBox3.Selected.Value) && IsBlank(ComboBox4.Selected.Value), 
'Software Request',

Not(IsBlank(ComboBox1.Selected.Value)) && IsBlank(ComboBox2.Selected.Value) && IsBlank(ComboBox3.Selected.Value) && IsBlank(ComboBox4.Selected.Value),
Filter('Software Request', ForAll(ComboBox1.SelectedItems, Value) in 'Content Areas'),

Not(IsBlank(ComboBox1.Selected.Value)) && Not(IsBlank(ComboBox2.Selected.Value)) && IsBlank(ComboBox3.Selected.Value) && IsBlank(ComboBox4.Selected.Value),
Filter('Software Request',ComboBox1.Selected.Value in 'Content Areas' && ComboBox2.Selected.Value in 'Grade Level Access'))

Any help or other methods of going about this would be greatly appreciated. Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @NHammond37

Have you tried something like this?

Switch(true, IsBlank(ComboBox1.Selected.Value) && IsBlank(ComboBox2.Selected.Value) && IsBlank(ComboBox3.Selected.Value) && IsBlank(ComboBox4.Selected.Value), 'Software Request', Not(IsBlank(ComboBox1.Selected.Value)) && IsBlank(ComboBox2.Selected.Value) && IsBlank(ComboBox3.Selected.Value) && IsBlank(ComboBox4.Selected.Value), Filter('Software Request', 'Content Areas' in ComboBox1.SelectedItems.Value), Not(IsBlank(ComboBox1.Selected.Value)) && Not(IsBlank(ComboBox2.Selected.Value)) && IsBlank(ComboBox3.Selected.Value) && IsBlank(ComboBox4.Selected.Value), Filter('Software Request',ComboBox1.Selected.Value in 'Content Areas' && ComboBox2.Selected.Value in 'Grade Level Access'))

Basically updating the middle filter with this:

Filter('Software Request', 'Content Areas' in ComboBox1.SelectedItems.Value)

It might require some adjustments but let me know if this helps.

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @NHammond37 ,

Do you want to filter based on 4 combo boxes and these combo boxes are all multiple choice?

If so, you just need to use if statement to represent different conditions and do not need to use forall.

Try this formula:

Filter('Software Request', If(IsBlank(ComboBox1.Selected.Value),true,'Content Areas' in ComboBox1.SelectedItems.Value), If(IsBlank(ComboBox2.Selected.Value),true,'Grade Level Access' in ComboBox2.SelectedItems.Value), If(IsBlank(ComboBox3.Selected.Value),true,combobox3 filter rule), If(IsBlank(ComboBox4.Selected.Value),true,combobox4 filter rule) ) //please replace with your filter rule for combo box3 and combo box4

Best regards,

Was this reply helpful? Yes No