Others

How to Upload Microsoft Forms Attachments to SharePoint via Power Automate

Maira Mehtab Sep 28, 2026 869 views

Question details

The user is attempting to configure a Power Automate flow to transfer Microsoft Forms responses to SharePoint, but the flow fails when trying to upload the form's file attachments.

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Automating the transfer of form submissions and their attached documents into a SharePoint repository.
Observed behavior: Standard text fields from the Microsoft Form transfer successfully, but the flow encounters an error and fails to process or upload the attached files to SharePoint.

Before you start

Verify that your Microsoft account has the necessary permissions to access both the Microsoft Forms responses (usually stored in your OneDrive) and the target SharePoint site document library.

Solution 1Recommended

Parse Attachment Metadata and Retrieve File Content

Standard flows fail because attachment data is returned as a JSON string. You must parse this metadata and fetch the actual file content before creating the file in SharePoint.

When a user uploads a file to a Microsoft Form, the attachment details are passed as a JSON array. To successfully move the file to SharePoint, your flow must parse this array, use the resulting identifier to grab the actual file content from OneDrive (where personal forms store attachments), and finally pass that content to SharePoint.

Add a Parse JSON action

In your flow, add a 'Parse JSON' action. Use the 'Response details' attachment output as the content. Generate the schema from a sample by running the flow once and copying the raw output of the attachment array.

Get the file content

Add the 'Get file content' action (using the OneDrive for Business connector). In the 'File' field, map the dynamic 'id' generated by your Parse JSON step. This will automatically place the action inside an 'Apply to each' loop.

Create the file in SharePoint

Inside the same loop, add the 'Create file' action for SharePoint. Map the 'Site Address' and 'Folder Path'. For 'File Name', use the 'name' dynamic content from Parse JSON. For 'File Content', use the dynamic 'File content' output from the previous OneDrive step.

Group Forms vs Personal Forms: If your Microsoft Form is a Group Form, the attachments are stored in the SharePoint default document library instead of your personal OneDrive. You must use the SharePoint 'Get file content' action instead.

Solution 2

Seek Assistance in the Power Platform Community

If you are encountering expression errors or specific flow failures, posting your exact configuration to the community forum is the fastest way to get custom troubleshooting steps.

Free Microsoft Office alternative

Need a Seamless Office Experience? Try WPS Office

While Power Automate and SharePoint are part of the Microsoft ecosystem, WPS Office provides an exceptional, lightweight alternative for viewing, editing, and managing your downloaded Office documents locally without expensive subscriptions.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Install the Software: Run the setup file and follow the on-screen instructions to complete the installation.
3. Open Your Documents: Launch WPS Office to easily open, edit, and save your SharePoint-managed documents.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Lightweight application that requires minimal system resources.Includes built-in PDF editing and format conversion tools.Free to use with a familiar, easy-to-navigate user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why do Microsoft Forms attachments show up as code in Power Automate?

Microsoft Forms passes attachment information as a JSON string (a text-based data array) rather than actual files. You must use a 'Parse JSON' step in Power Automate to extract the file name and ID before you can retrieve the actual file.

Where are Microsoft Forms attachments stored before they move to SharePoint?

For personal forms created under your account, attachments are saved in your OneDrive for Business inside the 'Apps > Microsoft Forms' folder. For group forms, they are stored directly in the default document library of the connected SharePoint site.

Can I integrate WPS Office directly with Microsoft Power Automate?

WPS Office is an independent office suite and does not feature native trigger connectors in Power Automate. However, because WPS Office is highly compatible with standard Microsoft formats (.docx, .xlsx, .pptx), you can flawlessly open and edit any documents generated or moved by your Power Automate flows.

Office Quick Solutions