
Announcements
I'm new to power automate and following a guide online to send an attachment to all participants in an excel sheet but keep running into errors.
The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@{variables('varEmailAddresses')} ' is of type 'String'. The result must be a valid array.
I know its wrong but not sure how to fix it.
Hi,
Are you sending to all participants in a column, or does the column need to be filtered to specific rows?
Are you trying to send one email to all participants, or one email per participant?
I am going to guess all participants in a column, in one email. Here's how that would look:
The output of "txtEmails" ends up looking like this:
Let me know if you need something different or have any questions about the hows or whys of the above.
Cheers,
Rhia