Hi everyone,
I’m working on a PowerApps application where I need to filter a dataset (`'Operational Issues'`) a few times based on selected values from dropdowns. Currently, the first selection is the business unit combobox (`bunitCombo`). Based on the selected value of that combobox, I need the `countryCombo` to display distinct `Country` values in its dropdown.
Here’s what I’ve done so far.:
```Filter('Operational Issues', BusinessUnit.Value = DataCardValue1.Selected.Value)```
This correctly returns all records matching the selected `BusinessUnit`, but that includes duplicates/repeats:
But when I update it with Distinct it returns no values:
```Distinct(Filter('Operational Issues', BusinessUnit.Value = DataCardValue1.Selected.Value), Country)```
I expected this to return a single-column table with unique `Country` values, but it doesn’t return any values at all. It’s completely empty.
---
Schema
- 'Operational Issues' List:
- IssueName - Text column
- BusinessUnit - Choice column
- Country - Choice column
- Customer - Lookup column (references the 'Title' column in the Customers list)
- DisplayName - Additional lookup column (derived from the Customer column to get the DisplayName from Customers)
- LogoURL - Additional lookup column (derived from the Customer column to get the LogoURL from Customers)
- Priority - Choice column
- ReportMonth - Choice column
- IssueDescription - Multiple lines of text column-
- 'Customers' List that's related:
- LogoURL - Text column (hyperlinks)
- FullName - Text column
- DisplayName - Text column
- Country - Choice column
And this is what my Operational issues list currently shows for Business Unit and Country:
---
