The Distinct functions works in Power Apps quite predictably – I mean analogically to DAX or SQL.

For example you can use it to create a selection menu – like now you can select a color from this table:

Distinct – unique values in Power Apps

Insert a ComboBox control. As items you can simply use a column, but then these items are seen duplicated:

Distinct – unique values in Power Apps

So let´s use the Distinct to wrap the column.

Distinct – unique values in Power Apps

now you only see the list of unique values:

Distinct – unique values in Power Apps