Sort Array by Number (Including Minus numbers)

(1) Share

Report

Posted on by HD-04081521-0

All,

Simple one this i think. I have an array with one column that contains numbers that are both positive and negative

I have tried the Sort function and the Float function combined, but it wont sort it in order.

The column in question is called "Days left to next assessment"

A screenshot of some of the array is below

(This array will then go into a HTML table and then into an email)

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi

Use the sort() expression

sort(outputs('Compose'),'Days left to next assessment')

Above replace the outputs('Compose') with your array of values.

This will sort the array in ascending order.

Thanks

Was this reply helpful? Yes No
HD-04081521-0 12 on at

Like (2)

Report

Hi Abm abm,

That doesnt quite work. (The array I have is a larger then the screenshot above )

It sorts the minus numbers in a strange order of the first number, then the second number i.e -109,-159,-17,-199,-21,-220 etc

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi

How big is your array of data?

Thanks

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (2)

Report
Hi HD-04081521-0,

The 'Days left to next assessment' property is a text string and not a number, hence it will be sorted lexicographically (i.e. it will sorted in dictionary sort order).

Perhaps you can convert 'Days left to next assessment' to an integer value and then sort?

Here is something you could try:

setProperty(item(),'Days left to next assessment', int(item()?['Days left to next assessment'])) sort(body('Select'),'Days left to next assessment')

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
HD-04081521-0 12 on at

Like (1)

Report

Hi Ellis,

I tried what you did, but I got the follow JSON error message when I tried to compose that in a Select (Screenshot below)

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

In the Select action, just exclude the { } from the Map:

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
HD-04081521-0 12 on at

Like (1)

Report

Thanks so much for that Ellis the above. The 'setProperty' function has worked and no all my minus and positive numbers are sorted in order.

Why Microsoft dont let you set in in another function is just silly, but hey ho it works :)

Was this reply helpful? Yes No