Announcements
Really curious as to why this breaks. I have a combo box that reads from a column(column 1) in a table. This column has duplicates. The dependent combo box also reads from the same table but column 2. If I don't use Distinct on the first combo box then everything works fine except, I have all the duplicate values from column 1 in the combo box. When I add Distinct to the items for that combo box then I get a de-duped list but the dependent combo box breaks. Why is that? Is it because both combo boxes are using the same table?
Interesting. If I change the dependent combo box items to be
Filter('DataSource', 'DataSourceColumnValue' =Control.Selected.Value)
from
Filter('DataSource', 'DataSourceColumnValue' =Control.Selected.DataSourceColumnValue)
Then it works.
I think I explained that correct. Still curious why the first works and not the second which is what PowerApps enters by default when you use the 'Depends On' functionality of the control.
Hi @futr_vision
The Distinct function returns a single column table with the column name value. That's the reason why when you set the Items property of a combo box to Distinct, the syntax to reference the value is Control.Selected.Value
https://learn.microsoft.com/en-gb/power-platform/power-fx/reference/function-distinct
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 600
WarrenBelz 478 Most Valuable Professional
Valantis 322
