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.
11manish 534
WarrenBelz 416 Most Valuable Professional
Valantis 306