Save a Single Microsoft Form Attachment to a SharePoint list with Power Automate

In this tutorial, Jonathan Silva from Pragmatic Works walks you through the process of saving a single attachment from a Microsoft Form to a SharePoint list using Power Automate. This workflow simplifies data management by automatically storing form submissions, including attachments, in a SharePoint list.

Overview: Why Save Form Attachments to SharePoint?

Microsoft Forms conveniently stores form data in Excel files within OneDrive, but accessing and managing these files can be cumbersome, especially when dealing with attachments. By using Power Automate, you can streamline the process, saving form attachments directly to a SharePoint list, making the data easier to manage and integrate into other workflows.

Step 1: Set Up Your Power Automate Flow

Jonathan begins by setting up a basic Power Automate flow that triggers whenever a new response is submitted in Microsoft Forms:

• Trigger: A new response is submitted in Microsoft Forms.
• Action: Get response details, which retrieves the specific responses from the form, including any attachments.
• Action: Create an item in SharePoint, mapping the form fields to corresponding SharePoint list columns.

Step 2: Handle the Form Attachment

The next step involves capturing and processing the attachment from the form submission:

• Since Microsoft Forms stores attachments as an array, even when there's only one attachment, you need to use an Apply to Each loop in Power Automate.
• Within the loop, use the JSON expression to parse the attachment data into a format that Power Automate can work with.
• Add an action to Get File Content from OneDrive for Business, using the ID of the attachment.

Step 3: Attach the File to the SharePoint List Item

Finally, Jonathan shows how to attach the file to the newly created SharePoint list item:

• Add an Add Attachment action to your flow, specifying the SharePoint site, list, and item ID.
• Set the file name and file content using expressions to pull data from the loop and the Get File Content action.

Testing and Verification

After saving the flow, Jonathan tests the process by submitting a form with an attachment. The flow runs successfully, and the attachment is correctly added to the SharePoint list item. He also demonstrates how to view attachments in the SharePoint list by enabling the Attachments column in the list view.

Conclusion

This step-by-step guide helps you automate the process of saving Microsoft Forms attachments to SharePoint using Power Automate. By following these steps, you can centralize form data and attachments in SharePoint, improving data accessibility and workflow efficiency.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Microsoft Forms, SharePoint, Power Automate and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.