web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter products that c...
Power Apps
Unanswered

Filter products that contain ALL selected from multichoice column. Bonus question: Filtering products based on data not shown in gallery.

(0) ShareShare
ReportReport
Posted on by 85

Hello internet family. 

I'm working on building an app for product search based on a multichoice column. My issue is I only want to show products that contain ALL the selected filters.

i.e. Product A is XYZ, Product B is XY. I only want the gallery to show Product A if XYZ is selected and to show A and B if XY is selected. 

I cannot find how to do this and maybe I am not looking in the right places or perhaps it cannot be done. 

 

Editing to hopefully clarify and receive a response. 

 

I have a list of Products: A, B, C, D in a column labeled "Title"

Each product has properties connected to them. Some overlap and some do not. These are selected in a choice column.

            A - brown, fluffy, cute

            B - brown, prickly, mean

            C - Green, fluffy, cute

            D - Blue, mellow, fluffy

 

I want users to be able to select the properties in a combobox checkbox select and for the proper products to show up only if their properties match all selected. 

 

User selects: fluffy and cute

Gallery shows: A and C because both have fluffy and cute as properties. The gallery will not show D because it only contains fluffy.

 

User selects: fluffy

Gallery shows A, C, and D

 

User selects: fluffy and mean

Gallery shows nothing or message that says no matches.

 

 

The other question I had is, is it possible to filter Products by an identifier like the above example without the identifier being shown in the gallery? Using the example above, the gallery would filter the same way, but XYZ will not be listed in a text box. 

 

Thank you!

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard