Distinct – unique values in Power Apps (2024)

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 (1)

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 (2)

See Also
Collect, Clear, and ClearCollect functions - Power PlatformHow to refresh Collection in powerappsWhat is Collect and ClearCollect in PowerAppsString.Remove Method (System)

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

Distinct – unique values in Power Apps (3)

now you only see the list of unique values:

Distinct – unique values in Power Apps (4)

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 (7)

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 (8)

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

Distinct – unique values in Power Apps (9)

now you only see the list of unique values:

Distinct – unique values in Power Apps (10)

Distinct – unique values in Power Apps (2024)

FAQs

How do you get unique values in Power Apps? ›

Distinct – unique values in Power Apps
  1. Insert a ComboBox control. As items you can simply use a column, but then these items are seen duplicated:
  2. So let´s use the Distinct to wrap the column.
  3. now you only see the list of unique values:
  4. Leave a Reply. Your email address will not be published.

Explore More ›
How do you enforce unique values in Power Apps? ›

Click on "Column settings" and then "Edit". 3. In the column settings, you should find a checkbox saying "Enforce unique values".

Know More ›
What does distinct mean in Power Apps? ›

The Distinct function evaluates a formula across each record of a table and returns a one-column table of the results with duplicate values removed. The name of the column is Value. Fields of the record currently being processed are available within the formula.

Get More Info Here ›
What is the difference between distinct and values in DAX? ›

The DISTINCT function allows a column name or any valid table expression to be its argument but the VALUES function only accepts a column name or a table name as the argument. The following table summarizes the mismatch between data that can occur in two related tables when referential integrity is not preserved.

Know More ›
Top Articles
Why do social workers need to understand human growth and development?
Best Online Early Childhood Education Programs | BestColleges
Cheddar's Scratch Kitchen aus Daytona Beach Speisekarte
Ogłoszenia - Sprzedam, kupię na OLX.pl
Latest Posts
7 Best Products to Sell in Affiliate Marketing Online (2022)
25 Niche Site Tools That Every Amazon Affiliate Should Know » Human Proof Designs
Article information

Author: Gov. Deandrea McKenzie

Last Updated:

Views: 5997

Rating: 4.6 / 5 (46 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: Gov. Deandrea McKenzie

Birthday: 2001-01-17

Address: Suite 769 2454 Marsha Coves, Debbieton, MS 95002

Phone: +813077629322

Job: Real-Estate Executive

Hobby: Archery, Metal detecting, Kitesurfing, Genealogy, Kitesurfing, Calligraphy, Roller skating

Introduction: My name is Gov. Deandrea McKenzie, I am a spotless, clean, glamorous, sparkling, adventurous, nice, brainy person who loves writing and wants to share my knowledge and understanding with you.