Aggregate the list and use shuffle to select a random file
Download the file
Send email to my mailing list using the Sheets as the database the contains all the emails
Move the file once all emails are sent (here is my issue)
send myself an email when the scenario is complete
The issue I’m facing is that the email is being sent to the first contact then the file is move from the dropbox folder so it doesn’t sent to the rest of the list.
Is there a way to make sure everything gets sent to my entire list before moving on to the module that moves the file?
You need an array aggregator after your email module. This will wait for all bundles from your search module to run before proceeding with the next module after the aggregator.
Aggregators
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: