Unanswered

How to solve the problem of this errormessage

(0) Share

Report

Posted on by Community Power Pla...

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)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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... on at

Like (1)

Report

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,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

What's the error you getting?

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

Like (0)

Report

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,865 Most Valuable Professional on at

Like (0)

Report

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... on at

Like (0)

Report

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,865 Most Valuable Professional on at

Like (0)

Report

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... on at

Like (0)

Report

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

Was this reply helpful? Yes No