bring in multiple attachments from MS form to Sharepoint list

(0) Share

Report

Posted on by nerdyplayer

162

I have a form that will allow users to upload documents to Microsoft Forms and want to use power automate to pull the documents into a List.

How do I do that?

I started the flow to grab the text and choice fields. but not sure how to pull the documents. ty

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

l wrote a blog on how to get files added to an MS Form and email them. The files are actually stored in the form author's OneDrive for Business. Here's the blog post. Retrieve the files the same way and then create them in SharePoint instead of emailing them. Emailing File Attachments from Forms with Power Automate – What Me Pa..Panic?

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @nerdyplayer,

You can refer below video for more store attachment in SharePoint list.

https://www.youtube.com/watch?v=4Sa6E_kk75Y

---------------------------------------------------------------------------------

📩 Need more help? Mention@Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
nerdyplayer 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Ty Pstork,

I did follow your prompt and added a SP connector to move the files. The parse JSON is below.

It did work, the issue that I had it wouldn't allow the user to remain anonymous. Since it uses the creator's onedrive, I get a message from sharepoint saying a file was sent to me with the other user's name.
Can't remove that notification or restrict those notification so for my needs I need to go back to square 1. Did learn something though.

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

Was this reply helpful? Yes No
CU27021306-0 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I strongly recommend using a group form for situations like this. This playlist is a few years old, but the concepts are still the same: https://www.youtube.com/playlist?list=PLMVyjgrWIGnwQowO2RsvHg0pZ8EozvAG-

Was this reply helpful? Yes No