Skip to main content

Notifications

Power Automate - Building Flows
Answered

ORDER BY TWO EXPRESSIONS

(0) ShareShare
ReportReport
Posted on by 290

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

 

 

 

  • Verified answer
    Re: ORDER BY TWO EXPRESSIONS

    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard