web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Sort Distinct Filter N...

Power Apps

Answered

Sort Distinct Filter Not Working

(0) Share

Report

Report

Posted on by Batrisyia_

29

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 Img

All responses (2)

Answers Img

Answers (1)

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

Join the conversation