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

397,312
0
Published 2022-03-14
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:
github.com/rdorrani/Microsoft-Flow/tree/master/Mic…

📽️ Flow to save Microsoft forms data to SharePoint - All column types - choice, multiple choice, numbers, etc.
   • Power Automate Microsoft Forms Connec...  

To learn about flow expressions:
   • Power Automate flow Expressions Tutorial  

To learn about list formatting:
   • SharePoint List Formatting  

Renaming Microsoft Forms Attachments:
   • Handling Forms file upload filenames  

#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:
🔗 LinkedIn: www.linkedin.com/in/rezadorrani/
🐦 Twitter: twitter.com/rezadorrani

All Comments (21)
  • @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 though..... 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!
  • @manishh7323
    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.
  • @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!
  • @sgb3474
    Spent half a day trying to get this working with other vids, only took 15min once I found yours. Bravo sir!
  • @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.
  • @MrClux4
    Another awesome video! This is very similar to my current project, so your timing is impeccable! I am doing a faculty appointment form where the user has to upload verification documents. I added branching and a final document upload at the end. With this video, I can now go back and add multiple file uploads. Thank you so much!!!
  • @fredconti8530
    Best tutorial for handling attachments. Reza has thought of many different scenarios and has clearly shown how to handle each one. Bravo!
  • @davidadams421
    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?
  • Thanks for all your videos! You have helped me so much in my career. This video ended a long search for a resolution of why my data wasn't uploading to SharePoint for all of my sites when they didn't add an attachment! You're the best! Keep them coming!
  • @jayong1418
    I watched this in 1.5 speed and bang! I got more than I asked for. Fantastic tutorial! Thank you!!!
  • @matthewbaker4163
    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. 🙏
  • Thank you SO much! This has been one of the most simple ways to do this. Other articles on the internet are much too complicated and I've used this many times. Thank you again!
  • Your a star and make it look so easy, mind you I have used a lot of your videos to get my head around things. So well explained and thank not just for this video but all the others, please don't ever stop we need you
  • @mjmann2402
    My goodness! Another dynamic video! I learn something every week from you, Reza. Please keep the videos coming.
  • @AnonymousXMR
    Easy explanation of many different use scenarios, much appreciated.
  • @chrisdyde4778
    This was really helpful. Just getting started with Power Automate etc. and Reza laid it out very clearly, especially the attachments part which was really complex in some examples
  • @nadiadamiens3222
    Thank you for this very instructive video I managed to complete a project only 10 days after discovering power automate.