Blank attachment in forms showing error while saving to sharepoint list

[Anonymous]

Hi All,

I have a form which has three fields text field, link field and one upload. A respondent can submit a link or upload an attachment. But the flow I created is not working if the upload field is empty. is there a way to make it work? 

screen shot of the flow:-

[powercorner]

Hey @Anonymous ,

the error comes from the fact that you defined a json scheme and inside this scheme the json action awaits a value which is not set inside your incoming json code. 

So you need to change the schema. 

What you can do is take the json output from the forms "get response details" action and use it to create a new scheme from example.

You will see that the scheme will change and then the workflow should work. In case it doent work just show me your current scheme and we will make the ajustments manually.

With regards

Kevin

[CFernandes]

Hey @Anonymous 

There are two ways of resolving this problem.

• Add null to the types as stated  https://www.sharepointsiren.com/2018/10/flow-parse-json-null-error-fix/ 
• Delete types altogether as stated http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow (scroll down to issue 4)

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

[Anonymous]

This is the schema I m using. Tried including null in all the parameters, but it is still throwing error.

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "name": {},

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

        },

        "required": [

            "name",

            "link",

            "id",

            "type",

            "size",

            "referenceId",

            "driveId",

            "status",

            "uploadSessionUrl"

        ]

    }

}

[powercorner]

Hello @Anonymous ,

you changed the null values but you have still defined the required fields. if you take the "null-valued" fields out of the required array it should work 🙂

If it this helps, I would be happy about a kudo and a solution 😉

With regards

Kevin

[Anonymous]

@powercorner  I have removed the fields from the required fields but the flow is still not running successfully. this is the schema:

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "name": {},

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

        },

        "required": []

    }

}

[powercorner]

hi @Anonymous ,

what is the exact error message? Can you screenshot it?

With regards

Kevin

[Anonymous]

[powercorner]

Hello again,

the error message states that there is a property called content? You havent defined any property called content in your schema. I dont know how important that data is, but maybe you could paste some example data here, so I could parse it in my flow and see and understand whats wrong.

With regards

Kevin 

[powercorner]

@Anonymous ,

maybe you can even show us a screen of the action in edit mode, cause I do not really understand what you are trying to achive. usually when you parse the information from a forms form the propertynames are coming as ids and not as text like you described it in your schema. I think your approach is kinda faulty.

so my schema looks like this: 

{
    "type": "object",
    "properties": {
        "responder": {
            "type": "string"
        },
        "submitDate": {
            "type": "string"
        },
        "r69fc42ea3d3842e5a7cfd87f04c5133f": {
            "type": "string"
        },
        "r98ee8e8e3fa3402995b5fe5ca6d839ba": {
            "type": "string"
        }
    }
}