Sorting Linked Records after "Find Records" automation step jumbles them 🤪

[InfoWrangler]

Hi folks,

I've been trying to solve this puzzle all day; there are quite a few scripting examples in the community here that I've tried to adapt to my use, to no avail.

Here's the situation:

These two columns should be ordered exactly the same, except that the one on the right gets jumbled up during a "find records" step in an automation that populates this field.

They're ordered this way in the line items table, but for some reason the "find records" step jumbles them up:

I need a script or formula that will re-order the line items in ascending order according to the purple-circled numbers in the line item IDs. 

I have used Batch Update to do the job, but I'm looking for an automated solution that will sort the line items for use in a Zap that creates an invoice - and the line items need to be in a particular order.

Thanks for your help in advance,

Shawn : )

[Leslie_Burke]

@InfoWrangler Would you be able to add a screenshot of your entire automation so I could see how you are using this script within the automation? Also, thanks for posting the script - super helpful! 😁