Power Platform Community Forum Thread Details

I've been looking for some time for a solution to my filtering with a multi option combination box in Power Apps. I have a SharePoint list as my backend (i know there will be delegation issues, but records wont ever go over 200). This list has 5 columns as seen below, I added the Expertise column as part of my testing when i saw that the Fields of Expertise was a managed meta data field.

In PowerApps, I've tried creating a collection on start to have all the items of the "Expertise" Column

ClearCollect(
 colStaffExp,Choices('Expertise List'.Expertise)
);

I then add that to the Combobox Items.

On the Gallery, I've tried various combination of filters and the only one that somewhat worked wasn't even a filter but a method of hiding the entries using a flexible height gallery (Reza Dorrani's method)

The filters I've used kept complaining about the use of a table when using the IN function even when I use a collection. the articles and videos I've seen seem to not take into account that the Expertise field I have contains multiple values. but I could be misinterpreting that.

Ideally I would have this filter be used with check boxes on the left as seen here