Unanswered

Flow does not work when a response is submitted without an attachment through MS form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I created a flow to create items in list when a response is submitted via MS form, especially when the attachment is image(jpg,png,jpeg) such that it should reflect in the list.
However, the flow throws an error when an attachment is not present is there a way that the flow runs even if no attachment is present, I tried using condition but for some reason it throws an error.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

In you JSON schema , please change the type of that to any and that should work fine good.

If this helps , please give this answer a thumbs up and accept this as a solution.

Thanks,
Sanmesh

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

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG ,
I removed the 'required' property from json schema but it still throws following error.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Sorry you should change the type of the property (Which is causing an error) to any instead in the beginning , in the JSON schema.

Else can you paste the JSON schema / data here?

Thanks,
Sanmesh

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

Like (0)

Report
Copy link

Link copied!

Hi @SanmeshG
Please find below the json schema:
{
    "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"
        ]
    }
}

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

1. I think you can have a condition to check, if the array is empty using the empty function in Power Automate before you parse the JSON , and you can include the Parse JSON action inside a condition where it is not empty (Parse JSON if that array is not empty
2. Else you can completely skip the Parse JSON action and change the approach a little bit , you can check out the below video by Raza , where he has showcased the exact use case.

https://www.youtube.com/watch?v=K-hiDOPAG-4

If this helps , please give this a thumbs up and accept this as a solution.

Thanks,

Was this reply helpful? Yes No