Filtering a gallery - One choice not working

(0) Share

Report

Posted on by Steve_Ford

Hi folks,

I'm using Power Apps to filter a gallery based on a dropdown or combo box (I don't mind which).

I need to see if a single choice appears anywhere in a multi-select choice column and display all results where this is true. The specific use case is ICT projects where we have a list of secondary teams involved and we need to filter on team to see if each team is listed as a secondary team.

No matter how I filter or search I can find all of my results except those for one particular team, the "Digital Adoption Team", whose results never appear.

Current combo box properties:

Choices('galleryname'.'Other ICT teams involved')

Current gallery properties:

Filter(

'galleryname',

Concat(ComboBox1.SelectedItems,Value&" ,") in

Concat('Other ICT teams involved',Value&" ,")

)

It likewise doesn't work with a dropdown and

Filter('galleryname',Dropdown1.Selected.Value in 'Other ICT teams involved'.Value)

What am I missing please?

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (1)

Answers (0)

WarrenBelz 151,936 Most Valuable Professional on at

Like (0)

Report
Re: Filtering a gallery - One choice not working

Hi @Steve_Ford ,

That is because you have a many-to-many filter and the complete Concat value of the Combo Box will never exactly match the complete Concat value of the field. You need something like this

Ungroup( ForAll( ComboBox1.SelectedItems As _Data, Filter( 'galleryname', _Data.Value in 'Other ICT teams involved'.Value ) ), "Value" )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No