Jun 04 2018
01:56 AM
- last edited on
Feb 06 2023
03:46 AM
by
TechCommunityAP
Jun 04 2018
01:56 AM
- last edited on
Feb 06 2023
03:46 AM
by
TechCommunityAP
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 puts the data in a row. This row then keeps duplicating itself without stop. This is happening on Excel online, and I can't seem to find a solution for this. Any help would be appreciated.
Thanks.
Jun 25 2018 09:12 AM
Jun 25 2018 09:12 AM
Sep 07 2018 03:36 AM
Hi there,
I am facing the exact same issue. Overnight, there are have been 1000+ duplicate entries created. Please, can anyone provide some guidance as to why this occurs and what can be done to resolve?
Oct 31 2018 09:37 AM
I am having the same issue, but cannot find a solution. Please let me know if anyone has figured out why this is occurring.
Nov 01 2018 02:44 AM
Nov 01 2018 04:54 AM
Nov 05 2018 03:09 PM
Rohit,
The problem persists for me after trying to start multiple forms from scratch.
Apr 16 2020 08:50 PM
This issue still exists. There are a lot of duplicates in the results and I cannot bulk delete it in Microsoft Forms Online. Hence, the charts and graphics shown in Forms online are not accurate with lots of duplicated results.
May 12 2020 08:47 AM
Anyone found a resolution to this issue. I have a Forms for Excel. Randomly today, it started duplicating entries from Forms.
May 12 2020 07:02 PM
I created a test form and shared it with anyone can answer permission to myself. When I finished the form, by clicking the submit buttom multiple times before it redirected to the completed interface, the problem can be reproduced. For anyone in your orgnization permission, it actually has a choice that distincts the response that eliminates the duplicates. However, that option is not available to permission "anyone can answer". The problem is if I want a lot of people in the company to answer a form, having them login first will just stop them from answering the form.
In conclusion, I think it is a design issue and I guess Microsoft will not fix this or add a "one response from each user" option to "anyone can answer" permission in a short time.
May 13 2020 04:29 AM - edited May 13 2020 04:31 AM
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.
May 13 2020 04:39 AM
May 13 2020 04:43 AM
Agreed but sad. The fix should be fairly easy "Do Not Allow Duplicates". This is operating off what appears to be a basic database (assuming SQL compliant Db). Opened it today and noticed it was replicating responses from April 27th. It almost makes the application not usable.
May 13 2020 07:02 PM
May 14 2020 04:54 AM - edited May 14 2020 05:06 AM
@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.
Dec 21 2021 02:14 PM
Dec 21 2021 02:17 PM