Answered

Clearcollect, Sort and Distinct function on dropdown

(0) Share

Report

Posted on by Hii_iii

691

Hello,
I grabbed a friend's Power Apps project to help him work on it, but I don't understand a formula he put on the "OnSelect" property of his dropdown.

Could you please explain this formula to me? Thank you in advance!

ClearCollect(
 colCategorie;
 {Result: ""};
 Sort(
 Distinct(
 Categorie;
 Categorie
 );
 Result
))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @s44 ,

Looking at this formula it is probably used to populate a dropdown or combobox to select a category as part of some filter statement. I added comments that will hopefully clarify:

// This formula creates a collection (colCategorie) with a single column called Result ClearCollect( colCategorie; //This adds an empty item at the beginning of the collection {Result: ""}; //Further items are added extracting the unigue values from the Categorie data source, in the Categorie column and those are then sorted alphabetically, ascending. Sort( Distinct( Categorie; Categorie ); Result ))

Was this reply helpful? Yes No
Hii_iii 691 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much ! It's much clearer thanks to you!

Was this reply helpful? Yes No