web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

JSON error

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    68,306 Most Valuable Professional on at
    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.

  • kcf549 Profile Picture
    2 on at
    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!

  • Pstork1 Profile Picture
    68,306 Most Valuable Professional on at
    Re: JSON error

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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard