How do I sort combobox values when numbers are involved?

(0) Share

Report

Posted on by Future_Vision

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

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Future_Vision

What is your Items property formula currently for the combobox?

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report
@RandyHayes
Sort(ShowColumns('Details',"crfeb_detail"),crfeb_detail)

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

Like (0)

Report
@Future_Vision

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.

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report

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.

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

Like (0)

Report
@Future_Vision

There ya go...leaving out details!! 🤣🤣

Give this a shot:

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" )

Was this reply helpful? Yes No