Answered

Sytnax for Odata Order By

(2) Share

Report

Posted on by WiggityZwiggity

358

Is it possible to use multiple fields in the order by odata filter on a SharePoint get items action? i.e. if I want to sort by Title Field, then Date Field as an example:

Title asc and Date asc

What is the correct way to structure that - it appears to be differen than the filter query sytax.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-micsh-msft Microsoft Employee on at

Like (16)

Report
Copy link

Link copied!
Hi @WiggityZwiggity,

The workable Sytnax for the order by should be:

Title asc, Date asc

Image reference:

The Sytnax usage is described here:

Use OData query operations in SharePoint REST requests

For orderby:

"

Use the $orderby query option to specify how to sort the items in your query return set. To sort by multiple fields, specify a comma-separated list of fields. You can also specify whether to sort the items in ascending or descending order by appending the asc or desc keyword to your query.

"

Regards,

Michael

1 people found this reply helpful.

Was this reply helpful? Yes No
WiggityZwiggity 358 on at

Like (0)

Report
Copy link

Link copied!

That's awesome. Is there a way to also apply this sorting on Unions? i.e. if I am joining 2 arrays, and I want the combined results to sort? the union(array1,array2) expression doesn't seem to allow for this.

Was this reply helpful? Yes No
nadiaardilesc99 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for your solution. I was wondering if i want to order number, power automate says this" !CKIxd!Syntax error at position 22 in 'Fecha Final_Modificada desc'. Ploc !
inner exception: !CKIxd!Syntax error at position 22 in 'Fecha Final_Modificada desc'. Ploc !
clientRequestId: 44c196fa-13c6-4fef-87f2-0877e196689e

Was this reply helpful? Yes No