Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : kNzc5vJ1mdnIoeECNLuRmy
Power Platform Community / Forums / Power Automate - Building Flows / JSON error
Power Automate - Building Flows
Answered

JSON error

Like (0) ShareShare
ReportReport
Posted on 13 Aug 2020 15:03:14 by Koko56 29

Hi, 

 

I copied a functioning workflow I had and changed some items in the workflow in relation to what SharePoint list it should attach to. When I try to run the workflow, I get the error:

 

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

 

Here is the schema I have that worked in my last workflow that I copied over to this workflow. 

 

{
    "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"
        ]
    }
}
 
 

I have attached a couple screenshots to help visualize the issue.

 

Thanks

 

Screen Shot 2020-08-13 at 10.06.03 AM.pngScreen Shot 2020-08-13 at 11.00.56 AM.png

 

 

 

 

Screen Shot 2020-08-13 at 11.01.40 AM.png

  • Pstork1 Profile Picture
    Pstork1 67,077 Most Valuable Professional on 14 May 2022 at 14:53:46
    Re: JSON error

    That is the correct syntax.  Not sure why I typed the curly braces there.  Its definitely the square brackets.

  • kcf549 Profile Picture
    kcf549 2 on 13 May 2022 at 19:57:07
    Re: JSON error

    I was able to solve this problem using PStork1's answer, but with slightly different syntax:

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

     

    Just in case that helps anyone.

     

    Thank you!

  • Verified answer
    Pstork1 Profile Picture
    Pstork1 67,077 Most Valuable Professional on 13 Aug 2020 at 15:36:53
    Re: JSON error

    There are two possible issues here.

     

    1) The JSON schema that is autogenerated by Power Automate doesn't take into account that some properties may be Null.  To fix that manually edit the schema for the affected properties like this:  "type": ["string", "null"].  This will allow the property to be Null without developing an error.

    2) The other issue would be if you need that property to be non-null.  If that is the case then there is something else wrong with the flow and the info that is being returned.

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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans