cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jlatimer
New Member

Filtering multiselect field with multiselect combobox

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.

1 ACCEPTED SOLUTION

Accepted Solutions
jlatimer
New Member

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.

View solution in original post

7 REPLIES 7
zmansuri
Super User
Super User

Filter(ListName, ColumnName.Value in ComboBox.SelectedItems || IsEmpty(ComboBox.SelectedItems)

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…

Show pictures.

ComboBox Items.

Databse Column Schema

Gallery Item Code

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
Community Champion
Community Champion

Hi @jlatimer 

 

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

 

StalinPonnusamy_0-1631892011973.png

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.

 

 

jlatimer
New Member

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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,770)