Answered

Multi-Select Combobox to filter Gallery w\Multiple Selection Choice column

(0) Share

Report

Posted on by jditz

Hello and thanks in advance for reading this! I have a SharePoint list 'LawExcerpts' with two columns:

LawName (text)
FocusArea (choice, allows multiple selection)

In Power Apps, I have a screen with a combobox and a gallery control. Items selected in the combobox will filter the gallery list.

ComboBox1 (Items = Choices(LawExcerpts.FocusArea), Allows multiple selections)
Gallery1 (Items = Filter(LawExcerpts,FocusArea in ComboBox1.SelectedItems.Value))

I'm getting an error in the Gallery Items formula on FocusArea: 'Invalid argument type. Cannot use table values in this context.' I understand FocusArea is considered a table and can't be compared as written. I just can't figure out how to fix this.

All responses (4)

Answers (1)

Michael E. Gernaey 41,385 Super User 2025 Season 1 on at

Like (0)

Report

Re: Multi-Select Combobox to filter Gallery w\Multiple Selection Choice column

Thanks, @jditz if you can mark mine as the Accepted Solution I would appreciate it
raks on at

Like (0)

Report

Re: Multi-Select Combobox to filter Gallery w\Multiple Selection Choice column

Thanks @jditz you have the best solution I've found
jditz on at

Like (1)

Report

Re: Multi-Select Combobox to filter Gallery w\Multiple Selection Choice column

Thanks @FLMike! A comment in that link got me to the solution I used:
Filter
(Source,
IsBlank(combo_box.SelectedItems.Value) || IsEmpty(combo_box.SelectedItems) || true in ForAll(Column.Value, ThisRecord in combo_box.SelectedItems.Value)
)
Verified answer

Michael E. Gernaey 41,385 Super User 2025 Season 1 on at

Like (1)

Report

Re: Multi-Select Combobox to filter Gallery w\Multiple Selection Choice column

Hello,

If you search for Multi Selection choice filtering you will find loads and loads of requests for that exact same thing.

Its a horribly supported thing to do in Power Apps. Anytime you can avoid doing it, using another method, versus choice field, please do, you'll be so much happier.

But here is the only real good solution.
Solved: Filter multiple selection choice column - Power Platform Community (microsoft.com)

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey