634
I have a combox box hooked up to a CDS(Dataverse) table. The values are in the following format.
Item-1, Item-2...Item-20
When the comboxbox loads and is sorted Ascending it puts Item-10 right after Item-1. Is the only way to sort these correctly is to put a '0' in front of the single digit numbers? I'd run into issues again when I get to Item-100. That would be place right after Item-10
There ya go...leaving out details!! 🤣🤣
Give this a shot:
Share
Report
All responses (
Answers (
DropColumns(
SortByColumns(
AddColumns(
ShowColumns('Details', "crfeb_detail"),
"num", Value(Match(crfeb_detail, MultipleDigits).FullMatch),
"nm", Match(crfeb_detail, MultipleLetters).FullMatch
),
"nm", Ascending, "num"
),
"num", "nm"
)
Ok. Mostly worked. I just realized I have some other items in there that break this somewhat. For example, to make this simple, I have Item-1...Item20 and Widget-1...Widget20. This code would put Widget-1 right after Item-1 then move onto Item-2 followed by Widget-2. I'd want to keep the Item-N together and the Widget-N together.
Consider the following then:
DropColumns(
SortByColumns(
AddColumns(
ShowColumns('Details', "crfeb_detail"),
"num", Value(Match(crfeb_detail, MultipleDigits).FullMatch)
),
"num"
),
"num"
)
This will use regular expression matching to pull the digits out and then convert to numbers.
It then sorts by the real numbers and finally drops the column we used to sort because we don't need it any more.
What is your Items property formula currently for the combobox?
#1
WarrenBelz
146,670
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
