02-14-2019 06:10 AM
02-14-2019 06:10 AM
Just starting out with Forms and have already come across an issue. We have set up a simple training survey form which works great.
I've deleted all of the initial test responses so the form no shows 0 responses - all good but if I export the responses to Excel, it displays all of the test responses. Should I then make this form live, those test responses could skew the overall results.
Is this expected behaviour or is something not quite right on my tenant?
02-14-2019 06:23 AM
02-14-2019 06:27 AM
Thanks for that - have tried it but the Export to Excel option remains active and still shows all previous responses. The form itself shows 0 responses etc (attached screenshot).
Maybe just a timing thing? Will leave it until tomorrow and will try it again
02-14-2019 06:31 AM
02-18-2019 04:14 PM
I want to check that you have delete all responses in Forms web app, and when you click on "Download in Excel" (you will get a new download Excel workbook), the new workbook contains all the history data. Is it right?
Could you share your form URL with us, so we could troubleshoot?
06-06-2019 10:38 AM
@Zhongzhong LiI am having this same issue -- I have an active form with 19 (and growing) true responses, but "Open in Excel" is still showing 10 additional test responses that I had deleted individually. I don't want to have to copy/clone the form, as the link has been shared with others who are already submitting new responses. It might be important to note that this is a Group Form; those test responses were for testing a new Flow I created after sharing the form with others on my team. The legitimate responses were submitted both before and after that move and testing, so I didn't want to clear all responses.
Which URL could I share with you to troubleshoot?
11-27-2019 11:33 PM
Could you help me please with my issue?
I am using Microsoft 365. I have set up a simple training survey form that works great. And After I viewed the 12 responses, I exported them to excel. But the result was unsatisfying, as some of the question's responses were vanished from the excel file!
There are like 4 questions out of 20 that were exported to the excel file but without their responses.
You can find attached the excel file.
Thank You in Advance.
11-29-2019 04:31 AM
12-01-2019 01:07 AM