You’re offline. This is a read only version of the page.
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.
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.
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.
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.
Better but I still have issues. I have ComboBox1 selected and get this error now.
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:
Share
Report
All responses (
Answers (
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.
'Value' is not recognized.
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.
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. 🙂
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. 😊
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
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
