Answered

Closeout Package Form - Append Multiple Attachments to Sharepoint List

(1) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
ScottAD 39 on at

Like (1)

Report

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

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

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)

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
ScottAD 39 on at

Like (1)

Report

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

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi @ScottAD ,

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

Was this reply helpful? Yes No
ScottAD 39 on at

Like (1)

Report
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']

Was this reply helpful? Yes No
Verified answer

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
ScottAD 39 on at

Like (1)

Report

That did it!

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ScottAD ,

Nice to see this working!

Was this reply helpful? Yes No