Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Gallery / Power Automate - Webinars and Video Gallery / How to save Microsoft Forms...

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

16117 Views
RezaDorrani Profile Picture Posted by RezaDorrani 12,141

Hello everyone,

 

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 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: https://github.com/rdorrani/Microsoft-Flow/tree/master/MicrosoftForms 



Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Categories:

Comments

  • JaceyKhanh Profile Picture JaceyKhanh 9
    Posted at
    How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email

    Hi Reza,

     

    Many thanks for your video, I follow your video and create a MS form with multiple upload files (one of them is mandatory, and one is not mandatory requirement)

    I want to attach those files to the email to get approval. and it shows the below error

     

    "The 'inputs.parameters' of workflow operation 'Send_email_with_options_2' of type 'OpenApiConnectionWebhook' is not valid. Error details: The API operation 'SendMailWithOptions' is missing required property 'optionsEmailSubscription/Message/Attachments/0/ContentBytes'."

     

    JaceyKhanh_0-1682059449932.pngJaceyKhanh_1-1682059462443.png

    JaceyKhanh_2-1682059496081.png

     

     

     

     

     

     

  • sclarke23 Profile Picture sclarke23 33
    Posted at
    How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email

    Hi Rezza,

    This has been a really useful video to watch - thank you. It was really easy to understand and do it myself.

     

    Quick question...On my Microsoft form it is not required to attached any documents. So how would I put in a condition that it would only attach documents for those forms whihc people actually attached a document? Otherwise it is going to fail when there is nothing attached.

     

    I am sure it is putting a condition before the apply to each.

  • SharkGeforce Profile Picture SharkGeforce 1
    Posted at
    How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email

    Hi @RezaDorrani 

    You are amazing 😀

    I have a question here, I am planning to build my MS form & store it in Share Point, but in the middle I need to send that form for an approvals of 3 departments.

     

    Could you draw the flow for that?

     

    thank you

  • SaltySteve1706 Profile Picture SaltySteve1706 9
    Posted at
    How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email

    Sorry the above should have read "cover files or photos generated from 1 or 2 questions"

  • SaltySteve1706 Profile Picture SaltySteve1706 9
    Posted at
    How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email

    Hi Reza,

    I have been watching and attempting to use your procedure for saving form responses and multiple attachments to a SharePoint list and have had moderate success except, yours and every other tutorial I have found only cover questions generated from 1 or 2 questions.  I have a form that asks users to upload photographs they take while using the form (it is an inspection checklist), so there are 7 separate photos being taken along with the responses to the other questions in the form. Is there a way of adding all the photos to the SharePoint list using the flow you have designed?

    I use the Set Variable action for the first photo taken (which is required) and then Conditions for the remaining photos which may or may not be included.

    Would really appreciate your assistance if you are able to help.

    SaltySteve1706_1-1662962945948.png