Sorting or addcolumn by a Text and Numbers column in a collection

[ShaneITAutomate]

Hi,

I have a collection (colTEST) i made from a sharepoint List (TESTLIST) in where the naming convention of a column (TESTID) is is AB1 to AB900

I believe (is there a better way) that the best way would be to remove the AB or add a column so i can sort by it. however the code im using just doesnt work,

could someone help as this code doesnt work

ClearCollect(colTEST, AddColumns(TESTLIST,
"SORTID",
Mid(colTEST.TESTID, 3, 10)
)

any suggestions would be appreciated

[Drrickryp]

Hi @ShaneITAutomate 

ClearCollect(
              colTest, Sort(
                             AddColumns(TESTLIST, "sortid", 1*Mid(
                                                                   TESTID,3
                                                               ),
                             ), sortid
                         )
)

[eka24 · Accepted solution]

Hi @ShaneITAutomate 
Consider this:

ClearCollect(colTest,Sort(AddColumns(Table1, "sortid",Substitute(TESTID,"AB","")*1),sortid,Descending))

Or
ClearCollect(colTest,Sort(AddColumns(Table1, "sortid",Substitute(TESTID,"AB","")*1),sortid))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.