This would normally be very easy, but the naming of elements within your array are different throughout the array (E1, E2 etc). So you have to use an expression. This does what you want:
In the select action the "From" should be the compose that contains your email addresses. Then put the select into text mode, use this expression:
replace(substring(string(item()),7), '"}', '')
This is going to give you back a simple array that looks like this:
[
"Dxx@xxxxxxxxxxx.org.nz",
"axxxxxxxx@xxxxxxxxxxx.org.nz",
"Rxxxx@xxxxxxxxxxx.org.nz",
"fxxxxx@xxxxxxxxxxx.org.nz"
]
You can then use a compose action on the output of the select:
join(body('Select'), ';')
which will produce output like:
Dxx@xxxxxxxxxxx.org.nz;axxxxxxxx@xxxxxxxxxxx.org.nz;Rxxxx@xxxxxxxxxxx.org.nz;fxxxxx@xxxxxxxxxxx.org.nz;Dxxxx@xxxxxxxxxxx.org.nz;axxxxxx@xxxxxxxxxxx.org.nz;nxxx@xxxxxxxxxxx.org.nz;Hxxxx@xxxxxxxxxxx.org.nz;fxxx@xxxxxxxxxxx.org.nz;Hxxxxx@xxxxxxxxxxx.org.nz;nxxx@xxxxxxxxxxx.org.nz;axxxxxx@xxxxxxxxxxx.org.nz
Which you can use to email everyone at the same time.
Blog: tachytelic.net
YouTube: https://www.youtube.com/c/PaulieM/videos
If I answered your question, please accept it as a solution 😘
