Odata order by not accepting multiple items

[michaelfstanley]

OK so running the 'Get list of rows present in a table' action works for me with a filter and a single field in the 'Order By' field

But when I try to sort by more than one field it fails

I've tried different fields singly and in combination - I can sort by any field I like by itself.

According to other answers here, separating by a comma should do the trick, I've fussed over and over but can't crack why this isn't working.

Can anyone offer any insight?

Thanks

Michael

[abm]

Hi @michaelfstanley 

Is your filter query correct?

[abm · Accepted solution]

Hi @michaelfstanley 

I have tested this and I got the below error.

Invalid orderBy clause: only single expression is supported.

I'm afraid that the function to order by multiple columns in excel table is not supported in Microsoft flow currently.

Thanks

[michaelfstanley]

Yes it works when I use a single sort criteria

[michaelfstanley]

Strange - is this just for this action or all of flow?

[abm]

Hi @michaelfstanley 

I doubt it. Different connectors such as Dataverse, SharePoint, Excel all have different implementations.