Append to string variable + Sharepoint Get Items = Alphabetical order?

[vbvbvb]

Hello all,

Looking for a sanity check. While using Get Items to return specific list of items, I am using ODATA query and also Order By filter.

In the Order By, there's a value to order Get Items in ascending order using SPO list column called  Assigned containing names :

And in Append to string variable action value, there's small HTML code building a simple table with values Get Items return, so final result is just a table with few rows.

As the result, when I run this flow, in the output result I can see that Append to string variable action makes all results indeed sorted in Ascending, alphabetical order using Assigned column name, so when I scroll the Apply to all results, names go A,B,C ..etc.

But when I actually use that variable to insert table that it builds in the email action which is sent in the end of the flow, rows are scrambled in random order. Is there any way to control that?

I want it  to retain this structure:

000331  - Product  1 - N/A - Assigned to: Adam 

000231  - Product  1 - N/A - Assigned to: Adam 

000411  - Product  2 - N/A - Assigned to: Brian

000654  - Product  1 - N/A - Assigned to: Colin

Instead I see random table like:

000411  - Product  2 - N/A - Assigned to: Brian

000331  - Product  1 - N/A - Assigned to: Adam 

000654  - Product  1 - N/A - Assigned to: Colin

000231  - Product  1 - N/A - Assigned to: Adam 

Any way around it?

[Pstork1 · Accepted solution]

Check the settings for your Apply to Each and make sure that concurrency is not enabled.  Otherwise the items should be added in the order that they are processed.  The other possibility is that something is happening based on the html you are building.

[vbvbvb]

Thanks @Pstork1 , I am using Concurency to process results via Get Items faster, but I didn't knew it has such effect. Switching it off thou doesn't make any change - each new run has random results. As of HTML - it's super simple:

<tr><td style="min-width: 550px"> <strong> ... various items from Get Items - @{items('Apply_to_each') .... </td> </tr>

Not sure what else to check.

[vbvbvb]

@Pstork1  please disregard earlier reply, it worked after removing Pagnation control on Get items 🙂