How to sort the items in an Airtable to Word Document "Fill a Document with a Batch of Data"

Hi,

I’ve managed to set up an automation that takes a webhook from a button clicked in Airtable and creates a word document with line items for a Purchase Order, using the “Fill a Document with a Batch of Data” module. Everything is working in terms of mapping the items and the fields, however I’m wondering if anyone knows of a simple way to properly sort the items that are in my array. In fact I’m using Webhook - Airtable Get Record (to get the Purchase Order) - Airtable Search Records (Using formula to only get line items that are on that Purchase Order) - Word Fill a Document with a Batch of Data

I have a field I can sort by, but don’t know how I’d simply set this up and still keep the Search Records module “attached” to the Microsoft Word Templates module, which seems to be necessary for the Word module to function.

Thanks in advance for any ideas…

Craig

Welcome to the Make community!

To be able to sort an array, you usually have to aggregate to an array first using an Array Aggregator.

Currently you are directly aggregating to the Word Template, so you can’t sort it.

Hope this helps! Let me know if there are any further questions or issues.

@samliew