Power Platform Community Forum Thread Details

Hi everyone

I've created an app pointing to a SharePoint list and on the home screen of this app I want to be able to filter a gallery of items. One of the columns in the list is a multi-choice column and I want to filter on this column using a multi-choice combo box. I can get this to work where the chouces match exactly for a record using the code below:

Filter('Clients',
Concat(comboInvolveArea.SelectedItems,Value&",") in
Concat('Involvement Areas',Value&",")
)

So with this if a client has involvement areas a, b and c and I filter on the combo box with a, b and c they will appear in the filtered list. However, I want it to filter any clients that contain any of the choices in the combox box. So for example, if I search for involvement areas a and c I want a client with a and b to show as well as someone who has b and c. I've tried a few different approaches with adding a middle-main collection and using ForAll on the combo box choices but I can't seem to find a way of getting this to work. I found a post here which gives an example of using ForAll to achieve what I want but when I do this nothing is returned when i filter the list.

Any assistance or pointers would be very welcome. Thanks in advance for your help.

Categories:

Building Power Apps