I am attempting to create Purchase orders on Xero from an excel table.
I have got to the point where separate purchase orders are created for each item on my table, (E.g Item 1 PO-0001, Item 2 PO-0002) whereas all the items should belong on the same Purchase Order.
Can anybody help me achieve this !!!
This is how i have my scenario set-up.
Welcome to the Make community!
Your “Retrieve Data” trigger module is already outputting multiple bundles.
You should not need an Iterator module there since the result is NOT an array.
Iterators are only used for arrays.
Every result (item/record) from a search module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.
Set the Source module of your iterator to your Trigger module.
For more information, see
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
parseDate | Tokens for formatDatesamliew – request private consultation
Join the Make Fans Discord server to chat with other makers!