Distinct – unique values in Power Apps – Trainings, consultancy, tutorials

Distinct – unique values in Power Apps

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:

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

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

now you only see the list of unique values:

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:

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

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

now you only see the list of unique values: