Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, 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 can apply to many use-cases like building of JSON, CSV, HTML.
There are other types of aggregator modules, click the below links to find out more:
Array Aggregator – mapping multiple bundles into a complex field
The Array Aggregator module is very powerful because it allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.
This is done using the “Target structure type” of an Array Aggregator module.
As you can see, the “Map” toggle on complex fields are used when you have an array. You can easily build an array variable to map to a future module’s field, by using an Array Aggregator module and select the “Target Structure Type” as the future module’s field you have mapped the array into.
Hope this helps! Let me know if there are any further questions or issues.
This has been very helpful for me. I now have a better understanding of how the Array Integrator works.
However, I have encountered a new issue with the Microsoft 365 Calendar module. I can’t access some of the data that I’ve included in the “Group by” field, and I need this data to correctly set the time and date in the calendar invites. In the Google Sheet where I’m pulling the information from, there are sessions at different times and dates.
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
I believe I have followed your instructions, but I am still facing the same issue. In the Microsoft 365 Calendar module, I can only input the information that I have added in “Email Address” and “Name”. I need to be able to pull the data for dates, times, groups, and sessions (fecha, inicio, fin, grupo, nombre sesión in Spanish as you can see in the screenshot) from my Google Sheet.
In that case, you will need to build the array of attendees separately from the trigger module.
To do this you need another set of Iterator-Aggregator modules (advanced), or simply put other non-attendee data in another spreadsheet and use another Google Sheets module to fetch the information.
Hope this helps! Let me know if there are any further questions or issues.
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
I tried what you suggested with using the Iterator-Aggregator, but I’m not sure where it should go if it’s separate from the trigger module. In this flow of modules, where should it be placed?
Once again, I’m not sure if I fully understand your instructions. What I think I do understand is that all the data that comes after the Array Aggregator doesn’t appear unless it’s inside the Array Aggregator.
I must be one of the most useless people you’ve encountered in Make , but even after setting up the module flow as you suggested, I’m still having issues.
I’ve configured the new Google Sheet - Get Range Values module as you can see in the attached image. I don’t have access to the data from the Google Sheets - Watch New Rows module, nor from the Google Sheet that I configured this module with.
The only thing I can think of that I might be doing wrong is that this new Google Sheet - Get Range Values module needs to be linked to another new Google Sheet with the data for the different events.
I’m attaching a screenshot of the Google Sheet in case it provides more clues.
As you can see in the Google Sheet, there are several sessions at different times and on different days, depending on which group you belong to. If I use a different Google Sheet with the dates and times, I’m not sure how it will link to the corresponding dates and times for each session.
, but even after setting up the module flow as you suggested, I’m still having issues.
