cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jnovoa36
Frequent Visitor

Sorting and Slicing using Get Items

Hello, 

 

I am trying to build a flow that will use the Get items block to sort the columns in a SharePoint list by descending order and then give me the top 5 results for each column. 

 

I don't think the 'Order By' section will do me any good because I need the Title and each individual column to be sorted in descending order and then only return the top 5 results from each column. 

 

Is there a way to do this just using the Get items block? Would I need to build a customer array? 

 

I would appreciate any insight!

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @jnovoa36 

 

Your options are multiple Get Items specifying each column name and title under the Order By filter. If you want to use one Get Items and use the array values to sort each column then have a look at this blog by Paul.

 

Sort an Array of Objects with Power Automate (tachytelic.net)



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

1 REPLY 1
abm
Super User
Super User

Hi @jnovoa36 

 

Your options are multiple Get Items specifying each column name and title under the Order By filter. If you want to use one Get Items and use the array values to sort each column then have a look at this blog by Paul.

 

Sort an Array of Objects with Power Automate (tachytelic.net)



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
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,847)