Others

Fix Power Automate Creating Only One SharePoint Item from MS Forms

Aamir Naveed Akram Sep 25, 2026 870 views

Question details

The user needs the Power Automate flow to successfully generate a new SharePoint list item for every incoming Microsoft Forms response, rather than just capturing the first one.

How to Fix Power Automate Creating Only One SharePoint Item from Forms Responses

Product: Microsoft Power Automate
Device & OS: not provided
Scenario: Setting up an automated workflow to transfer recurring Microsoft Forms survey or request data into a centralized SharePoint list.
Observed behavior: The Power Automate flow successfully triggers and creates a SharePoint list item for the very first form response, but fails to create items for any subsequent responses.

Before you start

Check your Power Automate 28-day run history to determine if the flow is failing silently on subsequent responses or if the trigger isn't recognizing new submissions at all.

Solution 1Recommended

Reconfigure the Microsoft Forms Trigger and Action

Ensure you are using the correct automated trigger and fetching the response details so the flow loops or triggers individually for each new submission.

A common reason a flow only fires once is the use of an incorrect trigger type or a manual trigger instead of an automated one. The flow must be designed to listen for every new event from Microsoft Forms.

Edit the Power Automate Flow

Log into Power Automate, go to 'My flows', select the flow that is malfunctioning, and click 'Edit' to view the flow designer.

Verify the Trigger Action

Ensure the very first step is the automated trigger named 'When a new response is submitted'. Select your specific form from the Form Id dropdown.

Add 'Get response details'

Immediately after the trigger, add the 'Get response details' action. Use the same Form Id, and for the Response Id field, select 'Response Id' from the dynamic content provided by the trigger.

Configure the SharePoint Action

Add the 'Create item' action for SharePoint. Map the dynamic content from the 'Get response details' step to the corresponding SharePoint list columns.

Save and Test

Save the flow and submit two new test responses to the Microsoft Form to verify that two new items are sequentially created in the SharePoint list.

Reconfigure the Microsoft Forms Trigger and Action

Trigger Behavior: The 'When a new response is submitted' trigger automatically fires an independent flow instance for every individual response. You typically do not need an 'Apply to each' loop for the main response data.

Solution 2

Consult the Power Platform Community

If standard trigger reconfiguration does not solve complex loop or concurrency issues, specialized support is required.

Free Microsoft Office alternative

Enhance Your Document Workflows with WPS Office

While Power Automate manages your cloud data transfers, WPS Office provides a lightweight, highly compatible alternative for opening, analyzing, and editing the exported data in Spreadsheets and Documents offline.

1. Visit the Official Website: Navigate to the WPS Office official website to access the free download.
2. Download the Installer: Click the 'Download WPS Office Free' button and save the installer file to your device.
3. Install and Edit: Run the installer, complete the quick setup, and immediately start editing your SharePoint exports and Office documents.

Completely free and lightweight suite for everyday tasksHigh compatibility with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsFamiliar user interface ensuring seamless migration and zero learning curveBuilt-in advanced PDF editing and document conversion tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does my flow run history show only one successful run despite multiple form submissions?

This usually indicates the trigger is not properly binding to the form's submission event. Ensure the flow is toggled 'On', the connection to Microsoft Forms is authenticated, and you are using the 'When a new response is submitted' automated trigger rather than a manual one.

Do I need an 'Apply to each' loop to process Microsoft Forms responses?

Generally, no. The standard Microsoft Forms trigger fires a new instance of the flow for each submitted response individually. An 'Apply to each' loop is only necessary if a specific question on your form allows uploading multiple files or returns an array of data.

Could SharePoint list permissions be blocking subsequent items from being created?

Yes. If the account running the Power Automate connection does not have persistent 'Contribute' or 'Edit' permissions on the target SharePoint list, or if there is a unique value constraint on one of your SharePoint columns (like a unique ID that gets duplicated), subsequent item creations will fail.

Office Quick Solutions