error with flow - Action 'Parse_JSON' failed

(0) Share

Report

Posted on by Teaquell

Hi all,

I have an error with my flow - Action 'Parse_JSON' failed:

Details:

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 ''.'.

Screenshot 2022-10-18 143304.png

It appears when a the file upload feature on the MS Form is not inputted, but as this question on the Form is optional we need this flow to work either when the file upload is present or not.

Attached is a screenshot.

Many thanks,

Andy

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

Hey @Teaquell
Not sure this method will work in your case or not.
But modify your parse json.

Where ever you are getting error.

Just modify somethings there.
So for example, the following is written there:
"type": "string"
Instead of the above write there:
"type": ["string","null"]

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Teaquell

Try the below steps:

Step1: Remove the Parse Json step and run the flow.

Step2: Copy the body from the Get response details output and paste to Parse JSON Schema.

Step3: Add Parse JSON and provide Schema.

Step4: Run the flow again

Let me know if this works for you.

Regards
Kaif

Was this reply helpful? Yes No
Teaquell on at

Like (0)

Report
Copy link

Link copied!

Hey this did not work and I am still getting an error (see image below) I can provide my schema:
{
    "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": {}
        }


    }
}

Thanks,
Andy

Was this reply helpful? Yes No