Forum Discussion

Anonymous's avatar
Anonymous
Jun 04, 2018

Forms for Excel results duplicating in Excel online

Hi,   I'm having some issues with results duplicating by itself non-stop every time a user submits a response. Basically, when a user submits a response, the Form writes to the Excel workbook and p...
microsoft 365 apps
office 365
sharepoint
sgibson1860's avatar
sgibson1860
Copper Contributor
May 13, 2020

Sean_Shen 

 

Were the duplicate entries receiving the same ID number as well?  

 

What we were seeing was the same entry occurring multiple times throughout the day (i.e. I submit the form in the morning, 30 minutes later, 2 hours later, 2 hours 5 minutes later, etc. the same submission is entered again in the table).  This continued throughout the day.  Then, close to the end of the day, a new spreadsheet popped up in the SharePoint Excel file.  Now, this new file is doing the same thing.

Sean_Shen's avatar
Sean_Shen
Copper Contributor
May 14, 2020
No, the ID of each response is unique. Per say I clicked submit button 5 times at the completion of a Form, it will create 5 same responses and mark it with continuous number such as ID: 1, 2, 3, 4, 5. Just like in database, when you mark the primary key column auto-increment.
  • sgibson1860's avatar
    sgibson1860
    Copper Contributor
    May 14, 2020

    Sean_Shen what I am seeing has the same ID.  In your instance, you see 1,2,3,4,5.  I am getting 1,2,3,4,5,4,5,4,5,3,4,5,4,5,3,3,3,4,4,4,5,5,5,5.  No pattern, just random duplication.

     

    I see where adding "Only allow one response" would stop your issue.  But, what I am seeing needs a validation rule in the database entry system.  The one thing I am seeing is it skipped entry "1185".  It seems to be trying to reload from there each time.

    • darwinpari's avatar
      darwinpari
      Copper Contributor
      Dec 21, 2021
      no official response from microsoft yet. to date the issue persists.

Resources