Answered

filter gallery with 2 comboboxes AND-OR text box

(0) Share

Report

Posted on by enlitzinger

Hi, I'm attempting to filter a gallery based on selections in comboboxes or a text box. I'll settle with filtering the gallery with only 1 selection in any of my filter options. It would be great to do an AND / OR filter across all the options.

Issue: The below formula is on my gallery. I have 2 combobox dropdowns - each filtering on a specific value column (Review Elements and Subject Matter or Content Topics). Additionally, I have a text box (Required Language) that will filter based on keywords. The below formula is showing no errors, but only ComboBox2 (review elements) is working. Where am I going wrong?

Filter([@'Standards, Disclaimers & Disclosures'],'Review Element(s)' in ComboBox2.SelectedItems.Result, Or('Subject Matter or Content Topic(s)' in ComboBox2_1.SelectedItems.Result, Or(TextInput1.Text in 'Required Language')))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,559 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @enlitzinger ,
Assuming ComboBox2 is working, try this
Filter( [@'Standards, Disclaimers & Disclosures'], 'Review Element(s)' in ComboBox2.SelectedItems.Result || 'Subject Matter in ComboBox2_1.SelectedItems.Result || Content Topic(s)' in ComboBox2_1.SelectedItems.Result || TextInput1.Text in 'Required Language' )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Krishna92 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@enlitzinger

Could you please try using the formula and check if that helps with resolution of the issue.

Filter([@'Standards, Disclaimers & Disclosures'], 'Review Element(s)' in ComboBox2.SelectedItems.Result Or('Subject Matter or Content Topic(s)' in ComboBox2_1.SelectedItems.Result Or(TextInput1.Text in 'Required Language')))

If this information helps you with resolution, please consider giving a thumbs up and mark the solution as resolved.

Was this reply helpful? Yes No