Answered

Hi! Building a flow to send emails using excel

(0) Share

Report

Posted on by khanya

Every time I try to run my flow I get the following error message: 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.

Please may someone help me solve this issue?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report
Hello,

It is complaining because your variable is a string of email adresses, and it cant loop that, it needs to loop an array, try making the string into an array with the follwing:

split(stringvariable, ';')

Was this reply helpful? Yes No
khanya 23 on at

Like (0)

Report

Thank you so much for your response! Do you know where/how I can make that change?

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
Hi @khanya ,

I agree with what @StretchFredrik said, you could use the Split() function to return an array from a string containing multiple email addresses.

I'm not sure how you set your string variable, so I have made a simple test for your reference.

split(variables('varEmailAddresses'),';')
items('Apply_to_each')

Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No