How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email

This video is a step-by-step tutorial on how to leverage Power Automate flows to save Microsoft Forms Responses along with the attachments (multiple file uploads) to SharePoint Lists, SharePoint Document Libraries, SharePoint Folders & Send Email with Forms responses and attachments.
I will showcase how to create a Personal Microsoft Form & a Group Microsoft Form with file upload options and walkthrough steps of creating Power Automate flows to save the responses and the attachments in SharePoint. I will also showcase how to send Microsoft form responses in email along with the attachments.
I will also show where Microsoft Forms Attachments are saved. We will leverage Power Automate to query the saved Forms attachments which would either be in OneDrive for Business or SharePoint depending upon whether it is a Personal Microsoft Form or a Group Microsoft Form.

This Power Automate Tutorial Video covers the following:
✅ Create Microsoft Forms with File Upload
✅ Save MS Forms Response & Attachments to SharePoint List
✅ Save MS Forms Attachments to Document Library
✅ Save MS Forms Attachments to Folders
✅ Send Group Forms Attachments & Response in Outlook Email

⬇️ To download the Microsoft Forms, flows and JSON Formatting sample for SharePoint List showcased in the video:

📽️ Flow to save Microsoft forms data to SharePoint - All column types - choice, multiple choice, numbers, etc.

To learn about flow expressions:

To learn about list formatting:

Renaming Microsoft Forms Attachments:

#MicrosoftForms #PowerAutomate #SharePoint #Email #Outlook

Table of Contents:
0:00 - Introduction to saving Microsoft Forms data to SharePoint using Power Automate
0:33 - Build a Microsoft Form with File Upload Option
4:40 - Save Form Responses in SharePoint
6:19 - Flow to Save Forms Responses to SharePoint List
9:56 - Save Microsoft Form File Uploads to SharePoint List as Attachments
14:42 - Multiple File Upload Questions in Microsoft Forms
18:17 - Microsoft Forms File Upload to SharePoint Document Library
23:36 - SharePoint List Formatting
25:30 - Microsoft Forms File Uploads to SharePoint Folders
28:02 - Send Group Forms Response in Email
29:38 - Send Forms Response & Attachments in Email
34:31 - Subscribe to Reza Dorrani channel

🤝 Let’s connect on social:

[dougydoe]

Another great video, Reza. This time, I actually created everything alongside as I was watching it. That hands-one practice actually embeds the knowledge even more as I've discovered. A strange thing I noticed With the Training Survey Form (From a Group form), The Flow seemed to work only when I upload either an Image or PDF File. Once I added a Word or Excel File, it fails at the "Get the content using path" action... giving a file not found (404) error. it finds the image, PDF but couldn't find the Word/Excel file. What could be causing that? In the demo, you uploaded PDF's so you may not have noticed it or, I may be doing something wrong?? Will be interesting to find out your thoughts on that. Thanks again

[bastoshenrique]

I'm not the kind of person who is used to like and comment on videos but I had to surrender myself to this one because it helped me to solve a big problem related to this topic. Thank you very much for share this content we us!!! Like the video and follow you is the least we should do!

[xelias]

Youtube is amazing, I was having a very specific issue at work regarding form attachment and how to transfer them into a sharepoint list, and somehow, there's a really detailled and didactic video explaining every details of the process, walking me through the whole ordeal
Thank you so much !

[sgb]

Spent half a day trying to get this working with other vids, only took 15min once I found yours. Bravo sir!

[nadiadamiens]

Thank you for this very instructive video
I managed to complete a project only 10 days after discovering power automate.

[manishh]

So timely. I spent time doing form attachments to both lists and email (in an approval request) but where mines was heavy at processing each attachment, including checking if null, Reza's code does it in 4-5 steps as opposed to mines which was 4 steps for each file processed. Guess whose spending time tonight to optimise his flow.

Reza, you're brilliant.

[niu]

Hi ReZa! love how your video is always packed with knowledge and various scenarios! Thanks for this guide, i will be useful for my organisation!❤

[VeroLaVege]

This is THE best tutorial on how to handle Forms attachment in List. Thank you so, so much. I had spent countless hours trying to understand how to deal with optional or multiple Forms attachment, and this made it super easy. I managed to have the 4 different optional file uploads from my Forms saved to my List. Thank you, thank you, thank you!!!

[cvkealey]

Great stuff! Your use of expressions to streamline the process is beautiful. As much as I practice, I really struggle with writing complex/compound expressions and nearly always resort to using a bunch of compose actions with much simpler formulas. Also, thanks for linking to my video on manipulating the file name to remove the submitter's name.

[jayong]

I watched this in 1.5 speed and bang! I got more than I asked for. Fantastic tutorial! Thank you!!!

[davidadams]

What a fantastic video!! A genuine masterclass. Clear, structured, each grows on the next. The way you construct the flow is very intuitive - others say, "I'm going to create a variable, you'll see why later...". You say, "I need x but hold on, I need to loop through, so first I need to create a variable". This is far better for newbies that don't have that foresight yet. Brilliant! Quick question: in the Additional Documents demo, you created a condition to check whether Additional Documents was null before proceeding. Why not simply create varFiles and then append both Photos and Additional Documents to it? If the Additional Documents array is empty, it won't append anything to the varFiles array. No need for the conditional branch?

[uncle_jojo]

This is unbelievable. I did a Google search for "microsoft forms store data from responses". This is the first returned video. It is crazy that this process is exactly what I needed. I have never had the first returned video ever be the perfect video for my needs. Wow. It covered both of my use cases - storing responses to my OneDrive and for a Group SharePoint. Thank you so much!

[fredconti]

Best tutorial for handling attachments. Reza has thought of many different scenarios and has clearly shown how to handle each one. Bravo!

[manublr]

Dear Reza. Thanks a lot for your service to human kind. You deserve a lot!!
2 questions
1. Can I rename the file so that my name is removed?
2. How do I get a unique url to the form submitted by user so that I will include the same in list item for anyone to access the filled form.

[evolutionsimplified]

Reza actually inspires confidence and trust. When autoplay is on and I come across one of his videos, I know to put my food down and pay attention.

[matthewbaker]

Thank you Reza, once again you have successfully shown me how to solve a power automate puzzle where many others fail. I should have known to check your channel first. I am grateful for all the help you so generously provide. 🙏

[brendanbarstow]

Thanks so much! Solved an afternoon of troubleshooting in 10 mins!

[fengchenwei]

4/9/2024 this flow still work well. Thanks for your video, Reza

[lindsayreiner]

Following this tutorial made me do a happy dance every time something worked on the first try 🎉 thank you Reza!!

[niltonlopez]

Hola a todos! Primero que todo agradecer a Reza por su increíble video, me ayudó mucho. Tuve el error en el cuál la automatización se quedaba en un bucle perpetuo, solo paso a recordarles que primero que todo revisen los permisos de adjuntar archivos de su lista de SharePoint, pase horas investigando y probando diversas maneras y simplemente era ese permiso. 😁