I'm getting the following error:
{
"status": 400,
"message": "Only ordering by properties is supported for non-primitive collections. Expressions are not supported.\r\n inner exception: Only ordering by properties is supported for non-primitive collections. Expressions are not supported.\r\nclientRequestId: b5048be5-e35e-4590-a9b5-df8ed72ff603",
"source": "excelonline-cus.azconn-cus.p.azurewebsites.net"
}
I'm just doing a "list rows present in a table" for an Excel workbook. The column name I want to sort by is "Sponsor Email", and the odata orderby string I'm using is:
'Sponsor_x0020_Email'
I've tried a lot of the variations and this seems closest to what I'd expect for success.
here's the peek code if that's helpful:
{
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['shared_excelonlinebusiness']['connectionId']"
}
},
"method": "get",
"path": "/drives/@{encodeURIComponent('b!Ves-tvHWpUCzHesTpIS-AlYQPfr4ak9Hlo4jCeGAaws1FwFGITYJTJswnAvj4eXd')}/files/@{encodeURIComponent('01NSUF7IDNI7SE2RU2NRBYL3YLNFWHIV2D')}/tables/@{encodeURIComponent('{0EC9BB84-03D4-4C31-A654-7DA611CF310E}')}/items",
"queries": {
"source": "sites/??????.sharepoint.com,b63eeb55-d6f1-40a5-b31d-eb13a484be02,fa3d1056-6af8-474f-968e-2309e1806b0b",
"$orderby": "'Sponsor_x0020_Email'"
},
"authentication": "@parameters('$authentication')"
},
"metadata": {
"01NSUF7IDNI7SE2RU2NRBYL3YLNFWHIV2D": "/Risk Management/Risk Management Inventory.xlsx",
"flowSystemMetadata": {
"swaggerOperationId": "GetItems"
}
}
}
