web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Odata order by not acc...
Power Automate
Answered

Odata order by not accepting multiple items

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Anonymous 

     

    Is your filter query correct?

     

    image.png

  • Verified answer
    abm abm Profile Picture
    32,985 Most Valuable Professional on at

    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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Yes it works when I use a single sort criteria

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

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

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Anonymous 

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard