How to save Microsoft Forms Responses with Attachments to SharePoint Lists?


In this article, we will explore the process of retrieving a Microsoft Forms response that includes an attachment and saving it directly to a SharePoint list.

It includes the following steps:

  1. Create your Microsoft Form to collect responses.
  2. Set up a SharePoint list where you want to store the form responses.
  3. Utilize Power Automate to automate the process of saving the responses to the SharePoint list, including attachments.

Create a Microsoft Form

Go to and sign in with your Microsoft account.

Or Move to the App launcher > Select Forms > Create a new form

Microsoft Apps

Create a new employee IT request form as below,

New employee IT request

Create a SharePoint list called Employee Request

Create a list of fields as below,

List field

In the choice field, add choices the same as MS form choices.

Create power automate

Move to the Power Automate > Click on Create a Flow> Select Automated flow

Enter a flow name and select a trigger when the new response is submitted, as below.

Cloud flow

Click on Create, and it will be looks like this,

Form create

Now select the form ID as below,

Form id

Get response details

  • This selection will be used to retrieve form responses, which will then be used to create a SharePoint list item.
    Get response details

 Create a SharePoint list item,

  • Utilize the columns containing form response details to generate a new list item.
    ​​​​​​​Create a SharePoint list item

Now we will start the attachment process,

Parse JSON

When you execute the "Get Response Details," you will locate the JSON within the Document column. Afterward, use the "Generate from Sample" option to automatically create a JSON schema, as illustrated below,

Parse json

Retrieve the JSON schema provided in the previously uploaded document and apply it within the "Parse JSON" function using the "Generate from Sample" option, as demonstrated below:

Retrieve the json

Get file content

  • Utilize the ID obtained from the "Parse JSON" action in the following manner:
    ​​​​​​​Get filecontent

Add an attachment

  • Use the file name and file content from the preceding action in the current process.
    Add attachment

Finally, the flow will appear as follows.



Upon successfully creating a new item in Microsoft Forms, a corresponding list item will be generated in the "Employee Request" list, complete with an attachment.



This article provides a clear step-by-step guide on how to save Microsoft Form responses, including attachments, directly to SharePoint lists. It covers creating the form, setting up a SharePoint list, generating a Microsoft Power Automate flow, saving attachments, and creating the list items with response data. By following these steps, users can seamlessly integrate their data management process and efficiently store form responses within SharePoint, eliminating manual tasks.

I hope this helps.

Sharing is caring!

Similar Articles