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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Parse JSON Error

(1) ShareShare
ReportReport
Posted on by 27

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

 

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

I have created a form with the option to upload a document. I have received the above-mentioned error in the flow. Can someone please guide me regarding this?
Categories:
  • Verified answer
    Sundeep_Malik Profile Picture
    6,501 on at

    Hey @Swapnil1991 

     

    Mostly it gives error when the required part contains null values, so modify your parse json schema accordingly. Plus in type: ["string"], add null part too. And one for thing to set up schema for parse json for the first time pass all the values in the form, dont let any field/question be empty, this will give you the full schema for your parse json action. I have modified some of the schema below:

     

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

     

     

     

    I hope this helps 🙂

  • CU20071712-1 Profile Picture
    27 on at

    Thanks It worked but now I am having some other error.

    Swapnil1991_0-1692211030305.png

     

    Swapnil1991_1-1692211084482.png


    Can you please help me regarding this?

  • CU20071712-1 Profile Picture
    27 on at

    I am not able to find the drive id and id from dynamic content.

    Screenshot - 

    Swapnil1991_0-1692211501325.png

     

  • CU20071712-1 Profile Picture
    27 on at

    Really sorry to disturb you again. Please ignore everything above mentioned.

    All got resolved.


    The last thing is I can't find Var =attachments in the dynamic content. So even if I upload the document while submitting the form, everything works well but can't get the uploaded file attached to the email.

  • Sundeep_Malik Profile Picture
    6,501 on at

    @Swapnil1991 

    Let me try it on my end tomorrow and I will get back to you.

    🙂

  • CU20071712-1 Profile Picture
    27 on at

    Basically, I am having a flow in which, I am getting - 

    MS form inputs as an email attachment as a pdf

    and

    I want to add an upload file option as another attachment in the same email.

    If you need some other details please let me know. I can share the screenshots.

    Once again thanks for your help @Sundeep_Malik.

  • Sundeep_Malik Profile Picture
    6,501 on at

    Hey @ManishSolanki 

     

    Can you help a little here if you are free, I am really busy today.

    And congratulations on getting that flownaut badge and super user status 🙂

  • Manish Solanki Profile Picture
    15,169 Moderator on at

    Thanks @Sundeep_Malik & many congratulations to you too for recognized as Super User 🙂

     

    Hi @Swapnil1991 ,

     

    Pls follow the below link for sending multiple attachments in an email with the help of an array variable:

    Advanced | Flow of the Week: Send multiple attachments on a single email | Power Automate Blog (microsoft.com)

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 349 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard