SharePoint Document Issues

How to Add Microsoft Forms Responses to SharePoint Library Columns via Power Automate

Camila Milosovich Oct 9, 2026 869 views

Question details

The user wants to transfer data, such as a manager's name, from a Microsoft Forms response into a specific metadata column in a SharePoint document library for a file uploaded via the form.

How to Add Microsoft Forms Responses to SharePoint Library Columns with Power Automate

Product: SharePoint and Power Automate
Device & OS: not provided
Scenario: Automating document metadata tagging in SharePoint when files are submitted and uploaded through Microsoft Forms.
Observed behavior: A Microsoft Forms response and file upload are completed successfully, but the uploaded file in SharePoint needs its custom metadata columns updated automatically based on the submitted form fields.

Before you start

Ensure you have Owner or Member permissions for the target SharePoint document library and an active license to create workflows in Power Automate.

Solution 1Recommended

Create a Power Automate Flow to Update SharePoint Properties

Build a Power Automate flow that triggers upon form submission, locates the uploaded attachment in SharePoint, and updates its metadata columns using the form data.

When files are uploaded via Microsoft Forms, they are saved to a specific SharePoint folder (for group forms) or OneDrive (for personal forms). Power Automate can parse the attachment data to locate the exact file and apply the rest of the form's answers as SharePoint library column data.

Set the trigger and get response details

In Power Automate, create an Automated Cloud Flow. Choose 'When a new response is submitted' under Microsoft Forms as the trigger. Add the 'Get response details' action and provide the same Form Id and the dynamic Response Id.

Parse the uploaded attachment JSON

Add a 'Parse JSON' action to process the file upload question from your form. Use the attachment field output as the Content, and generate a schema based on a sample attachment output to access the file name and path dynamically.

Retrieve the SharePoint file metadata

Add the 'Get file metadata' (SharePoint) action. Use the dynamic file name or path extracted from the Parse JSON step to locate the specific document within your SharePoint site.

Update the file properties

Add the 'Update file properties' (SharePoint) action. Select your Site Address and Library Name. For the 'Id' field, use the ItemId retrieved from the 'Get file metadata' step. Finally, map the target custom column (e.g., Manager's name) to the corresponding answer field from the 'Get response details' action.

Create a Power Automate Flow to Update SharePoint Properties

Handling Multiple Attachments: If your form allows multiple file uploads, Power Automate will automatically place the 'Get file metadata' and 'Update file properties' actions inside an 'Apply to each' loop to process every uploaded file individually.

Free Microsoft Office alternative

Looking for a Lightweight Document Editor? Try WPS Office

While Power Automate and SharePoint manage your automated workflows and file storage, you still need a fast, reliable suite to view and edit those uploaded documents. WPS Office is a highly compatible, free alternative to Microsoft Office that handles your daily document tasks with ease.

1. Download and Install: Visit the official WPS Office website to download the free installation package for your operating system.
2. Open SharePoint Files: Download your automated documents from SharePoint and double-click to open them instantly in WPS Office.
3. Edit and Save: Make your necessary edits using the familiar ribbon interface and save directly in standard Microsoft Office formats.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) stored in your SharePoint libraries.Lightweight installation ensures extremely fast opening and editing of downloaded files.Built-in powerful PDF toolkit to annotate, edit, and convert documents seamlessly.Familiar tabbed interface eliminates the learning curve for new users.

microsoft office alternative - wps office

Frequently Asked Questions

Can I update multiple SharePoint columns from a single Forms response?

Yes. In the 'Update file properties' action in Power Automate, all available columns for that SharePoint document library will appear. You can map multiple dynamic content fields from your Microsoft Form to their corresponding SharePoint columns simultaneously.

Why is my Power Automate flow failing to find the SharePoint file?

This commonly occurs if the file path or name extracted from the Forms attachment array is incorrect or incomplete. Ensure you are parsing the attachment JSON correctly and using the exact file identifier stored in SharePoint before calling the 'Get file metadata' action.

Does this work if the Microsoft Form is personal rather than a Group Form?

Yes, but the file storage location differs. For personal forms, uploaded files are saved to your personal OneDrive for Business instead of a SharePoint site. You will need to use OneDrive connector actions (like 'Get file metadata') instead of SharePoint actions to locate the file, and then move or copy it to SharePoint if required.

Document & File Issues