cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sammybridge
Helper IV
Helper IV

Sorting Option Set

Hello,

 

I have an option set (single select choice field) which I only have integers in and I am trying to sort these ascending. The option set is for Case Size and since going live an addition needs to be added in but I want my dropdown to show the right ordering. I have tried every type of sorting possible and I can't work out why it isn't working:

 

This is my standard unsorted code: Choices('Case Size Option Set')

 

These are the variations I have tried without success:

 

  • Sort(Choices('Case Size Option Set'), Ascending)
  • Sort(Choices('Case Size Option Set'),"Value", Ascending)
  • SortByColumns(Choices('Case Size Option Set'), Ascending)
  • SortByColumns(Choices('Case Size Option Set'),"Value", Ascending)

 

Can anyone help with this?

 

Thanks

11 REPLIES 11

@landscapingfool @LauraMay 

 

I made a slight tweak to the code in my edit above. You may have figured it out already but it will sort it properly if you have an integer. 

my example I had like 1, 2, 3...12, 13 so when I used the first method it sorted it like 1, 12, 13, 2, 3. When I put the Value before the text that fixed it. 

The value(text(value)) thing I never would have thought of. Creativity amongst the cursing. Dude, you know how to dig in!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,033)