Others

How to Display Microsoft Forms Images in a SharePoint List with Power Automate

Maira Mehtab Sep 25, 2026 868 views

Question details

The user needs to map an image uploaded via Microsoft Forms directly to a SharePoint list Picture column using Power Automate so the image is visible in the list.

How to Display Microsoft Forms Images in a SharePoint List with Power Automate

Product: Power Automate, SharePoint, Microsoft Forms
Device & OS: not provided
Scenario: Automating data transfer from a Microsoft Forms submission to a SharePoint list, specifically handling image file uploads.
Observed behavior: Power Automate does not automatically map the uploaded image file array directly to the SharePoint list Picture column, leaving the column empty or generating an error.

Before you start

Ensure you have Site Owner or Member permissions on the destination SharePoint site, and verify that your Microsoft Form is configured to allow file uploads.

Solution 1Recommended

Parse JSON and Update SharePoint Item URL

Use this solution to extract the image URL from the Microsoft Forms response array and update the SharePoint Picture column.

Microsoft Forms saves file uploads as a JSON array string. Because a SharePoint Picture column requires a specific URL format, you must parse the Forms response data in Power Automate before mapping it.

Trigger the flow with Forms response

In Power Automate, create an automated cloud flow with the trigger 'When a new response is submitted'. Add the 'Get response details' action to retrieve the form submission data.

Parse the uploaded file data

Add a 'Parse JSON' action. Use the dynamic content of your file upload question as the Content. Run a test submission first to generate the sample JSON schema needed for this step.

Construct the image URL

Depending on whether it is a personal or group form, construct the absolute URL pointing to the file stored in OneDrive or the SharePoint Document Library using the extracted file name or ID.

Update the SharePoint list item

Add the 'Update item' action for your SharePoint list. In the Picture column field, insert the dynamically constructed image URL so the list can render the image.

Parse JSON and Update SharePoint Item URL

Array Handling: If you allow multiple file uploads in your form, Power Automate will automatically place the 'Update item' action inside an 'Apply to each' loop.

Solution 2

Consult the Power Platform Community

If you encounter complex schema errors or permission mapping issues, seek expert assistance from the official Microsoft community.

Free Microsoft Office alternative

Try WPS Office for Your Daily Productivity Needs

While Power Automate and SharePoint are great for complex web automation, WPS Office is an excellent free, lightweight, and easy-to-use alternative for your daily document processing, spreadsheet data analysis, and presentations. Enjoy a familiar interface and seamless migration from Microsoft Office.

1. Download the installer: Visit the official WPS Office website and download the free installer for your operating system.
2. Install the software: Run the installer file and follow the quick on-screen instructions to set up the software.
3. Open your Microsoft files directly: Launch WPS Office and instantly open any existing Word, Excel, or PowerPoint files without losing formatting.

Highly compatible with Microsoft Office formats (.docx, .xlsx, .pptx)Lightweight installation with blazing fast performanceFree alternative to expensive Office software subscriptionsAll-in-one workspace for documents, spreadsheets, presentations, and PDFs

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Power Automate map the Forms image directly to SharePoint?

Microsoft Forms saves file uploads as a JSON string containing an array of file metadata (like name, size, and ID). Power Automate cannot push this raw text array directly into a SharePoint Picture column, which expects a single URL string.

Where are Microsoft Forms file uploads actually saved?

If the form is a personal form, uploaded files are saved to a dedicated folder in your OneDrive for Business. If it is a group form, the files are saved to the default document library of the SharePoint site associated with that group.

Can I display multiple images in a single SharePoint list Picture column?

No, a standard SharePoint Picture column only supports a single image URL. To handle multiple uploaded images from a form, you must either use a multi-line text column to store multiple URLs or add the images as attachments to the list item instead.

Office Quick Solutions