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

Like (0) Share

Report

Posted on 26 Sep 2023 16:38:28 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 45,865 Super User 2025 Season 2 on 04 Jul 2024 at 16:12:13

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 04 Jul 2024 at 13:53:03

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 26 Sep 2023 at 18:54:45

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 45,865 Super User 2025 Season 2 on 26 Sep 2023 at 17:36:02

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