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

• 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!