Announcements
39
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
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.
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
Share
Report
All responses (
Answers (
{
"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 -
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']
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.
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)
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.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
