Answered

Filtering Combo Boxes to only show items not selected by other combo box

(0) Share

Report

Posted on by ChrisSouthgate

I'm currently testing a solution and I am struggling to configure the combo boxes.
I have created a collection 'ColControlsChoices'
I have ComboBox1 and ComboBox2. These both show the same choices from ColControlsChoices.
I want to configure them so that if Items are selected in one ComboBox the options are not available in the other ComboBox.
What is the correct syntax for achieve this?

Thanks in advance,
Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (3)

Sort by

Verified answer

Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ChrisSouthgate

You can accomplish this by utilizing the collection function.

Combo Box 1 OnChange Property:

ClearCollect(
cmbofil,
Filter(
ColControlsChoices,
!(ComboBox1.Selected.Value in Columnname)
))

Combo Box 2 Item Property:

cmbofil

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
ChrisSouthgate 16 on at

Like
a
(1)

Report
Copy link

Link copied!

That worked perfectly. Thank you.

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
You want to avoid using a collection; consider this alternative approach.

In Combo Box 2 item:

Filter(
ColControlsChoices,
!(ComboBox1.Selected.Value in Columnname))

Thanks!

Was this reply helpful? Yes No
Verified answer

BrunoTw 15 on at

Like
a
(1)

Report
Copy link

Link copied!
You can also accomplish the same using below logic.

ComboBox1 > Items: ColControlsChoices ComboBox2 > Items: Filter(ColControlsChoices,!(ThisRecord in ComboBox1.SelectedItems))

Was this reply helpful? Yes No