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
Solved! Go to Solution.
Hi @Anonymous
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Anonymous
Is your filter query correct?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Anonymous
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogYes it works when I use a single sort criteria
Strange - is this just for this action or all of flow?
Hi @Anonymous
I doubt it. Different connectors such as Dataverse, SharePoint, Excel all have different implementations.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogUser | Count |
---|---|
101 | |
36 | |
29 | |
25 | |
16 |
User | Count |
---|---|
133 | |
54 | |
53 | |
37 | |
26 |