Unanswered

How to solve the problem of this errormessage

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Errormessage:

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

About my workflow:

1 - Microsoft Form is filled and if necessary a picture is uploaded

2 - If a picture is uploaded, the flow is running without problems, but if there are no picture uploaded i get this message

I have an idea how to solve the problem => with a condition (some steps would be duplicated by this: Subsequent steps)

is it possible to solve this problem more "professionally"?

Parse JSON:

{

"type": "array",

"items": {

"type": "object",

"properties": {

"name": {

"type": "string"

"link": {

"type": "string"

"id": {

"type": [

"string",

"null"

]

"type": {},

"size": {

"type": "integer"

"referenceId": {

"type": "string"

"driveId": {

"type": "string"

"status": {

"type": "integer"

"uploadSessionUrl": {}

"required": [

"name",

"link",

"id",

"type",

"size",

"referenceId",

"driveId",

"status",

"uploadSessionUrl"

]

}

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Try editing the Parse JSON schema

"type": "string"

to

"type": ["string","null"]

Do the same for all other attributes which are optional.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks for the quick reply.
Now I tried, but the problem with the new code was not solved:

{
    "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": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

What's the error you getting?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

See this thread.

Solved: Parse JSON Error - Power Platform Community (microsoft.com)

Let me know how you get on.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks, this page helped a lot, only now I face another problem: Since I specify information about the image when uploaded, I bind the "body". Allerdingst there is then of course also an error message if no image is present
Would be here ev. a solution to create an image (without name / link etc.)

The execution of template action 'Microsoft_Forms_lädt_Datei_hoch_-_File_Name_muss_via_ParseJSON_ausgelesen_werden' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')' is of type 'Null'. The result must be a valid array.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Could you add an IF condition to check not null before the Apply to each? A flow screenshot is more helpful.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

an if condition solved the problem. Next time I'll ask right away with a screenshot.
Thanks 😊

Was this reply helpful? Yes No