Closeout Package Form - Append Multiple Attachments to Sharepoint List

[ScottAD]

I am working on a flow where an installer can upload a single PDF in MS Forms and then in a separate question they can upload to 10 images. The flow below will add the PDF and the first install image but not the remaining nine. What am I missing? All of the images get uploaded to the Sharepoint folder but only one attachment from each question is being added to the list in Sharepoint

[trice602]

Hi @ScottAD ,

The issue with the second upload question is it needs to be in a loop so for each file, get content, add the attachment.  This one seems to work well, here's an example:

First, I have the entire 2nd question code in a condition (in case it is empty), you don't want the error but if true, parse the json question, and then apply to each, get file attachment content using path, add attachment.

The condition statement is empty(dynamic_content_for_2nd_question) is not equal to expression true.

[ScottAD]

Thank you, in Apply to each, what should I be using there?

[trice602]

Hi @ScottAD ,

If you are going to use the conditional action to see if any uploads exists (because the question may be optional), send then after parse json, you will add the action "Get file content using path".

You will point to the site address where the files are uploaded, typically something like:

https://abc-my.sharepoint.com/personal/thomas123

The file Path is in this format and starts with a "/"

/Documents/Apps/Microsoft Forms/[Your sheet name]/[Your question name]/[dynamic content_body name]

(don't include the square brackets above, illustrated to show these are dynamic content.  This is the folder where the attachments from a form are stored.

Next in Add attachment you have your site address (of the list) and the list name followed by 3 variables:

ID (is the ID of the list)

File name (is the bodyname dynamic content from parse json)

File content (body from get file content)

[trice602]

Hi @ScottAD ,

If you are manually adding the apply to each or for each loop, the content is body from Parse JSON action but I typically just add the next step and let the loop create item to ensure the right dynamic content is selected.

[ScottAD]

Thanks I understood where I need put things but do I even need the variable in this? Here is the new flow

[trice602]

Hi @ScottAD ,

Sorry I added a 2nd post after the fact.  It is the body of the parse JSON action for your images.

[ScottAD]

Thanks for your patience as I learn this, and apologies if I come across obtuse. I'm still not getting the result I expect. I still only get one file from each question. Here is a detail of the flow.

Condensed

Don't need anything for new response or get, those work

Create item

Initialize Variable - Not sure if needed

Apply to Each 1 - Not needed if Variable isn't

Parse JSON for PDF

Schema for Parse JSON PDF

{
    "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"
        ]
    }
}

Get file using content path

Expression for Get file - first(body('Parse_JSON_COP_PDF'))?['name']

Add attachment - Expression is same in Get file content

Condition

Expression - 

empty(outputs('Get_response_details')?['body/rc0f5347cf1c045d7b67f0d23981070ed'])

If Yes

Schema for Parse JSON Install Images

{
    "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"
        ]
    }
}

Apply to each 2

Expression - first(body('Parse_JSON_INSTALL_IMAGES'))?['name']

 

[trice602 · Accepted solution]

Hi @ScottAD ,

No worries, I don't think you are being obtuse.  The root cause is you are using the dynamic content expression first() in the file name so you are getting the first file.

Because you are in a for each loop, you want to use the dynamic content for "name" from the parse JSON action in both your get file content using path "File Path" AND the add attachment "File Name" fields.

Your dynamic content for these two should be:  items('Apply_to_each_2')['name']

Goes without saying, don't type it in, select the dynamic content "name" from your parse JSON action.

[ScottAD]

That did it!

[trice602]

Hi @ScottAD ,

Nice to see this working!