web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to filter Power Ap...

Power Apps

Unanswered

How to filter Power Apps Gallery with a multi-select choice column

(0) Share

Report

Report

Posted on by powerupguy

16

Dear Experts,

I need to filter Power Apps gallery with a multi-select choice column in SharePoint.

I am finding myself at wits end and need some help.

In the below example, i need to filter the gallery (List1) using a combo-box (Column1) with the source as a multi-select choice column.

I would be grateful if you help me with the code.

Filter(List1, .........)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@powerupguy

Filter( yourlist, yourchoicecolumn.Value in ComboBox2.SelectedItems.Value )

If you want the list to show all the items if the combobox is blank then

Filter( yourlist, Len(ComboBox2.Selected.Value) = 0 || yourchoicecolumn.Value in ComboBox2.SelectedItems.Value )

Was this reply helpful? Yes No
powerupguy 16 on at

Like (0)

Report
Copy link

Link copied!

yourchoicecolum.value gives an error message which says - "Invalid argument type. Cannot use table value in this context"

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@powerupguy ,

You have a many-to-many filter here - the below is not Delegable (and you cannot make it so), but try this

If( Len(Combo2.Selected.Value) = 0, List1, Ungroup( ForAll( Combo2.SelectedItems As aSel, Filter( List1, aSel.Value in Column1.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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation