web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Powerapps - remove dup...

Power Apps

Unanswered

Powerapps - remove duplicate values from choice

(0) Share

Report

Report

Posted on by Nbz78

64

Hi, I have a dropdown that will display values from User List where the column name is Titles.

User can add new Titles or select existing Titles.

How can i remove the duplicate values as example below and display only one if the name is the same?

Data card Update Property:

If(
    !IsBlank(ComboBox6.SelectedItems),
    ComboBox6.Selected.Titles,
    ComboBox6.SearchText
)

Combo box Items Property:

User

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

Hasrie 202 on at

Like (1)

Report
Copy link

Link copied!

Hi @Nbz78 You may refer to this tutorial for removing duplicate values from Matthew Devaney

https://www.matthewdevaney.com/remove-duplicate-rows-from-a-power-apps-collection/

Was this reply helpful? Yes No
WarrenBelz 155,283 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Nbz78 ,

Your Combo Box Items

Sort( Distinct( User, Title ), Value )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Nbz78 64 on at

Like (0)

Report
Copy link

Link copied!

the Update Property returned error like this once i changed the Items. what should i do?

Was this reply helpful? Yes No
timl 36,823 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Nbz78

You'll need to modify your formula to reference the Value property of the selected item like so:

If( !IsBlank(ComboBox6.SelectedItems), ComboBox6.Selected.Value, ComboBox6.SearchText )

Was this reply helpful? Yes No

Join the conversation