Answered

How can I sort this combo box alphabetically?

(0) Share

Report

Posted on by AlexJD

Hi,

I have two combo boxes that allow you to select company or department that link up to a gallery. The combo boxes use this function:

Distinct(
 Office365Users.SearchUser({searchTerm: ""}).CompanyName,
 CompanyName
)

It shows all the companies but not in alphabetical order. They seem to be in the order that they appear in the gallery. Is it possible to change the order to alphabetical?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

timl 36,774 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @AlexJD

This will sort the results:

Sort( Distinct( Office365Users.SearchUser({searchTerm: ""}).CompanyName, CompanyName ), Result )

Was this reply helpful? Yes No
Verified answer

AlexJD 28 on at

Like (0)

Report
Copy link

Link copied!
So close but didn't work. Switch out "Sort" for "SortByColumns" and it worked:

SortByColumns( Distinct( Office365Users.SearchUser({searchTerm: ""}).Department, Department ), "Result" )

Was this reply helpful? Yes No