May 28 2018 02:34 AM
May 28 2018 02:34 AM
One of our respondents wants their response data removed from one of our forms; they're response #721, and we can only see the first 300 responses online. The form was created on the Forms website, so we can't delete a single result from Excel, since the workbook isn't linked to anything.
Is there any way to remove a response greater than 300 from this kind of form?
Jun 05 2018 03:37 PM
I am in the exact same scenario. We are going to have over 2500 responses and they can only complete it once. Users are not see all the questions and submitting without completing the complete survey so we need to be able to delete response so user can complete again.
Jun 11 2018 08:00 AM
I am in the same boat; if Microsoft expects people to take the forms option seriously there needs to be a way to edit large groups of data!
I'm tired of needing to use the more mature Google Forms because Microsoft built an incomplete program!
Aug 06 2018 02:13 PM
If you would like to edit or delete responses 1-300, you can easily do so by...
1. going to your Form
2. "Responses" tab
3. View Results
4. Choose the response you'd like to change from the drop-down
3. Click the 3 dots (. . .) on the bottom right of the greyed response area
4. "Delete Response"
If you'd like to edit responses 300+, you're screwed. I've talked with Microsoft Support and as of right now (Aug 2018) you cannot edit response data over 300 submissions.
You can make an online Excel doc and have your form dump the data into the Excel doc, and that works okay.
Aug 23 2018 05:52 AM
My experience of this is that it deletes the response from the form, but doesn't actually delete the data. After deleting responses, I currently have 144 in the form, yet 163 if I 'Open In Excel'. Any ideas?
Nov 16 2018 02:29 AM
Are there any news about this feature?
Is there any way to delete responses after the 300th in forms?
Nov 16 2018 06:32 AM
When I contacted Microsoft Support on this issue, they said that the program was "functioning correctly" and that if I wanted to see something changed, a program feature request could be submitted. I believe Microsoft uses a platform called "uservoice" for customers voting on issues like this.
Apr 24 2020 02:00 AM
You can download the previous responses into excel or create a summary link, then you can select Delete All Responses from the three button menu on the responses tab.
As far as I am aware the options are delete one or delete all currently.
May 07 2020 10:19 AM - edited May 07 2020 10:31 AM
It’s disappointing that this hasn’t been improved up to now.
What I discovered if it could help somebody:
1) When you use Group Forms, the Excel file with results is uploaded in SharePoint:
2) When you use My Forms, each time you click on Show Results, a new Excel file is generated.
Do you know a way to go to the form, from the Excel file?
Jun 04 2020 07:32 AM
Jun 04 2020 01:53 PM
Oh my, I didn't know this was not possible.
This means, Microsoft, that FORMS IS NOT GDPR COMPLIANT!!!
We are unable to delete all person related data if someone requests for that.
Keep my fingers crossed this will not be the case before Microsoft fixes this.
Jun 05 2020 12:58 AM - edited Jun 05 2020 01:06 AM
@BusyIntelligence @Ian Rarity assuming Forms in your tenant is working the same as mine you CAN delete individual responses, even ones with an ID into the high hundreds or thousands. In the attached video of the process I selected record 721 out of 959 for deletion:
OK this doesn't help with deleting multiple responses but it does allow you delete any response that has come in and remain GDPR-compliant.
Microsoft Power Automate Community Super User
Jun 05 2020 01:18 AM
Thank you @RobElliott. Great to post the video with your tip. I didn't know that and will help for sure.
I will test it with Forms Pro to check if the response is also deleted from the CDS environment.
If that's the case, it will do.
Jul 16 2020 01:31 AM
Is there a way to remove part of a record ie blank out particular fields? For example if it's a survey with a prize draw, and email address is collected, then the participant decides that they don't want that stored, we'd like to blank that out without losing their survey responses.