cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michaelfstanley
New Member

Odata order by not accepting multiple items

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

michaelfstanley_1-1631844872589.png

 

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

 

 

michaelfstanley_0-1631844755576.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

5 REPLIES 5
abm
Super User
Super User

Hi @michaelfstanley 

 

Is your filter query correct?

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

Yes it works when I use a single sort criteria

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

Hi @michaelfstanley 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,050)