Action 'Apply_to_each' failed: '@body('Parse_JSON_-_ServicePrincipals')?['body']?['value']' is of type 'Null'. The result must be a valid array.

(0) Share

Report

Posted on by Community Power Pla...

Dear Automators!

I'm in the process of building a power flow that sync all spn's and applications into a SharePoint list for automated review/attestation.

I'm recieving the following error when the test is executed:

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON_-_ServicePrincipals')?['body']?['value']' is of type 'Null'. The result must be a valid array.

I even added the "Null" value in the schema to support null values besides strings - see below screendump:

Anyone else experienced this before?

Best regards,

Roko

All responses (1)

Answers (1)

Verified answer

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

Re: Action 'Apply_to_each' failed: '@body('Parse_JSON_-_ServicePrincipals')?['body']?['value']' is of type 'Null'. The result must be a valid array.

Hi @Anonymous ,

Please consider to put your output from parse Json in to a "Initialize a variable" action to format it into a valid array.
Or refer to below function to surround the outputs to format it directly:
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.