No attachment causes error in flow

[steveyhandsome]

Hi folks,

I've successfully figured out how to add an attachment from an MS Form into a Sharepoint list. It works like a charm thanks to the good people in this community (thank you!).

My issue now (ironically) is that when my MS Form submission doesn't have an attachment, the flow fails at the Parse JSON step with the following error:

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

I think this means that it's expecting to find content, but there's no attachment. Is this as simple as just adding a condition to check if there is no attachment? Any suggestions?

Here's the Parse JSON code:

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "name": {

                "type": "string"

            },

            "link": {

                "type": "string"

            },

            "id": {

                "type": "string"

            },

            "type": {},

            "size": {

                "type": "integer"

            },

            "referenceId": {

                "type": "string"

            },

            "driveId": {

                "type": "string"

            },

            "status": {

                "type": "integer"

            },

            "uploadSessionUrl": {}

        },

        "required": [

            "name",

            "link",

            "id",

            "type",

            "size",

            "referenceId",

            "driveId",

            "status",

            "uploadSessionUrl"

        ]

    }

}

[Jcook]

Hi @steveyhandsome 

What is the name of the attachment field?

You can remove the "required" properties from the JSON schema (It's at the end in [ ] )

[steveyhandsome]

Hey @Jcook 

The name of the field (from the MS Form) is Supporting documentation. 

Here's what the screenshot looks like:

Do I really need to delete all the 'Required' properties?

[v-liwei-msft · Accepted solution]

Hi @steveyhandsome 

You can add a condition and use the empty function to check if the attachment is empty:

Best Regards,

Levi

[steveyhandsome]

Thanks @v-liwei-msft! Now I'm getting an error with that expression. Does this code make sense in the Empty expression, or do I need to input the string of characters from your screenshot?

empty(outputs('Get response details')?['body'])

Apologies for all the questions, Power Automate is not my forte.