Hello.
Trust everyone is safe and well 
.
I have been trying to follow the video on how to add attachments from forms to sharepoint list but i am not doing something right as i keep getting this error.
Any help will be welcome. Thank you
This is the make up of my flow
On the Parse Json - i am not sure what to add here - i copied and pasted the schema provided
@GBeulen no it won't, the steps you need to add a file uploaded to a Microsoft Forms form to an attachment in a SharePoint list are as shown below.
Your trigger is the Forms "when a new reponse is submitted". The first action as always is the Forms "get response details":
You now need to add a "Parse JSON action". In the content field select the question from your form where you asked the user to upload the file.
The schema field will work with the following:
{
"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"
]
}
}
The file is always saved to your OneDrive in the
first(body('Parse_JSON'))?['name']
Next, create an item in your SharePoint list:
Next, add an "apply to each" action and in the first field select Body from the Parse JSON section of the dynamic content box.
Finally, inside the apply to each add a SharePoint "add attachment" action. In the Id field select ID from the create item section of the dynamic content. In the File name field select name from the Parse JSON section of the dynamic content box. In the File content field select File content from the "get file content using path" section of the dynamic content.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
@RobElliott , why do I still get error message even though i have change to my path as below
this is my path (group sharepoint)
.
even i have tried so many different method including yours, stil get error message.
And this is my connection. is it because of this?
Please advise what needs to be done.
Thank you in advance.
@rlehrawaaca why not? You can just type the folder path in the field:
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP (and classic 1967 Morris Traveller driver)
What I do is to go to settings for the actions that relate to the optional file upload, go to settings and select Configure Run After and select Failed as well as is successful. The following images are from our IT Support Ticketing System where uploading a file is not mandatory.
So even if the individual actions actions relating to the file upload fail the flow continues to run and will be shown in the run history as succeeded.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Accepted Solutions