You’re offline. This is a read only version of the page.
Hi,
I have a list in SharePoint. When Form A is submitted, it creates a new row with all the info from the form. Now this info gets approved but at the same time approver requests more information in the email. So I created another Form B and added the Form B link in the approval email. Now I am stuck on how to update the existing row with this new information that was provided in the Form B. Both the row and the form B have ID so what I need to do is match the ID and then update the existing row with this new info. There would only be 1 row for any ID.
thanks in advance for your inputs.
Bhavna
All the data in these columns (except for the last two highlighted) is being displayed by the Form A. When approver approves this information, a link to Form B is sent to the requestor so he can provide additional information that needs to be displayed in the highlighted columns.
The Item code would always be unique. So I was thinking, maybe the flow checks the item code in the Form B and looks for the row in the Sharepoint list and then updates the data for highlighted columns (this data is being asked in Form B)
In the following flow, I have included the link to the Form B in the approval email. But I don’t know how to get the information displayed in particular columns. The only matching information would be the Item Code
Hi @BhavnaAnand,
Normally you can use a Get Items actions with the Filter Query field to find a matching row. Can you share a screenshot of your current flow setup, this way we can provide an example based on your current setup.
On a side note, the out of the box ID is a system wide column which Microsoft manages and increments. Each list will have it's own ID per row, and they are unrelated to each other. There is a change of mismatches if you use the ID to match in both lists (if you for example delete an item, these IDs will already be out of 'sync'). So, you might want to think about create your own custom identifier column for the matching?
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (