I am currently trying to create several dropdown options based on a SQL-Database in PowerApps. I am having no issues with having the first Dropdown show the required information, options and default value. However, when I am trying to setup my second dropdown, and using the filter function, I am able to filter, but there are lots of duplicates in the list, making it not very pretty. I'll try to explain the problem with examples. Dropdown1 shows 'Vendor' Dropdown2 shows 'Customer' Dropdown1 Items function is Distinct('[dbo].[TableName]';Vendor) Dropdown2 Items function is Filter('[dbo].[TableName]';Dropdown1.Selected.Value in Vendor) By using the above, the same 'Customer' appreas several times under certain 'Vendors', because in the data itself, some customers have 'purchased' so to say, several times at that specific 'Vendor'. Is there a way to make it so that the duplicates go away?