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
Unanswered

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

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    68,678 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,678 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard