Error: Apply to each is of type Object. The result must be a valid array.

[PeKi72]

Dear Experts, 

I try to read a sharepoint managed metadata column for a keyword. But i get this error-message:

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.

This is my flow:

Gr. P

[tom_riha · Accepted solution]

Hello @PeKi72 ,

the error message tells you that the input of 'Apply to each 2' is wrong. On the first look it seems to me that Power Automate messed up the input of that action. I'd try to remove the 'Apply to each 2' and the 'Send an HTTP request...' actions and add them again, that might fix it.

The problem is that the input of 'Apply to each 2' shouldn't be the 'Current item' (as that's the currently processed SP item = an object, not an array), it must be always an array e.g. a SharePoint multiple selection column, probably the 'Keywords'.