Combine Microsoft Forms Responses into One SharePoint List Item
Question details
The user needs to consolidate responses from three different Microsoft Forms into a single SharePoint list item for the same client file.

- 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.
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.
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.
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.
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.
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.
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.
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.

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. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the application: Run the downloaded installation file and follow the on-screen prompts to set up WPS Office on your device.
- 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.

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.




