Unanswered

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_9' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON_5')?['body']?['items']' is of type 'Null'. The result must be a valid array.

(0) Share

Report

Posted on by ollyberry7

Hi, I am having issues with a flow that I have built, which is displaying the following error message:

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_9' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON_5')?['body']?['items']' is of type 'Null'. The result must be a valid array.

This is what the flow looks like:

Essentially, the Parse JSON runs correctly, however the information is not populating the SharePoint List at all and skipping past these.

Is there a way to fix this? I have tried rebuilding, etc and nothing seems to be working...

Any repsonses appreicated, thank you in advance.

Olly

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

I think if you add a condition after your Parse JSON 5 action you will be all set. You'll want to set the condition to where the length of the body of the Parse JSON 5 action is greater than zero. The length expression counts how many items are in the array. According to the error, your array contains no values. By adding the condition, you can add the Apply to each action to the yes side of the condition when it contains items. The expression would be length(outputs('Parse_JSON_5))

Was this reply helpful? Yes No
ollyberry7 4 on at

Like (0)

Report

Hi David,

Thank you for this.

I have tried your suggestion and am now getting the following error:

InvalidTemplate. Unable to process template language expressions for action 'Condition_5' at line '0' and column '0': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#length for usage details.'.

See below the error and the build:

Does this look correct to you?

Thank you for your help.

Was this reply helpful? Yes No