web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sorting Numbers and la...
Power Apps
Answered

Sorting Numbers and latters

(0) ShareShare
ReportReport
Posted on by 367

Hi 

I am trying to sort a choice columns but I am not getting exact result . my choices are as below 

1.A

2.An

3.As

4.At

10.Ah

11.An

What I want show like above . but I am getting like be low 

1.A

10.Ah

11.An

2.An

I don't want like this . 

 

My item property is 

Choices(@[TestList].Mtest)

 

Please help me. 

Categories:
I have the same question (0)
  • Verified answer
    timl Profile Picture
    36,682 Super User 2026 Season 1 on at

    Hi @Yoursnani 

    The following should hopefully work for you.

    SortByColumns(
     AddColumns(Choices(@[TestList].Mtest),
     "Num", 
     Value(Match(Value, MultipleDigits).FullMatch)
     ),
     "Num", Ascending
    )
    


    There are more details on this technqiue here:
    http://powerappsguide.com/blog/post/sort-by-partial-numbers-in-a-text-field

     

  • Yoursnani Profile Picture
    367 on at

    @timl 

    Thank you for this . it's works exactly 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard