Send and outlook email to n recipients from a notion's table field

How To
1

I have a question regarding sending emails via outlook where the field that contains the emails’ recepients can vary in number of emails
The image below shows one field in a notion’s table. I tried both using it as a field type email and text, separeted by commas. I tried using set variable, mapping, spliting,…
I usually get both erros: Missing value of required parameter ‘address’, and Missing value of required parameter ‘toRecipients’
And I don’t know if I really should use iterator as I need to use dinamic fields in the emails’ body.
image
Scenario7
Scenario8

Can someone help me?

2

Hi @Wehrmann,

Outlook is expecting an array for this field. The easiest way to do this is to create an array using the split function, iterate using the iterator, then with the aggregator select the target structure of the Outlook “send to” field and map your email field. In your Outlook module then you just put the array in the “send to” field.

2 Likes