Others

Fix Power Automate Flow Completes but SharePoint Fields are Blank

Algirdas Jasaitis Oct 7, 2026 869 views

Question details

User needs to troubleshoot a Power Automate flow that executes successfully but fails to populate data in a SharePoint list.

Fix Power Automate Flow Completes but SharePoint Fields are Blank

Product: Power Automate & SharePoint
Device & OS: not provided
Scenario: Automating data transfer from Microsoft Forms to a SharePoint list using a Power Automate cloud flow.
Observed behavior: The flow registers as 'Successful' in the run history, but the newly created SharePoint list item contains empty or blank fields instead of the submitted form data.

Before you start

Ensure you have the necessary edit permissions for both the source Microsoft Form and the target SharePoint list before modifying the flow.

Solution 1Recommended

Verify Forms Data Retrieval and Column Mapping

The most common cause of blank fields is missing the 'Get response details' action or incorrectly mapping dynamic content to the SharePoint columns.

When transferring data from Microsoft Forms, the trigger alone only provides the Response ID. You must fetch the actual answers using a secondary action before creating the SharePoint item.

Add Get Response Details

Open your flow in Power Automate. Ensure the 'Get response details' action is added immediately after the 'When a new response is submitted' trigger.

Access SharePoint Action

Click on the 'Create item' or 'Update item' SharePoint action to expand its configuration panel.

Map Dynamic Content

Click inside each SharePoint column field and select the corresponding dynamic content explicitly from the 'Get response details' section, not from the trigger section.

Test the Flow

Save the flow and run a manual test by submitting a new dummy response to the Microsoft Form to verify the fields populate.

Verify Forms Data Retrieval and Column Mapping

Data Type Mismatch: Ensure the data type of the Forms question (e.g., Text, Date) perfectly matches the configuration of the corresponding SharePoint column to prevent data drops.

Solution 2

Analyze Flow Run History to Identify Data Loss

Checking the raw inputs and outputs of a previous run can help identify exactly where the data is being lost or recognized as blank.

Free Microsoft Office alternative

Looking for a Simpler Way to Manage Documents and Data?

While Power Automate and SharePoint handle complex cloud workflows, you might be looking for a lightweight, reliable, and cost-effective solution for your daily document and spreadsheet tasks. WPS Office offers a powerful suite that is fully compatible with Microsoft formats.

1. Download WPS Office: Visit the official WPS Office website and click the Free Download button.
2. Install the Suite: Run the installation file and follow the on-screen prompts to set up the software on your device.
3. Manage Your Data: Open WPS Spreadsheet to easily manage, filter, and format your exported list data in a familiar environment.

Seamless compatibility with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx).Powerful spreadsheet tool to track, analyze, and manage list data easily without complex cloud configurations.Built-in PDF editor and form filler without requiring extra subscriptions.Lightweight installation and intuitive user interface for faster everyday productivity.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power Automate flow say 'Succeeded' but no data appears in SharePoint?

A flow reports as 'Succeeded' if all actions execute without critical system errors, even if the dynamic content passed between them is completely empty. This usually happens if you map the SharePoint fields to empty variables or miss the 'Get response details' action entirely.

Do I need special permissions for Power Automate to write to SharePoint?

Yes. The user account whose connection is authenticated in the 'Create item' action must have at least 'Edit' or 'Contribute' permissions on the target SharePoint list.

How do I fix a data type mismatch between Microsoft Forms and SharePoint?

If a Form question allows multiple answers or custom text but the SharePoint column is a strict 'Choice' or 'Number' field, the flow may insert a blank or fail to parse it. Ensure the SharePoint column type is set to 'Single line of text' or format the flow data strings to match the column type exactly.

Office Quick Solutions