How can I sort this combo box alphabetically?

Like (0) Share

Report

Posted on 2 Mar 2023 09:22:15 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:

Using Apps Using Formulas

All responses (2)

Answers (1)

Verified answer

AlexJD 28 on 02 Mar 2023 at 10:22:28

Like (0)

Report
Re: How can I sort this combo box alphabetically?

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

SortByColumns( Distinct( Office365Users.SearchUser({searchTerm: ""}).Department, Department ), "Result" )
timl 35,109 Super User 2025 Season 1 on 02 Mar 2023 at 09:36:21

Like (0)

Report
Re: How can I sort this combo box alphabetically?

Hi @AlexJD

This will sort the results:

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