Answered

Sort Distinct Filter Not Working

(0) Share

Report

Posted on by Batrisyia_

I have trouble to arrange number in order. Here is the code

Sort(
Distinct(
Filter(
Mastercopy_1,
SYSTEM = Dropdown1.Selected.Result,
'Sub System'= Dropdown4.Selected.Result,
'EQUIPMENT TYPE'= Dropdown5.Selected.Result,
COMPONENT= Dropdown6.Selected.Result
),
'OPERATING TEMP (°C)'
),
Result,Ascending
)

and this is the result

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

CarlosFigueira Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
The sorting is being done alphabetically - so it seems like the column 'OPERATING TEMP (°C)' is a text column.

To sort it numerically, you can sort based on its numeric value, using the Value function to convert the Result field (from the Distinct function) into a number:

Sort( Distinct( Filter( Mastercopy_1, SYSTEM = Dropdown1.Selected.Result, 'Sub System' = Dropdown4.Selected.Result, 'EQUIPMENT TYPE' = Dropdown5.Selected.Result, COMPONENT = Dropdown6.Selected.Result ), 'OPERATING TEMP (°C)' ), Value(Result), Ascending )

Hope this helps!

Was this reply helpful? Yes No
Batrisyia_ 29 on at

Like (0)

Report
Copy link

Link copied!

Yes it's working! Thank you very much!

Was this reply helpful? Yes No