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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
jditz on at

Like
a
(1)

Report
Copy link

Link copied!

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)
)

1 people found this reply helpful.

Was this reply helpful? Yes No
raks on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No