web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sort Combo box/drop do...

Power Apps

Answered

Sort Combo box/drop down options in alphabetical order

(0) Share

Report

Report

Posted on by jamest1994

105

Hi

I have two filter boxes (one combo box and one drop down). Both columns are working correctly but the results are appearing in random order.

Any tips to arrange these alphabetically? I have tried using the 'Sort,...,ascending' function in various ways to no success so far. Thanks.

Group combo box - Items = Distinct(Documents, Group)

Brand drop down - Items =

Distinct(
Filter(
Documents,
If ('Group filter'.Selected.Result = "All", true, Group= 'Group filter'.Selected.Result)
),
Brand
)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

timl 36,749 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@jamestcbs

Applying the Sort function on 'Result' should work..

Sort(Distinct(Documents, Group), Result, Ascending )

Sort( Distinct( Filter( Documents, If ('Group filter'.Selected.Result = "All", true, Group= 'Group filter'.Selected.Result) ), Brand ), Result, Ascending )

Was this reply helpful? Yes No
jamest1994 105 on at

Like (0)

Report
Copy link

Link copied!

@timl that has done the trick! Thanks a lot for the help

Was this reply helpful? Yes No
Krishna09 234 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I tried Sort and sortbycolumn. but the combo box is not filtering based on alphabetical order.

Sort(SortByColumns(FirstN(Choices([@Analyst_CG_PMD_team]),49),"Value"),SortOrder.Ascending)

Can anyone help me to solve this.

Was this reply helpful? Yes No
Simmsociate_1 4 on at

Like (0)

Report
Copy link

Link copied!

For anyone reading this in 2024, I believe the function has changed and instead of Result, SortOrder.Ascending or .Descending has to be called.

Was this reply helpful? Yes No

Join the conversation