Power Automate - @Parse_JSON is type of Object The result value must be a valid array.

(1) Share

Report

Posted on by CU02080739-1

Hi Community,

I really need to resolve this issue, but I've been unsuccessful so far and really hope someone will be able to help! I created a Flow that makes an HTTP GET request to retrieve all IT tickets with a priority of 4 from another system. I managed to create the request and parse the JSON, but now I'm stuck. Next, I want to use the Select action to get properties for each ticket and then send an email for each ticket. However, I keep getting this error and have no idea what to do next:

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

This is what the Flow is looks like:

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Kameshm05 310 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi CU02080739-1 ,

You got an output from the HTTP as object type, but the apply to each only accepts the array as input. From your concern you need to get and apply the loop for tickets. So please use this expression in the Apply to each input. Please reply if it not works

body('Parse_JSON')?['tickets']

Thanks

Was this reply helpful? Yes No