Forum Discussion
Duplicate responses in Excel
- Jun 05, 2025
kellyhickman14096 Thanks for the clarification, Since you’re already using the right trigger from Microsoft Forms, and still seeing two different response IDs for a single submission, it definitely sounds like a backend sync glitch or timing issue between Forms and the Power Automate trigger, it’s intermittent and could be tied to latency or a momentary hiccup in Microsoft’s services
Unfortunately, since the duplicates aren’t consistent and Forms itself is generating the IDs, there’s no solid fix yet. Until Microsoft addresses it on their end, your best bet is to build a small check inside your flow, maybe compare timestamps or user input to spot and skip duplicates before SharePoint items are created.
hopefully Microsoft improves this behavior soon
Not sure how to edit, but I wanted to indicate the screenshot is the Excel spreadsheet retrieved when I click on View Responses.