03-23-2019 09:14 PM - edited 03-23-2019 09:15 PM
I have a form connected to an Excel file in my OneDrive. I locked the sheet to allow for inserts but not deletes. This resulted in no responses being written to my Excel file until I removed protection from the sheet. Any thoughts?
06-12-2019 06:16 AM
hey @sootsie74
did you get a solution to this?
i have the same issue.
@sootsie74 wrote:I have a form connected to an Excel file in my OneDrive. I locked the sheet to allow for inserts but not deletes. This resulted in no responses being written to my Excel file until I removed protection from the sheet. Any thoughts?
03-19-2020 09:11 PM
03-20-2020 09:45 AM
@Todd_Edwards if you just use the spreadsheet connected to the form then only those who are owners of the form can see & edit it. That seems the most sensible solution. Otherwise you can save the form responses via a flow in Power Automate to a different spreadsheet that only you can access.
Rob
Los Gallardos
Microsoft Power Automate Community Super User