Unanswered

Blank attachment in forms showing error while saving to sharepoint list

(0) Share

Report

Posted on by Noob01

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:-

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

powercorner 477 on at

Like (0)

Report
Copy link

Link copied!

Hey @Noob01 ,

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

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hey @Noob01

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.

Was this reply helpful? Yes No
Noob01 13 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
powercorner 477 on at

Like (0)

Report
Copy link

Link copied!

Hello @Noob01 ,

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

Was this reply helpful? Yes No
Noob01 13 on at

Like (0)

Report
Copy link

Link copied!

@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": []
    }
}

Was this reply helpful? Yes No
powercorner 477 on at

Like (0)

Report
Copy link

Link copied!

hi @Noob01 ,

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

With regards

Kevin

Was this reply helpful? Yes No
Noob01 13 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
powercorner 477 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
powercorner 477 on at

Like (0)

Report
Copy link

Link copied!
@Noob01 ,

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

Was this reply helpful? Yes No