Sytnax for Odata Order By

Like (2) Share

Report

Posted on 7 Sep 2017 19:40:21 by WiggityZwiggity

356

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.

All responses (3)

Answers (1)

nadiaardilesc99 2 on 26 May 2022 at 20:41:34

Like (0)

Report

Re: Sytnax for Odata Order By

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
WiggityZwiggity 356 on 08 Sep 2017 at 12:14:05

Like (0)

Report

Re: Sytnax for Odata Order By

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.
Verified answer

v-micsh-msft on 08 Sep 2017 at 06:41:59

Like (16)

Report
Re: Sytnax for Odata Order By

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