Answered

Sorting Dropdown Alphabetically

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have 2x dropdown boxes that the values are pulled from different sharepoint lists. I'm wanting the results of these lists to be sorted alphabetically, please help.

The first dropdown has the below Items code

Distinct(FunctionList,Title)

The second dropdown values are dependant on the first dropdown selection and has the below Items code

Filter(CauseCategoryList,Function.Value = 'Dropdown-SourceFunction'.Selected.Result)

Thanks in advance for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

BCBuizer 22,535 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Dave-ITMan ,

You can use the Sort function for that:

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-sort

For example:

Sort(Distinct(FunctionList,Title),Result)

Was this reply helpful? Yes No
WarrenBelz 153,731 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Dave-ITMan ,

First one

Sort( Distinct( FunctionList, Title ), Result )

You did not say which field was to be sorted in the second one

Sort( Filter( CauseCategoryList, Function.Value = 'Dropdown-SourceFunction'.Selected.Result ), YourSortFieldName )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Dave-ITMan on at

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,

Thank you, the first one has worked, although one of the options is Please select an option, is there a way that I can set that as the default that is displayed and then the rest alphabetically, is that possible?

The second drop down is named Dropdown-CauseCategory so i've entered the below but i'm getting an error saying the function Sort has some invalid arguments, i'm assuming that it's the selected.result at the end that needs changing to something else?
Sort( Filter( CauseCategoryList, Function.Value = 'Dropdown-SourceFunction'.Selected.Result ), 'Dropdown-CauseCategory'.Selected.Result )

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,731 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Dave-ITMan ,

The first one, if this is a Combo Box, set the InputTextPlaceholder to "Select an Option" and IsSearchable to true.

The second one, you need to sort by the field, not the control

Sort( Filter( CauseCategoryList, Function.Value = 'Dropdown-SourceFunction'.Selected.Result ), CauseCategory )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Dave-ITMan on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thank you, that makes sense now, it was named Title for the column so I changed the code to that instead and has worked a treat. The box isn't a combo box though, it's a drop down input so I don't have the InputTextPlaceholder or IsSearchable options, is it able to be done with a drop down box?

Thanks again for the help!

Was this reply helpful? Yes No
WarrenBelz 153,731 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Dave-ITMan ,

Is Searchable only applies to a Combo Box, not a drop-down

Was this reply helpful? Yes No
Dave-ITMan on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Ok so if I changed the dropdowns that I mentioned above to be combo boxes instead of dropdown boxes, What would the code change to please?

Was this reply helpful? Yes No
WarrenBelz 153,731 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Dave-ITMan ,

Items would be the same - you just need to be aware of the DefaultSelectedItems instead of Default as this is a different syntax

{Output: ThisItem.FieldName}

where Output is ComboBoxName.Selected.Output.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No