I have two excel sheets, one is vender contact list (one vender one row) and the other is vender product list (one vender to multiple rows) and I want to use the two sheets to create email draft, one email per vender. Here is my current flow, it works but for 2nd list worksheet rows modules (vender product list), it will run multiple times since the 1st list worksheet row module output has multiple bundles. In order to optimize the flow, I want the vender product list only load once. So I tried to use array aggregator and iterator but the final two module only run 1 time instead of 3 times. Please advise how to use them correctly. Thank you.
Current flow (not efficient)
New flow but the last two module only run once but should be 3 times
Hello,
You should start by mapping your process and it will help you a lot to understand the steps that need to be taken in Make to achieve it.
I can only assume I’m right based on your short description but:
- Sheet 1 - vendor contact list - it triggers the flow
- Sheet 2 - vendor products - one vendor should get a list of all products.
- The list should be sent to the correct vendor once.
So how to achieve it:
- The vendor (sheet 1) should return one bundle per vendor
- Based on this bundle, you must list all products from sheet 2 - it will probably return several bundles of rows with vendor products. Consider using search module or proper filtering to work only on data assigned to correct vendor.
- You must aggregate the returned products into a complete list - probably using a text aggregator or a combination of modules depending on the formatting you want to achieve.
- Then you must concatenate all data from the previous steps in the email step.
- The process will loop as many times as the number of bundles returned by the 1st module.
Hope this helps you find a working solution.
You can take a look at Alex’s post about bundles - A learning lesson on how variables, bundles, arrays and aggregators work
