Unanswered

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,383 Super User 2025 Season 2 on at

Like (0)

Report
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
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