Email address manually entered in form not working in flow

[dholl007]

I am trying to send an approval status to another email address that is manually entered in the Form on original entry. However, I keep getting an error message "The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_4')' is of type 'Object'. The result must be a valid array." 

I know the flow works with a defined email address entered in "To:" field via Send an Email (V2) part of the flow, but not grabbing the email manually entered by user.

Any insight? 

[trice602]

Hi @dholl007 ,

Without seeing your flow, it is difficult to understand but will guess and describe here:

Your trigger will be "When a new form response is submitted"

Action:  Get responses.

Action: Start and Wait for an approval (example)

One option: your form question should be a text field.  You can add a subtitle to your question and ask the user to enter in more than one email address with a semicolon, so

valid:  tom@somewhere.com

valid:  tom@somewhere.com; you@somewhere.com 

Then your start and wait for an approval is the dynamic content for this question from get response details.  I suspect your form question is not a text field and something else but again, difficult to describe a solution without knowing what it is, but the above does work.

[wyattdave]

Hi @dholl007 ,

this sounds like because you are using an Apply to each on an individual item. Apply to each only work on arrays (tables) and you are passing an item (row). 

To fix the issue you need to remove the action you are entering the email address from inside of the Apply to each and then re-add the email address back into the action.

>--------------------------------------------
If this helped solve your question please mark it as the solution.

I also do a weekly Power Platform blog at https://dev.to/wyattdave