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

Filter with a combo box multiple selection

Hi, I have a combo box with multiple selections that are shown in a label field separated with commas (product1, product2, etc), I need to filter another combo and have only the records that were selected in the first combo box.

 

Thanks for the help

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

@gaffyjes Check below threads, it might help you:

  1. Filtering one combo-box items, based on another combo-box selected items 
  2. Filter Combo box items based on another multi select Combo box item 
  3. https://powerusers.microsoft.com/t5/Building-Power-Apps/combo-boxes-filtering-on-different-combo-box... 

Please click Accept as solution if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

 

View solution in original post

2 REPLIES 2
Super User
Super User

@gaffyjes Check below threads, it might help you:

  1. Filtering one combo-box items, based on another combo-box selected items 
  2. Filter Combo box items based on another multi select Combo box item 
  3. https://powerusers.microsoft.com/t5/Building-Power-Apps/combo-boxes-filtering-on-different-combo-box... 

Please click Accept as solution if my answer helped you to solve your issue. This will help others to find the correct solution easily. If the answer was useful in other ways, please consider giving it ‌‌👍

 

View solution in original post

Community Support
Community Support

Hi@gaffyjes,

Based on the issue that you mentioned, do you want to filter Combo Box based on another multi-select Combo Box?

Could you please share a bit more about the scenario?

Here is my scenario, you can check to compare with yours.

combo.png

Set the Items property for both of the Combo Boxes as below:

 

Choices([@Test1029].Combo1) // For the Combo1 column
Choices(Test1029.Combo2)  // For the Combo2 column.

 

Set the DefaultSelectedItems property of the Combo Box corresponding to the Combo2 column as below:

 

LookUp(
    Test1029,
    Concat(
        DataCardValue11.SelectedItems.Value,
        Value & ","
    ) in Concat(
        Combo1,
        Value & ","
    )
).Combo2

 

Note: DataCardValue11 represents the Combo Box corresponding to the Combo1 column.

combo2.png

Hope it could help.

Best Regards,

Qi

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (18,884)