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.
So close but didn't work. Switch out "Sort" for "SortByColumns" and it worked:
SortByColumns(
Distinct(
Office365Users.SearchUser({searchTerm: ""}).Department,
Department
),
"Result"
)
Hi @AlexJD
This will sort the results:
Sort(
Distinct(
Office365Users.SearchUser({searchTerm: ""}).CompanyName,
CompanyName
),
Result
)
MS.Ragavendar
32
Rajkumar_M
16
Super User 2025 Season 1
mmbr1606
16
Super User 2025 Season 1