Announcements
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
I don't want like this .
My item property is
Choices(@[TestList].Mtest)
Please help me.
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
@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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 103
WarrenBelz 82 Most Valuable Professional
wolenberg_ 67 Super User 2026 Season 1