Unanswered

Can you filter out a value from a combo box if it was chosen in another combo box?

(1) Share

Report

Posted on by futr_vision

831 Moderator

I have 3 combo boxes. All use the same datasource. Let's say the data source is 'Make of Car'. What I want to do is remove from the other combo boxes the choices made in the current combo box.

Example

Let's say we have 5 makes of cars. Chevy, Ford, Tesla, Toyota and Kia.

If the user chooses Ford in the first combo box then Ford is removed from the second and third combo box

If Toyota is chosen in the second combo box then Toyota is removed from the first and third combo box

If Tesla is chosen in the third combo box then Tesla is removed from the first and second combo box

Is this possible with some type of filter? I think it should be.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Pro_User_365 546 on at

Like (0)

Report
Hi @futr_vision ,
Yes, you can filter out selected values from other combo boxes. Assuming you have three combo boxes named ComboBox1, ComboBox2, and ComboBox3, you can set the Items property of each combo box to exclude the selected items in the others. Here's an example formula you could use for ComboBox2:

Filter('Make of Car', Value <> ComboBox1.Selected.Value && Value <> ComboBox3.Selected.Value)
And adjust similarly for ComboBox1 and ComboBox3, referencing the other combo boxes accordingly. This way, when an item is selected in one combo box, it will be excluded from the list in the other combo boxes.

Note: After receiving the answer, if you find it helpful, please consider accepting it. 😊 Regards, Ali Shahzad

Was this reply helpful? Yes No
MudassarSZ365 591 on at

Like (0)

Report
Hi @futr_vision ,
For the third combo box, you want to exclude the selections from the first and second combo boxes:
Items = Filter(DataSource, Value <> ComboBox1.Selected.Value && Value <> ComboBox2.Selected.Value)

If you find this answer helpful, please accept it. 😊

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (1)

Report

Hmm. What do you use for Value? That seems to cause issues. I played around with SelectedItems but that doesn't work either. I'm sure I'm forgetting something I learned a couple years ago when I built my last PowerApp. 🙂

Was this reply helpful? Yes No
Pro_User_365 546 on at

Like (0)

Report
@futr_vision ,
Yes, you can filter out selected values from other combo boxes. To do this, set the Items property of each combo box to exclude the selections from the other combo boxes. For example, for the second combo box, you would use:
Filter('Make of Car', Value <> ComboBox1.Selected.Value && Value <> ComboBox3.Selected.Value)
Repeat this pattern, adjusting the references for each combo box accordingly. This way, when a make of car is selected in one combo box, it will not appear as an option in the others.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (1)

Report

'Value' is not recognized.

Was this reply helpful? Yes No
Pro_User_365 546 on at

Like (0)

Report
It looks like the 'Value' part of your formula is causing an issue because PowerApps can't recognize it. In PowerApps, to reference the actual value selected in a combo box, you should use the .Selected property followed by the actual field name of the data source that holds the value you want to filter out.
For example, if your 'Make of Car' data source has a field called 'MakeName', the formula for ComboBox2 should be:

Filter('Make of Car', MakeName <> ComboBox1.Selected.MakeName && MakeName <> ComboBox3.Selected.MakeName)
You need to replace MakeName with the actual field name from your 'Make of Car' data source that contains the car makes. This should filter out the selected car makes from the other combo boxes as desired.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (1)

Report

Better but I still have issues. I have ComboBox1 selected and get this error now.

Was this reply helpful? Yes No
Pro_User_365 546 on at

Like (0)

Report
From your screenshots, it looks like you're encountering an error due to incorrect syntax or reference in your formula. The error message suggests that 'Value' isn't recognized because it's not the correct field name in your 'Brands' data source.
When you reference the selected item in a combo box, you need to use the actual column name from your data source. If your column's name is 'BrandName', then your formula should look something like this:
Filter(Brands, BrandName <> ComboBox1.Selected.BrandName && BrandName <> ComboBox3.Selected.BrandName)
Make sure to replace BrandName with the actual column name used in your 'Brands' data source. If the error persists, please check the names of the columns in your data source and ensure they match exactly with your formula.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

No offense but I feel like I am talking with ChatGPT.

As for the column name I have the correct name in my code. I've double checked.

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (0)

Report

The only solution I can find so far is to check the two previous field's value and filter those out. If I try to get too fancy it creates that circular reference.

Was this reply helpful? Yes No