Editing a response in Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-916169%22%20slang%3D%22en-US%22%3EEditing%20a%20response%20in%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-916169%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%26nbsp%3B%20Is%20it%20possible%20to%20edit%20a%20response%20once%20submitted%3F%26nbsp%3B%20I%20need%20to%20add%20more%20detail%20(contact%20details)%20on%20the%20form%20which%20has%20been%20submitted.%26nbsp%3B%20Tried%20to%20do%20in%20Excel%20but%20it%20wont%20update%20the%20fields%20in%20the%20response.%26nbsp%3B%3C%2FP%3E%3CP%3EThx%20L%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-916169%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-916471%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20a%20response%20in%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-916471%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20Liz%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F426762%22%20target%3D%22_blank%22%3E%40Liz_F%3C%2FA%3E%2C%20no%20you%20can't%20edit%20the%20response%20directly%2C%20but%20what%20you%20can%20do%20-%20and%20we%20do%20this%20a%20lot%20in%20my%20company%20-%20is%20to%20use%20Flow%20to%20save%20the%20response%20to%20a%20SharePoint%20list%20which%2C%20as%20well%20as%20having%20the%20columns%20for%20the%20answers%20in%20the%20response%2C%20can%20have%20a%20lot%20of%20other%20columns%20as%20well%20which%20you%20can%20then%20edit%20and%20save.%26nbsp%3B%20A%20simple%20example%20is%20below%20(and%20assumes%20responses%20will%20be%20coming%20from%20outside%20the%20organisation%2C%20hence%20the%20request%20for%20the%20email%20address.%20Otherwise%20you%20could%20grab%20the%20responder's%20details%20directly%20via%20an%20Office%20365%20Users%20action%20in%20Flow).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%20Come%20back%20with%20any%20questions%20about%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3C%2FP%3E%3CP%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Flow%20Community%20Super%20User%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22FormstoSPList.png%22%20style%3D%22width%3A%20645px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F137826iFA7103DA68937F12%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22FormstoSPList.png%22%20alt%3D%22FormstoSPList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1219058%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20a%20response%20in%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219058%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20wanna%20add%20in%20the%20flow%20as%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20submitted%20a%20new%20form%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20newly%20submitted%20form%20will%20send%20an%20email%20for%20approval%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20approved%2C%20the%20form%20is%20no%20issue%2C%20but%20if%20not%20approved%20I%20wanna%20the%20respondent%20to%20edit%20and%20resubmit%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1219282%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20a%20response%20in%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219282%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F577981%22%20target%3D%22_blank%22%3E%40Vincent87%3C%2FA%3E%26nbsp%3Bas%20I%20said%20in%20my%20previous%20post%2C%20it%20is%20not%20currently%20possible%20to%20edit%20a%20response%20after%20it%20has%20been%20submitted.%20There%20is%20a%20UserVoice%20request%20for%20this%20which%20you%20can%20vote%20for%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F37971121-edit-response%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F37971121-edit-response%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOther%20than%20that%20you%20would%20need%20to%20use%20a%20flow%20to%20save%20the%20response%20to%20SharePoint%20and%20start%20the%20approval.%20If%20the%20outcome%20was%20Reject%20then%20an%20email%20would%20be%20sent%20by%20the%20flow%20to%20the%20responder%20with%20a%20link%20to%20the%20SharePoint%20item%20asking%20them%20to%20edit%20their%20response.%20You'd%20need%20a%20column%20in%20your%20list%20for%20Status%20which%20would%20be%20initially%20Pending%2C%20would%20then%20be%20set%20to%20Approve%20or%20to%20Resubmit%20depending%20on%20the%20outcome.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20the%20user%20edited%20their%20response%20in%20the%20SharePoint%20list%20they%20would%20need%20to%20set%20the%20Status%20to%20Resubmitted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20would%20then%20need%20a%20second%20flow%20that%20would%20trigger%20when%20an%20item%20was%20created%20or%20modified%20and%20would%20have%20a%20trigger%20condition%20of%3CBR%20%2F%3E%3CSTRONG%3E%40equals(triggerBody()%3F%5B'Status'%5D%2C'Resubmitted')%3C%2FSTRONG%3E%20so%20it%20would%20only%20fire%20if%20the%20list%20item%20had%20a%20status%20of%20Resubmitted%20and%20would%20send%20the%20approval%20to%20the%20approver%20and%20update%20the%20Status%20column%20etc..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20it's%20moderately%20complex%20if%20you're%20not%20used%20to%20flows%20in%20Power%20Automate.%20But%20come%20back%20with%20any%20questions%20or%20problems.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi!  Is it possible to edit a response once submitted?  I need to add more detail (contact details) on the form which has been submitted.  Tried to do in Excel but it wont update the fields in the response. 

Thx L

3 Replies
Highlighted

HI Liz @Liz_F, no you can't edit the response directly, but what you can do - and we do this a lot in my company - is to use Flow to save the response to a SharePoint list which, as well as having the columns for the answers in the response, can have a lot of other columns as well which you can then edit and save.  A simple example is below (and assumes responses will be coming from outside the organisation, hence the request for the email address. Otherwise you could grab the responder's details directly via an Office 365 Users action in Flow).

 

Hope that helps. Come back with any questions about this.

 

Rob

Los Gallardos
Microsoft Flow Community Super User

 

FormstoSPList.png

 

 

 

Highlighted

@Rob Elliott 

 

If I wanna add in the flow as below:

 

When submitted a new form

 

the newly submitted form will send an email for approval

 

If approved, the form is no issue, but if not approved I wanna the respondent to edit and resubmit again.

 

 

Highlighted

@Vincent87 as I said in my previous post, it is not currently possible to edit a response after it has been submitted. There is a UserVoice request for this which you can vote for at https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggest...

 

Other than that you would need to use a flow to save the response to SharePoint and start the approval. If the outcome was Reject then an email would be sent by the flow to the responder with a link to the SharePoint item asking them to edit their response. You'd need a column in your list for Status which would be initially Pending, would then be set to Approve or to Resubmit depending on the outcome.

 

When the user edited their response in the SharePoint list they would need to set the Status to Resubmitted.

 

You would then need a second flow that would trigger when an item was created or modified and would have a trigger condition of
@equals(triggerBody()?['Status'],'Resubmitted') so it would only fire if the list item had a status of Resubmitted and would send the approval to the approver and update the Status column etc..

 

So it's moderately complex if you're not used to flows in Power Automate. But come back with any questions or problems.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User