You’re offline. This is a read only version of the page.
Announcements
17
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!
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)
Share
Report
All responses (
Answers (
