Others

Combine Microsoft Forms Responses into One SharePoint List Item

Steven ParkerSteven Parker Oct 28, 2026 870 views

Question details

The user needs to consolidate responses from three different Microsoft Forms into a single SharePoint list item for the same client file.

How to Combine Microsoft Forms Responses into One SharePoint List Item
Product
Power Automate, SharePoint, Microsoft Forms
Device & OS
not provided
Scenario
Managing multiple form submissions for a single client file via automated workflows.
Observed behavior
Separate Power Automate flows currently create multiple, disjointed rows in the SharePoint list for each form response instead of combining them into one unified row.
Before you start

Ensure you have edit permissions for both your SharePoint list and the corresponding Power Automate flows. You must also decide on a shared unique identifier (such as a Client ID or Email Address) that can be captured across all three Microsoft Forms.

Solution 1Recommended

Use a Unique Identifier to Update or Create SharePoint Items

Use this logic in your Power Automate flows to check if a client record already exists in SharePoint before deciding whether to create a new row or update an existing one.

To combine multiple form responses into one SharePoint list item, each of your Power Automate flows needs to be 'aware' of existing entries. By capturing a common unique identifier in every form, your flow can search the SharePoint list to see if that client's row has already been created by a previous form submission.

1
Add a unique identifier to all forms

Ensure all three Microsoft Forms include a required field that asks for the exact same unique identifier, such as a Client ID, Case Number, or User Email.

2
Add the 'Get items' action

In each of your Power Automate flows, insert a SharePoint 'Get items' action before creating a row. Configure the OData Filter Query in this action to search the SharePoint list for a row where the unique identifier column matches the identifier submitted in the form.

3
Implement a condition control

Add a 'Condition' action to evaluate the results of the 'Get items' step. Use an expression like 'length(outputs('Get_items')?['body/value'])' and set it to 'is greater than 0'. This checks if a matching row already exists.

4
Configure 'Update item' for existing records

In the 'If yes' branch of your condition (meaning a record exists), add the SharePoint 'Update item' action. Use the ID from the 'Get items' output to update the existing row with the new form responses.

5
Configure 'Create item' for new records

In the 'If no' branch (meaning no record exists yet), add the SharePoint 'Create item' action to generate a brand new row using the submitted form data.

Use a Unique Identifier to Update or Create SharePoint Items
Concurrency Settings: If there is a chance that multiple forms for the same client are submitted at the exact same time, consider enabling concurrency control in your flow settings to run instances sequentially, preventing duplicate row creation.
Free Microsoft Office alternative

Looking for a lightweight alternative to Microsoft Office? Try WPS Office

While Power Automate handles complex automated workflows, managing your daily documents, spreadsheets, and presentations shouldn't be complicated. WPS Office provides a free, lightweight, and highly compatible alternative for your everyday office needs.

  1. 1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install the application: Run the downloaded installation file and follow the on-screen prompts to set up WPS Office on your device.
  3. 3. Open your existing files: Launch WPS Office and directly open your existing Microsoft Office files. They will open flawlessly with layout and formatting preserved.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Lightweight application that runs smoothly on older or low-spec devicesFamiliar, tabbed user interface for seamless and intuitive migrationFree built-in PDF editing, merging, and conversion tools
microsoft office alternative - wps office

Frequently Asked Questions

Can I use an email address as the unique identifier across multiple forms?

Yes. If the forms are filled out by authenticated users within your organization, you can automatically capture the responder's email address and use it as the unique identifier to look up existing SharePoint list items.

Why is my 'Get items' action returning multiple rows in Power Automate?

This occurs if your unique identifier is not truly unique within the SharePoint list. Ensure your OData filter query strictly matches a field that only appears once per client or case file.

How do I extract the ID from the 'Get items' action to use in 'Update item'?

When you select the ID dynamic content from the 'Get items' action inside your 'Update item' configuration, Power Automate will automatically place it inside an 'Apply to each' loop because 'Get items' returns an array. This is normal and will safely update the matched item.