Hello, I have a flow setup such that a Microsoft form is submitted & the results of the form are added as a row into a table in a spreadsheet, an email is then sent to the next person that will have to execute their action to keep the project moving forward.
In that email, a link is provided for the next action which is another form, that form gets submitted, data enters the table & the process keeps moving forward like this.
Very linear until someone skips a form & submits a different one applying to the previous or next row which is not what I want.
How I see it working:
Each row has a row ID specified as the first column in the table, row ID 1-xx. As the table fills with new project data, I manually enter a row ID for each project.
The first question in each form response asks for the row ID, so that the flow can loop through the rows until the row ID matches the row ID submitted in the form, then updates that row of empty cells instead of just "adding another row to a table". In this case rows might be skipped & the data can be entered with a form response at a later date using its row ID.
How do I do that?
