cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Sorting (ordering) arrays

Hi! I'm building an array dynamically in flow and would like to order (sort) the data in the array. How can I acheive it?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate II
Advocate II

Re: Sorting (ordering) arrays

Hi @PWrobel ,

 

I have the same issue but find two websites for me to solve it, it might help you to achieve your requirement:

http://johnliu.net/blog/2018/12/how-to-implement-sort-with-microsoft-flow-in-3-actions-within-a-loop

 

The answer from "v-bacao-msft"

https://powerusers.microsoft.com/t5/Building-Flows/Create-Update-Sharepoint-List-using-an-Excel-List...

 

Good luck!

ilu989

View solution in original post

5 REPLIES 5
Highlighted

Re: Sorting (ordering) arrays

Hi @PWrobel ,

 

This is the easiest approach, using an azure function:

 

https://veenstra.me.uk/2019/07/13/sort-an-array-or-collection-in-microsoft-flow/

Highlighted
Microsoft
Microsoft

Re: Sorting (ordering) arrays

Thanks Pieter. To bad there is nothing out of the box that does not require access to Azure subscription.

Highlighted
Advocate II
Advocate II

Re: Sorting (ordering) arrays

Hi @PWrobel ,

 

I have the same issue but find two websites for me to solve it, it might help you to achieve your requirement:

http://johnliu.net/blog/2018/12/how-to-implement-sort-with-microsoft-flow-in-3-actions-within-a-loop

 

The answer from "v-bacao-msft"

https://powerusers.microsoft.com/t5/Building-Flows/Create-Update-Sharepoint-List-using-an-Excel-List...

 

Good luck!

ilu989

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Sorting (ordering) arrays

Thanks Ilu

 

I was thinking about building my own sort function in loop, so now I can just copy it 🙂

Highlighted
Helper V
Helper V

Re: Sorting (ordering) arrays

If you need a build-in function, please vote for this idea:

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Sort-Array/idc-p/486807#

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,132)