Edit response after submission

[TOnymcgra]

with the new option to give users the capability to "Edit response after submission" is there any way to track the changes and the number of times a responder has edited their response. Is there an audit trail for the Form owner to see if and when edits have been made to a response?

[#2]

Hi @TOnymcgra 

There is no way to know the changes made each time. The form owner can determine whether a response has been modified by checking whether the 'Last modified time' has a value in the Excel worksheet which represents the last modification time of this response.

[#3]

How can the user edit the submission? I'm not seeing that new functionality.  @TOnymcgra 

[#4]

@helloitscourt you need to check the checkbox in Settings.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

[#5]

@helloitscourt 

... -> Settings -> Options for responses -> Allow respondents to edit their responses.

[#6]

Thanks! I did that, but still not seeing how I can update the form after submission. @DingkunXie 

[#7]

@helloitscourt 

Click "Submit" button to submit the response.

In Thank You page, click "Save and edit later" button, form taker will be prompted to sign in.

After sign in, form taker will be redirected to Forms portal and see a Form Card shown under Recent tab.

Click the card, the response form will be opened, and click "Edit response" button to edit and resubmit the response.

[#8]

@DingkunXie 

If someone starts editing his response and doesn't resubmit before the deadline, is his original response still submitted?

[#9]

@DingkunXie 

I cant work out how to get the edit option available to me, any advice please ?

[#10]

Yes, there would be no change to the original response submitted.

[#11]

@Lauren88 

Responders can only edit their responses if the designer has enabled the setting -

[#12]

@DingkunXie 

This option is unavailable if you create the form from Excel in Microsoft 365

I choose create the form through Microsoft 365 to link the excel workbook to my form.

If you know a different method to do this please let me know, my goal is to have a form that anyone in my company can see the responses.

Regards

[#13]

One possible solution is to create a form in OneDrive for Business. Once you've created the form, navigate to the Responses tab and click 'Open in Excel' to view the responses in an Excel file. From there, you can share the file with anyone you'd like.

[#14]

I have a question.  I'm trying to create a form for each of my team members to track their goals, which means they will be going into the form all year with different aspects of their goals and possibly adding updates to others previously documented via the form.  I had thought that letting people go in and edit the response would give me the opportunity to let them edit any submission.  I just want to confirm that function only works for the first form submitted.  If they go back in, it just takes them to the form they previously submitted and won't let them go to a different aspect of the form.  I have a couple ways I can make this work if this is not an option, but it requires them to input more information.  

Thanks!

[#15]

just want to confirm that function only works for the first form submitted

I am not sure I understand what you need.
https://techcommunity.microsoft.com/t5/microsoft-forms/want-to-create-a-form-for-hiring-process-but-...

I guess you may take above link for reference.

[#16]

That link doesn't work. What I'm trying to do it make a form that lets my associates track information about their goals. Say they have 10 goals. The go into the form to document each one, so that each has a line in the data sheet. They want to go back and add updates to several of those goals. I think the only way they will be able to do that is to actually update the data sheet (which I will give them access to), or have them reenter fields so that we can associate the update line on the data sheet with the goal. I don't think that there is any other way to do it. I'm just trying to find an easier way to track everyone's work where they have all their information in one place. Just typing stuff into a Word doc doesn't sort anything. I've always felt forms was a great way to enter data to a sheet in an easier fashion.

[#17]

They want to go back and add updates to several of those goals. I think the only way they will be able to do that is to actually update the data sheet (which I will give them access to),


I think what you need is to edit an exist row as approved one applicant from your description.

If you share some specific data,we can have further discussion.

[#18]

@DingkunXie 

In Power Automate, there is an action Microsoft Forms > Get response details, whose outputs includes "submitDate", which changes upon editing a response; and I have built some Flows to detect if any response was edit by checking this value.

This worked when I last use the Flows in Jun 2024; now in Sep 2024 I just copied the Flows for another Form, but found "submitDate" is unchanged upon editing a response; meanwhile, the 'Last modified time' column in the Excel worksheet generated through Forms is updated according to the editing time. Has anything changed in the past 3 months in regard to Power Automate?

[#19]

I will check with the Product Team regarding this behavior change and get back to you.

[#20]

I have confirmed with the product team that there have been no changes regarding the mentioned behavior. The feature owner states that the submission date has remained the same since the feature's inception, with only the last modified time being updated. It is possible that the behavior stems from a Flow update, which might have altered the submission date initially and then reversed it. However, this has not been confirmed by the Flow product team.