cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
koneill2020
Helper II
Helper II

Getting Attachments into List from MS Forms

All,

In my PowerAutomate – I’m trying to get three attachments from a MS Form and put them into a list.

The MS Form has some branching logic and one of the branches has the requirement for one attachment while the other branch has the requirement for two attachments.

The below semi-works in that it sometimes does take the first file and place it into the list – but then errors on this condition with: Action 'Parse_JSON_Upload_PO' failed

Therefore, any ideas of what my logic needs to be to get the attachments into the list.

koneill2020_1-1664892156586.png

 

Note – my Parse JSON payload schema looks as such:

{

    "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"

        ]

    }

}

 

1 ACCEPTED SOLUTION

Accepted Solutions
tom_riha
Super User
Super User

Hello @koneill2020 ,

I was trying to find a better solution but the only one seems to be to add a 'Condition' before each attempt to save an attachment - check if the attachment is available, and if it's not there, skip the attachment processing steps. If you expect 3 attachments in 3 different places you'll need 3 conditions in your flow.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

1 REPLY 1
tom_riha
Super User
Super User

Hello @koneill2020 ,

I was trying to find a better solution but the only one seems to be to add a 'Condition' before each attempt to save an attachment - check if the attachment is available, and if it's not there, skip the attachment processing steps. If you expect 3 attachments in 3 different places you'll need 3 conditions in your flow.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,686)