Internal error returned when trying to sort an array of objects

(0) Share

Report

Posted on by Jivin

I get an internal error when I try and sort an array of objects. Any ideas are welcome?

Categories:

General topics

All responses (5)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jivin ,

You missed the second parameter.

Best Regards,

Wearsky
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jivin,

The Array would have the items in the body. And since you have two properties I would suggest to specify on which field you want to sort.

Can you try this instead?

sort(body('Array'), 'last')
Jivin 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Worth a shot but the array doesn't have body:
I tried your suggestion anyway:

But your and @v-xiaochen-msft's suggestion of specifying the field to sort on does the trick.

My reading of the doco is that the second parameter in the sort function is optional. Maybe not when sorting an array of objects?

Thanks for your ideas.

Jivin
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jivin,

Out of interest, what kind of array did you use that you don't have a body? Is it just a Compose action?
Jivin 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Expiscornovus

Correct, I just used a Compose action.

I've now applied what I learnt to my real problem and got that working.

A couple of other sort related things:

I also discovered that the sort function doesn't like nested objects so I had to use a Select action before calling sort to make sure my data was better organised.

When using sort you also have to be careful that none of the values you are sorting on are null.