Power Platform Community Forum Thread Details

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: