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

Introduction

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 https://forms.microsoft.com and sign in with your Microsoft account.

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

Create a new employee IT request form as below,

Create a SharePoint list called Employee Request

Create a list of fields as below,

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.

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

Now select the form ID as below,

Get response details

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

 Create a SharePoint list item,

• Utilize the columns containing form response details to generate a new 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,

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:

Get file content

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

Add an attachment

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

Finally, the flow will appear as follows.

Output

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.

Summary

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!