I have a Sharepoint List called "Locations" with 100 locations. This has columns including Title, Name, Code, Zip etc
I have another Sharepoint List Called "VendingMachines" with 20 Vending Machines. This has columns such as name, type, serial etc and a column called "VendingLocation" that is a lookup on the "Locations" list.
In my Canvas PowerApp I have a gallery of the "VendingMachines" which works fine.
I then put a DropDown (Or ComboBox) at the top to filter by Location. This is populated from the "Locations" List.
That all works great.
However I'd like the DropDown (or Combo) to just be populated by the distinct locations that are in the "VendingMachines" list. So the filter will only show locations where there is actually a vending machine and not all 100 possible locations..
I've tried Choices(VendingMachines.VendingLocation).Value but that returns all 100 possible locations.
