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
Solved! Go to 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.
ClearCollect(
colTest, Sort(
AddColumns(TESTLIST, "sortid", 1*Mid(
TESTID,3
),
), sortid
)
)
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
195 | |
45 | |
45 | |
42 | |
36 |
User | Count |
---|---|
270 | |
81 | |
81 | |
75 | |
69 |