Skip to main content

Notifications

Community site session details

Community site session details

Session Id : gBGxxORULs3AA1Tnc8dOZd
Power Automate - Using Flows
Unanswered

Null Value Error in Parse JSON

Like (0) ShareShare
ReportReport
Posted on 15 Dec 2020 17:01:38 by

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!

  • Suggested answer
    Hellen ramos Profile Picture
    12 on 19 Mar 2025 at 17:10:03
    Null Value Error in Parse JSON
    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!
  • Community Power Platform Member Profile Picture
    on 15 Dec 2020 at 18:43:44
    Re: Null Value Error in Parse JSON

    I am still receiving the same error message.

    COmike10_0-1608057814214.png

     

  • Pstork1 Profile Picture
    66,093 Most Valuable Professional on 15 Dec 2020 at 17:47:32
    Re: Null Value Error in Parse JSON

    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.

    image.png

  • Community Power Platform Member Profile Picture
    on 15 Dec 2020 at 17:25:33
    Re: Null Value Error in Parse JSON

    Thanks Pstork1,

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

     

  • Pstork1 Profile Picture
    66,093 Most Valuable Professional on 15 Dec 2020 at 17:06:10
    Re: Null Value Error in Parse JSON

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Using Flows

Overall leaderboard

Featured topics

Restore a deleted flow