Sort HTML table in Power Automate

(1) Share

Report

Posted on by veracruz

Hello,

I want to sort my HTML table by the delay value, from negative to positive value. I use sort expression and already state based on which column. But somehow the result is still in a messy order. Did I write the expression correctly or is there any other way to sort the value? Also, I want the sorting to start from -7 to the positive value.

The expression

sort(outputs('Compose_System_Table'), 'Delay')

The flow

The result

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
I noticed you are using an int function in your filter array action criteria/where statement. Are the values in the Delay column of type string/text? Can you share sample of the Compose System Table outputs?

Your expression syntax seems fine btw. Below is a test with a sample array to demonstrate the same approach in a Select action

IntArray with some sample data underordered (with a Delay column which has integer values)

createArray(json('{ "first": "Amalie", "Delay": -3 }'), json('{ "first": "Elise", "Delay": 3 }'), json('{ "first": "John", "Delay": -7 }'), json('{ "first": "Jane", "Delay": -4 }'))

Expression in the Select action

sort(variables('IntArray'), 'Delay')

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

HI

I believe the issue is you are sorting based on a string column versus an int column. then comparing that to a int() then a number.

Your sort will be incorrect if you are sorting by strings, not actually numbers hence your issue .

Was this reply helpful? Yes No
veracruz 45 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus!

I got it now, thank you.

Was this reply helpful? Yes No
veracruz 45 on at

Like (0)

Report
Copy link

Link copied!

Hi @FLMike,

I got it now, thank you.

Was this reply helpful? Yes No