Answered

How do i sort text numerically here?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

Even though i have text there- i would want to sort the values numerically- so that 6.2.10 comes after 6.2.9- please help

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Sid_Jafri 478 on at

Like
a
(0)

Report
Copy link

Link copied!

Create a column on items and sort it
Sort(AddColumns('BRD Process Levels', "SortValue",Value(Substitute(Left(LevelColumn,6),".",""))), SortValue, Ascending)

Use the Level column in your dropdown or Gallery

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Have you thought of using 6.2.09?

Otherwise the solution is complex - taking out the . may solve it depending on your structure (629 is before 6210, but is 721 is also before 6210).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Didn't even think about that- smart suggestion Warren.
However, i just checked and since it is process related- i have been told not to introduce 0's.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Anonymous

You just need to separate out the versions levels...

Please consider changing your Formula to the following:

With({_data: Distinct( Filter('BRD Process Levels', Level_x0020_2_x0020_Process in DataCardValue11.Selected.Result ), Level_x0020_2_x0020_Process ) }, SortByColumns( ForAll(_data, With({_itm: Split(Left(Result, Find(" ", Result)-1), ".")}, { Major: Coalesce(Value(First(_itm).Result), 0), Minor: If(CountRows(_itm)>1, Coalesce(Value(Last(FirstN(_itm, 2)).Result), 0), 0), Version: If(CountRows(_itm)>2, Coalesce(Value(Last(FirstN(_itm, 3)).Result), 0), 0), Level_x0020_2_x0020_Process: Result } ) ), "Major", Ascending, "Minor", Ascending, "Version", Ascending ) ). Level_x0020_2_x0020_Process

This will pull the level version number (ending with a space) out and parse it into the Major, Minor and version numbers. Then it sorts with all three of them.

Your Dropdown values will now all be sorted by the major, minor and version regardless of inclusion or lack of any level.

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

I thought I would have a play with some code gymnastics to show you what is required here. The Tag.Text refers to a Text control I was testing with your number sequence. This will get your three numbers, which you can sort by in order

UpdateContext( { dot1: Find( ".", Tag.Text ) } ); UpdateContext( { dot2: Find( ".", Right( Tag.Text, Len(Tag.Text) - dot1 ) ) + dot1, no1: Value( Left( Tag.Text, dot1 - 1 ) ) } ); UpdateContext( { no2: Value( Mid( Tag.Text, dot1 + 1, Len(Tag.Text) - dot2 ) ), no3: Value( Right( Tag.Text, Len(Tag.Text) - dot2 ) ) } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I must have missed something in your needs. I though you were trying to sort a dotted list in your dropdown.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Corrected formula:

With({_data: Distinct( Filter('BRD Process Levels', Level_x0020_2_x0020_Process in DataCardValue11.SelectedItems.Result ), Level_x0020_3_x0020_Process ) }, SortByColumns( ForAll(_data, With({_itm: Split(Left(Result, Find(" ", Result)-1), ".")}, { Major: Coalesce(Value(First(_itm).Result), 0), Minor: If(CountRows(_itm)>1, Coalesce(Value(Last(FirstN(_itm, 2)).Result), 0), 0), Version: If(CountRows(_itm)>2, Coalesce(Value(Last(FirstN(_itm, 3)).Result), 0), 0), Level_x0020_3_x0020_Process: Result } ) ), "Major", Ascending, "Minor", Ascending, "Version", Ascending ) ).Level_x0020_3_x0020_Process

And for your Level 4:

With({_data: Distinct( Filter('BRD Process Levels', Level_x0020_3_x0020_Process in DataCardValue12.SelectedItems.Level_x0020_3_x0020_Process ), Level_x0020_4_x0020_Process ) }, SortByColumns( ForAll(_data, With({_itm: Split(Left(Result, Find(" ", Result)-1), ".")}, { Major: Coalesce(Value(First(_itm).Result), 0), Minor: If(CountRows(_itm)>1, Coalesce(Value(Last(FirstN(_itm, 2)).Result), 0), 0), Version: If(CountRows(_itm)>2, Coalesce(Value(Last(FirstN(_itm, 3)).Result), 0), 0), SubVersion: If(CountRows(_itm)>3, Coalesce(Value(Last(FirstN(_itm, 4)).Result), 0), 0), Level_x0020_4_x0020_Process: Result } ) ), "Major", Ascending, "Minor", Ascending, "Version", Ascending, "SubVersion", Ascending ) ).Level_x0020_4_x0020_Process

Was this reply helpful? Yes No