Forum Discussion

kellyhickman14096's avatar
kellyhickman14096
Brass Contributor
Jun 04, 2025
Solved

Duplicate responses in Excel

I've been using Forms to create a Sharepoint list for some months now. Just in the past few days I've had an issue with one submission creating two or more response ID's in the Excel spreadsheet sync...
  • Marcus-Apps4rent's avatar
    Marcus-Apps4rent
    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

Resources