Answered

Combobox - Sort picked items alphabetically

(0) Share

Report

Posted on by Newbeetle1

Hi I have a combobox and i need the chosen items to be displayed in the combobox display at the top in alphabetically order, i.e.

Say I have a combobox with dropdown list as follows,

["Y", "B", "A", "R", "G"]

The Combobox is set to accept muliple selections so if someone sleects "G", "B", "Y" the combo box will display "G B Y" but I want it to sort these so thye would display as "B G Y"

The reason for this is I have a button that when pressed it compares the selected combobox items and then naviagtes to another screen if the selected ietms match, the problem though is the items display in the order they are selected so this gives many variations, hence why I want them to sort.

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Newbeetle1 Before you do u'r comparison, do a sort...
Sort(ComboBox1.SelectedItems, Value))

Was this reply helpful? Yes No
Newbeetle1 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi CNT
I set a combobox called Answer2 and selected G Y B from the list.

I have added a button and the command
Sort(Answer2.SelectedItems, Value)
When I press the button the selected items stay as G Y B and do not re-order.

Any ideas?

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Newbeetle1 we cannot use sort in any of the ComboBox properties as this will create a circular reference error. Collect the Sorted results into a collection in the OnSelect() of the Button.
ClearCollect(myCollection, Sort(Answer2.SelectedItems, Value))
Use this collection to do u'r comparisons instead of using the SelectedItems from the ComboBox.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Newbeetle1

You seem to be referring to sorting the items in the combobox selection list itself. If this is the case, you cannot sort them in that list. They will appear in the order selected.

However, you can sort the items anywhere else in your app that come from those selections and if you are storing them and setting the DefaultSelectedItems property later to show them again, they will/can be sorted.

Just that you cannot have the immediate selections sorted.

Was this reply helpful? Yes No
Newbeetle1 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi CNT,

Many thanks, as you can probably tell I'm fairly new to this, I will read up on myCollection and then follow your lead.

Was this reply helpful? Yes No
Newbeetle1 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy,
Many thanks, I shall do some more reading around this and give this another go.

Was this reply helpful? Yes No
Newbeetle1 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi CNT,

I persevered and glad to say I got there, I created the collection using sort as suggested, many thanks.

Was this reply helpful? Yes No
Newbeetle1 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy,

Many thanks I used a label to pull through the combobox collection into a string and that worked as required.

Was this reply helpful? Yes No