how to sort a list when uploading to excel

(0) Share

Report

Posted on by CU13081633-2

Hello everyone,

I created a flow button in Power BI reports to take the filtered data and upload it to an excel.

However, I would like for the flow to loop through the data and upload it in order of the setter#

This is the flow

I have the same question (0)

All responses (4)

Answers (0)

BCBuizer 22,492 Super User 2025 Season 2 on at

Like (0)

Report
Re: how to sort a list when uploading to excel

Hi @sophiatheresa74 ,

For this you can use a Sort function (Reference guide for expression functions - Azure Logic Apps | Microsoft Learn) in an expression for the input of the Apply to each loop:

sort( TriggerBody()['entity_Power...'], 'Setter#' )

Please replace entity_Power and Setter# with the identifier with the correct terms.

Was this reply helpful? Yes No
CU13081633-2 on at

Like (0)

Report

Re: how to sort a list when uploading to excel

@BCBuizer I do not know how to implement this in my flow

Was this reply helpful? Yes No
BCBuizer 22,492 Super User 2025 Season 2 on at

Like (0)

Report

Re: how to sort a list when uploading to excel

Hi @sophiatheresa74 ,

Can you please share the trigger outputs from a flow run? With that I will be able to give you an exact expression and show you where to apply it.

Was this reply helpful? Yes No
CU13081633-2 on at

Like (0)

Report

Re: how to sort a list when uploading to excel

{
"EggRecdDt": "240423",
"OffLoadDt1": "240424",
"FlockNo": "412-1",
"FlkAge": "45",
"Setter#": "1"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "412-1",
"FlkAge": "45",
"Setter#": "1"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "412-2",
"FlkAge": "45",
"Setter#": "1"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "412-2",
"FlkAge": "45",
"Setter#": "2"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "412-3",
"FlkAge": "39",
"Setter#": "2"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "412-3",
"FlkAge": "39",
"Setter#": "3"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "412-4",
"FlkAge": "39",
"Setter#": "3"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "408-1",
"FlkAge": "38",
"Setter#": "4"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "412-4",
"FlkAge": "39",
"Setter#": "4"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "408-1",
"FlkAge": "38",
"Setter#": "5"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "408-2",
"FlkAge": "38",
"Setter#": "5"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "405-1",
"FlkAge": "36",
"Setter#": "6"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "408-2",
"FlkAge": "38",
"Setter#": "6"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "405-1",
"FlkAge": "36",
"Setter#": "7"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "405-2",
"FlkAge": "36",
"Setter#": "7"
},
{
"EggRecdDt": "240423",
"OffLoadDt1": "240427",
"FlockNo": "405-2",
"FlkAge": "36",
"Setter#": "8"
}

Was this reply helpful? Yes No