Filtering multiselect field with multiselect combobox

(0) Share

Report

Posted on by jlatimer

I have a field that has multi select options (options being A, B and C).

I have created another combobox with the same options in for filtering.

Is there a way that i can filter a gallery to only show records where one (or more) of the options selected in the combobox are in the multiselect field?

Eg.

Record Choice

1 A,C

2 B,C

3 B

If the user selects A and C from the combobox i would want records 1 and 2 to show.

I havent a clue if this is even possible, ive done some digging online but it seems i need an adult. Any help would be much appreciated.

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Filter(ListName, ColumnName.Value in ComboBox.SelectedItems || IsEmpty(ComboBox.SelectedItems)
jlatimer 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for replying. I’ve tried your suggestion and I’m getting nothing back. Also the ColumnName.Value text is saying “invalid arguement type. Cannot use Table values in this context”

I’ve no idea…
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Show pictures.
ComboBox Items.
Databse Column Schema
Gallery Item Code
jlatimer 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Combobox items:
["Deterministic","Probabilistic","Not Required"]
DBase Col:
Choice, Not required, No Unique Values, MultiSelect, No Fill-in, No default
Gallery items:
Filter('HTA&R Database', SARequired.Value in DataCardValue7.SelectedItems || IsEmpty(DataCardValue7.SelectedItems))

Thanks again mate, much appreciated. The formula used just gives me the yellow delegation warning. However when i click on the formula at the top i get a red squiggle under ".Value".
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @jlatimer

I'm able to replicate this same issue. Looks like many to many relationships causing the issue.

In this example: Properties is a Multi-select choice field in SP.

Solution: We have Warren's Article/Blog to discuss and to solve it.
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

https://www.youtube.com/watch?v=44j2VRbdWjk

This will help
Verified answer

jlatimer 18 on at

Like
a
(1)

Report
Copy link

Link copied!
Thanks for the links etc... i've worked it out doing the following.

Set the combobox OnUpdate to:

Clear(colMyChoices); With( {wTest: 'HTA&R Database'}, ForAll( DataCardValue7.SelectedItems, Collect( colMyChoices, Filter( wTest, Value in SARequired.Value ) ) ) )

i then set the gallery items to:

ForAll( Distinct( colMyChoices, CountryCollab ), LookUp( 'HTA&R Database', CountryCollab= Result ) )

Thanks for pointing me in the right direction. Much appreciated.