Power Platform Community Forum Thread Details

Hi All,

I'm trying to create a flow that will update an existing row (from previous form response) that's triggered by a form submission.

Currently I've set up my form to store information into a SharePoint excel file. However, a large majority of the time questions being answered require updates by the form submitter. I don't want the form submitter to have to access the master excel file to update their answers. The form is also set up in power automate relay all the answered questions to the submitter from an email.

A simplified version of the form updated into the excel would look something like this:

The goal would be for the form submitter to be able to update the "status" and/or "notes" directly from the form.

I found a similar question posted/solved:

https://powerusers.microsoft.com/t5/Building-Flows/Form-Submission-Update-Row-in-Excel/m-p/286693#M29910

In this case, I'm not sure how the creator was able to give a unique identifier to the submitter ("case reference" in the post). I was thinking I might be able to use the date and time as reference data for the form submitter to connect to their original response.

I apologize if this is confusing. I'd appreciate any help. Thanks!

Categories:

General topics

Hi @Haluwasa

I don't think that's possible. Once the form is submitted, then there isn't any way to update it.

There are 2 potential workarounds:

Save the information in SharePoint and provide a view with the fields that the user can update and filter the list by the entries that the user inserted via Form.
Create another form for the user to submit changes. For this, you would need the user to submit some sort of identifier or find a way to link back to the original response so that you can update the Excel.
Create a PowerApp that shows the information and enables the user to edit the information that he/she inserted

Please let me know if any of these would work for you

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel