What is your goal?PARTS REQUEST EMAIL.blueprint (2).json (23.9 KB)
I have finally managed to group my job # into one email - but I don’t have access to the email associated with the JOB#. What am I doing wrong.
What is the problem & what have you tried?tried array, iterator, parser
Screenshots (scenario flow, module settings, errors)Hi, this isn’t really an Outlook issue. It’s just how Make handles grouped data.
You’ve already done the hard part: grouping multiple Airtable records into one email per JOB #. Once you use a Text Aggregator with groupBy = JOB #, Make stops working with individual rows and starts working with groups.
At that point, fields like EMAIL SUPPLIER are no longer a single value. From Make’s perspective there may be several emails inside that JOB #, so it doesn’t know which one to use and it returns none. That’s why the subject and body work (they come from the aggregator), but the recipient doesn’t.
Arrays, iterators, and Set Variables won’t fix this, because they don’t change the grouped context. Anything you want to use after grouping must also come from the grouped output.
If each JOB # has only one supplier, just aggregate the supplier email as well and use that value. If a JOB # can have multiple suppliers, then the logic should be one email per supplier (group by JOB # + EMAIL SUPPLIER).
Nothing is broken. You just need to make the email address part of the grouping logic.
Hope this helps.
Regards, Tony
