Fix Duplicate Microsoft Forms Submissions in Power Automate
Question details
Users are experiencing multiple duplicate database records for a single Microsoft Forms submission processed through a Power Automate flow.
- Product
- Microsoft Power Automate
- Device & OS
- not provided
- Scenario
- Automating data entry from Microsoft Forms to a database or list using Power Automate.
- Observed behavior
- A single form submission triggers multiple database entries with different IDs and timestamps instead of a single record.
Ensure you have access to your Power Automate account with permissions to edit the affected flow and view its 28-day run history.
Review Flow Runs and Implement Duplicate Checks
Analyze the flow's run history to identify duplicate executions and add logic to prevent duplicate database entries.
Duplicate submissions often occur due to connector retry policies, temporary network timeouts, or missing idempotency logic. By adding a check before creating a new record, you can ensure that each Microsoft Forms response is only processed once.
Open Power Automate, navigate to 'My flows', select the affected flow, and review the run history to see if the trigger fired multiple times for one submission.
Edit the flow, click the ellipsis (...) on the trigger or action, go to 'Settings', and verify if the 'Retry Policy' is causing unintended duplicate runs.
Add a 'Get items' or 'Get row' action before your 'Create item' action to check if a record with the unique Response ID already exists in your database.
Insert a 'Condition' control to verify if the previous check returned any results. Configure it so the flow only proceeds to create the record if no existing entry is found.
Try WPS Office for Seamless Data Management and Forms
While resolving Power Automate workflow issues, you can simplify your document and data management with WPS Office. It offers a free, lightweight alternative to Microsoft Office with robust spreadsheet capabilities for analyzing your form responses without the high subscription costs.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install WPS Office: Run the downloaded installer file and follow the simple on-screen instructions to set up the software.
- 3. Open and Analyze Data: Launch WPS Spreadsheet to open, edit, and analyze your exported form data seamlessly.
Frequently Asked Questions
Why does Power Automate trigger multiple times for one form submission?
This usually happens due to connector retry policies, parallel flow runs, or temporary network timeouts that cause the system to re-send the submission automatically.
How can I uniquely identify a Microsoft Forms response in Power Automate?
Every Microsoft Forms submission has a unique 'Response Id'. You can use this dynamic content as a business key to check if a record has already been processed in your database.
Will disabling the retry policy stop duplicate submissions?
It might prevent duplicates caused by temporary timeouts, but it can also cause the flow to fail entirely if the destination database is momentarily unavailable. Adding a duplicate check via a Condition control is a much safer approach.
Can I delete duplicate records automatically in Power Automate?
Yes, you can create a scheduled flow that runs periodically to find and delete duplicate entries in your database based on the Response Id, though preventing them initially via logic checks is recommended.
