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:
Create your Microsoft Form to collect responses.
Set up a SharePoint list where you want to store the form responses.
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.
Create a new employee Joining Form 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 Educational Certificates 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:
And it automatically to Apply to each
Add an attachment
Use the file name and file content from the preceding action in the current process.
The flow run successfully
Upon successfully creating a new item in Microsoft Forms, a corresponding list item will be generated in the “Employee Joining Form” 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.
For any Help or Queries Contact us on info@crmonce.com or +918096556344
