Sort and Filter Choice Column

(0) Share

Report

Posted on by Caleb62881177

779

Hello everyone,

I have a Dataverse choice column values from 1000 to 12000, I was trying to remove the blank choices I get from my combobox on PowerApps and sort the values from 1000 to 12000.

I am using this formula below.

Sort(
    Filter(
        Choices([@'Table'].numberic_value),
        !IsBlank(Value)
),
    Value,
    SortOrder.Ascending
)
 
I hope anyone can help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey

can u try this modification;

Sort( Filter( Choices([@'Table'].numeric_value), !IsBlank(Value(Value)) ), Value(Value), SortOrder.Ascending )

if it helped please mark as verified answer

Was this reply helpful? Yes No
Caleb62881177 779 on at

Like (0)

Report

@mmbr1606 - I am getting an error "Value" is an unknown and unsupported function

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
sorry my bad

can u try this:

Sort( Filter( Choices([@'Table'].numeric_value), !IsBlank(numeric_value.Value) ), numeric_value.Value, SortOrder.Ascending )

Was this reply helpful? Yes No