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 / ORDER BY TWO EXPRESSIONS
Power Automate
Answered

ORDER BY TWO EXPRESSIONS

(0) ShareShare
ReportReport
Posted on by 296

Hello Community,


How can I order with two expressions for an Excel table in Order by.

 

My Flow

fgonzalez515_0-1647784265535.png

 

BUT THE ERROR IS THIS

fgonzalez515_2-1647784440466.png

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    Hi @fgonzalez515,

    Do you want to add two sort orders for an excel table?

     

    Actually, the ExcelOnline connector restricts the use of only one sort order, which differs from the SharePoint connection that allows multi sort orders within Order By tab in the Get items action.

     

    So it is known that the ExcelOnline connector only allows single expression for sort order in List rows present in a table action. I'm afraid that the function to order by multiple columns in excel table is not supported in Microsoft flow currently.

     

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 600

#2
Valantis Profile Picture

Valantis 453

#3
11manish Profile Picture

11manish 356

Last 30 days Overall leaderboard