The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.

[johnjohn123]

We have the following:-

1) SharePoint list which have a field of type People/Group which allow multiple selection

2) Planner

now we want to loop through all the SharePoint items >> and for each item >> to create a planner task >> assign the planner task to the users defined inside the People/Group field... but i am not sure how i can implement the scenario of building a comma separated list of a SharePoint People/Group field which allow multiple selection, so i can define this comma separated list inside the Assigned User Ids's planner field:-

I also try this workflow:-

1) get all the SP items + initialize an array var

2) initialize string var + loop through the SP items + build an array of the assigned users' emails 

3) build a comma separated var string based on the array, add the string var to the create planner task:-

but when i run the flow i got this error "The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array.":-

any advice?

[Pstork1]

The inner loop should be based on the multichoice field, not on the current item from the outer loop.

[johnjohn123]

@Pstork1  can you please advice more? thanks

[johnjohn123]

@Pstork1   i did those 2 modifications:- 

1) Inside the inner loop:-

2) and inside the set variable (which i used to convert the array to a comma separated string):-

but i got this error when i try to save the flow:-

Flow save failed with code 'WorkflowRunActionInputsInvalidProperty' and message 'The inputs of workflow run action 'Set_variable' of type 'SetVariable' are not valid. Self reference is not supported when updating the value of variable 'commaemail2'.'.

@Pstork1

[Pstork1]

When you append the email in Apply to each 2 you also need to add a ';'.  Also, commaemail should be a string variable and not an array variable.  Once that is done you don't need the Apply to each 3 at all.  Just use commaemail as the TO in the email.

[shawn_fielding]

I am getting this same error.  I actually took all actions out of the nested for loop.  So: 

Apply to each: Value -> Apply to Each: Current Item

Then nothing in it.  

Errors out.  

Did you ever get this working?

[Efe_Ildem]

I have this easy problem but somehow i can't fix this. I need help. Thank you

[Pstork1]

The due data is an indifidual field, not an array.  There shouldn't be a nested loop, just a single loop.

[PabloBaculinao]

I am also getting the same error.

[Pstork1]

See previous answer.  The value you are using in the Apply to each 2 loop isn't an array its an object. You don't need the second loop.

[PabloBaculinao]

Power Automate automatically add apply to each 2 when I add the email address of the LM on CC field of Send an email (V2). Please screenshot below.

[Pstork1]

The second loop is running on Current Item, which is an object, not an array.  Not sure what order you added things in, but that Loop should not be there and isn't necessary.

[mallelajyothi]

I am also facing same issue, can you please help me.

[Pstork1]

Please post this as a new question.  You'll get more responses and others will be able to find the answer more easily later.