Null Value Error in Parse JSON

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello I receive the following error when running my flow.

Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '33823': 'Required property 'content' expects a value but got null. Path ''.'.

Below is my Parse JSON schema:

{

"type": "array",

"items": {

"type": "object",

"properties": {

"name": {

"type": "string"

"link": {

"type": "string"

"id": {

"type": "string"

"type": {},

"size": {

"type": "integer"

"referenceId": {

"type": "string"

"driveId": {

"type": "string"

"status": {

"type": "integer"

"uploadSessionUrl": {}

"required": [

"name",

"link",

"id",

"type",

"size",

"referenceId",

"driveId",

"status",

"uploadSessionUrl"

]

}

The flow is pulling picture attachments from a Microsoft Form and putting it into a sharepoint grid. I want it to allow a null value, but I'm not entirely sure how. There are multiple attachments from different forms questions. I am still fairly new to this, so any help would be appreciated. Thank you!

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 69,125 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The problem is that the value you are trying to Parse is null. You need to put a condition in to evaluate the value before you feed it to the Parse JSON. If the value is empty (null) then you need to bypass the parse JSON or use a Parse JSON that is using static content.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks Pstork1,
Would you be able to elaborate a bit more on how to bypass the parse JSON if it is null?

Was this reply helpful? Yes No
Pstork1 69,125 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Put a condition before the Parse JSON action and test the input to see if its blank. only execute the Parse JSON step if the input isn't blank.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I am still receiving the same error message.

Was this reply helpful? Yes No
Suggested answer

Hellen ramos 12 on at

Like (1)

Report
Copy link

Link copied!

Hey!
Try to modify your array like this:

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "name": {

                "type": ["string","null"]

            },

            "link": {

                "type": ["string","null"]

            },

            "id": {

                "type": ["string","null"]

            },

            "type": {},

            "size": {

                "type": ["integer","null"]

            },

            "referenceId": {

                "type": ["string","null"]

            },

            "driveId": {

                "type": ["string","null"]

            },

            "status": {

                "type": ["integer","null"]

            },

            "uploadSessionUrl": {}

        }

    }

}

Every time you need to pass values that may be empty, you need to add the "null" type in the parse and remove the required part.

Hope it helped!

Was this reply helpful? Yes No