topic Re: Sorting / ordering a list input to a repeat for each action in Workato Pros Discussion Board

Sorting / ordering a list input to a repeat for each action

DanM — Wed, 09 Apr 2025 19:30:22 GMT

Hi there,

I have a recipe that creates sales orders (header and lines) in Dynamics 365 F&O (ERP).

I use a repeat for each action to create the sales order lines. The step input list is a list of the relevant line item data which includes a sequence number field.

I cannot guarantee the input list is sorted / ordered by the sequence number, but, I do want to create the D365 sales order lines in sequence number order.

What's the recommended way to sort / order the input list so that I can control the order that the repeat for each action iterates through the list?

I'm sure I'm missing something obvious, but I've not been able to find an answer in the documentation or these boards.

Thanks in advance.

Re: Sorting / ordering a list input to a repeat for each action

gary1 — Wed, 09 Apr 2025 21:52:23 GMT

I don't know of a native way to do this without using loops and a billion tasks.

I would use a Ruby or JS action to sort the array. Ruby sorting is pretty straightforward:

array.sort_by{ | a | a["sequence_number"] }

Re: Sorting / ordering a list input to a repeat for each action

DanM — Wed, 09 Apr 2025 22:01:42 GMT

Thanks Gary, I’ll give that a go.

Re: Sorting / ordering a list input to a repeat for each action

DanM — Thu, 10 Apr 2025 11:49:07 GMT

That worked a treat! Thanks again Gary.