How to Populate Distinct Values in Power Apps Combo Box?

Do you want to bind distinct values in a Power Apps combo box? In this Power Apps tutorial, I will explain how to populate distinct values in a Power Apps combo box.

Also, I will show you how to use a distinct function for a Power Apps combo box person column.

Populate Distinct Values in Power Apps Combo Box

In this section, I will show you how to use distinct() function in a Power Apps combo box control.

Example,

I have a SharePoint list [Customer Details], that has various columns like:

Coulmn Name	Data Type
User Name	Title
Country	Single line of text
Subscription Type	Choice [“Premium”, “Standard”, “Basic”]
Subscription Handled By	Person or group

We can see in the above SharePoint list, that the title column contains duplicate values.

But I need to bind the title column in the Power Apps combo box control without any duplicate values. Follow the below steps to how we can achieve it:

I have created a Power Apps Canvas app and then added a Combo box control, that is connected to the above SharePoint list title column. Next, Whenever the user expands the combo box control, duplicate values will not be visible.

To achieve it, follow the below steps:

• On the Power Apps screen, insert a Combo box control -> Set its Items property as:

Distinct('Customer Details',Title)

Where,

• Customer Details = SharePoint list name
• Title = SharePoint list title column

• Save, Publish, and Preview the app. Now, the combo box control doesn’t contain the duplicate values from the above SharePoint list title column.

This is how to use distinct() function for Power Apps combo box control.

If the SharePoint list contains a choice column, we can’t use a distinct function for the Power Apps combo box control, but we can for the SharePoint list person column.

Power Apps distinct Combo box person column

Are you using a Power Apps Combo box control for SharePoint list person or group type column and facing duplicate values in it? Then follow the below steps:

For example, [I have taken the same above SharePoint list person column as my reference]

I have created a Power Apps Canvas app and then added a Combo box control that is connected to the above SharePoint list person column. Next, Whenever the user expands the combo box control, duplicate values will not be visible.

To achieve it, follow the below steps:

• On the Power Apps screen, insert a Combo box control -> Set its Items property as:

Distinct('Customer Details','Subscription Handled By'.DisplayName)

Where,

1. Customer Details = SharePoint list name
2. Subscription Handled By = SharePoint list person column

• Save, publish, and preview the app. Now, the combo box control doesn’t contain duplicate values from the above SharePoint list person column.

This is how to avoid the duplicate value in the Power Apps combo box control by using the SharePoint list person column.

Conclusion

In this Power Apps tutorial, I will explain how to bind distinct values to a Power Apps combo box control. Also, I have explained to you how to use a SharePoint list person column for a Power Apps combo control without any duplicate values.

You may also like:

• How to Set Combo Box Default Value in Power Apps?
• How to Set Dropdown Value on OnVisible in Power Apps?
• How To Save Power Apps Combobox Multiple Values To SharePoint List?
• Power Apps Combo Box Sort
• Power Apps check if a Combo box is empty