Sort and Filter Choice Column

(0) Share

Report

Posted on by Caleb62881177

745

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:

Using Apps Using Formulas

All responses (3)

Answers (1)

Verified answer

mmbr1606 12,121 Super User 2025 Season 1 on at

Like (0)

Report
Sort and Filter Choice Column

sorry my bad

can u try this:

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

Like (0)

Report

Sort and Filter Choice Column

@mmbr1606 - I am getting an error "Value" is an unknown and unsupported function
mmbr1606 12,121 Super User 2025 Season 1 on at

Like (0)

Report
Sort and Filter Choice Column

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