The result must be a valid array.

[Kh3ldar]

Hello,

I've made lots of research before resorting here.

This is my schema.

{
    "type": "object",
    "properties": {
        "statusCode": {
            "type": "integer"
        },
        "headers": {
            "type": "object",
            "properties": {
                "Transfer-Encoding": {
                    "type": "string"
                },
                "Vary": {
                    "type": "string"
                },
                "Cache-Control": {
                    "type": "string"
                },
                "Set-Cookie": {
                    "type": "string"
                },
                "X-SharePointHealthScore": {
                    "type": "string"
                },
                "X-SP-SERVERSTATE": {
                    "type": "string"
                },
                "DATASERVICEVERSION": {
                    "type": "string"
                },
                "SPClientServiceRequestDuration": {
                    "type": "string"
                },
                "X-DataBoundary": {
                    "type": "string"
                },
                "X-1DSCollectorUrl": {
                    "type": "string"
                },
                "X-AriaCollectorURL": {
                    "type": "string"
                },
                "SPRequestGuid": {
                    "type": "string"
                },
                "Request-Id": {
                    "type": "string"
                },
                "MS-CV": {
                    "type": "string"
                },
                "Strict-Transport-Security": {
                    "type": "string"
                },
                "X-Frame-Options": {
                    "type": "string"
                },
                "Content-Security-Policy": {
                    "type": "string"
                },
                "MicrosoftSharePointTeamServices": {
                    "type": "string"
                },
                "X-Content-Type-Options": {
                    "type": "string"
                },
                "X-MS-InvokeApp": {
                    "type": "string"
                },
                "P3P": {
                    "type": "string"
                },
                "X-AspNet-Version": {
                    "type": "string"
                },
                "X-Powered-By": {
                    "type": "string"
                },
                "x-ms-request-id": {
                    "type": "string"
                },
                "Timing-Allow-Origin": {
                    "type": "string"
                },
                "x-ms-apihub-cached-response": {
                    "type": "string"
                },
                "x-ms-apihub-obo": {
                    "type": "string"
                },
                "Date": {
                    "type": "string"
                },
                "Content-Type": {
                    "type": "string"
                },
                "Expires": {
                    "type": "string"
                },
                "Last-Modified": {
                    "type": "string"
                },
                "Content-Length": {
                    "type": "string"
                }
            }
        },
        "body": {
            "type": "object",
            "properties": {
                "odata.nextLink": {
                    "type": "string"
                },
                "value": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "Modified": {
                                "type": "string"
                            },
                            "FileRef": {
                                "type": "string"
                            },
                            "FileLeafRef": {
                                "type": "string"
                            }
                        },
                        "required": [
                            "Modified",
                            "FileRef",
                            "FileLeafRef"
                        ]
                    }
                }
            }
        }
    }
}

 
I get the

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

I've tried

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

 is of type 'Null'. The result must be a valid array.

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

is of type 'Null'. The result must be a valid array.

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

Doesn't throw an error but it doesn't do anything. The loop just freezes.

Please note that the schema is automatically generated.

I'd really appreciate your assistance.

[MarconettiMarco]

Hello @Kh3ldar ,

what's the objective of your flow?

BR,

Marco

[Shujaath_Khan]

Hi @Kh3ldar 

I believe you don't need parse JSON action to parse response from SharePoint as SharePoint shall give back response in JSON coz you mentioned already accept header

Apply_to_each works on enumerable objects like Array or List.

make sure the key from parent JSON over which you're trying to enumerate is of type array or List.

If you're looking out to iterate over value key try below.

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

Thanks

Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

[jennratten · Accepted solution]

Hello - give this a try...

Construct an apply to each using this - 

body('Send_an_HTTP_request_to_SharePoint' )['value']

Inside the apply to each, access individual elements - 

items('Apply_to_each')['Title']

[Kh3ldar]

Hello, the objective of the flow is to get a list of all the Excel files on our SP and record their path and names inside an excel table.

[Kh3ldar]

I'm sorry, I should have mentioned that I'm new to PowerAutomate, have relatively pretty basic info regarding JSON and HTTP.  I don't actually know what you mean. I've managed to come this before by looking things up. I don't actually need to use JSON but the value that's generated by SP HTTP request becomes more readable with JSON format. The HTTP request only gets file path, name and last access date and I need to save those values for every Excel file inside an Excel Table.

Also, that code also results in NULL error.

[Kh3ldar]

Thank you... This works... I really appreciate it.

[jennratten]

You are very welcome!