How to update existing SharePoint records with information from Forms

[GES]

Hi all,

Hopefully you can help me.

I am currently trying to update existing SharePoint records with data coming in from a Forms response. The struggle I seem to be having is linking the Form to the SharePoint record. 

As it currently stands, the Form has two questions - 1. List the Reference ID (a designated number given to each record as part of the work chain) 2. The information that needs to be updated in SharePoint. 

The SharePoint has the ID column (unhidden) and the Reference ID (listed above) and both seem like they should be able to link together as they are consistent. The SharePoint is new so any changes required to facilitate can be made. 

I would appreciate any assistance you could provide as I'm at my wit's end! I can answer any questions and provide screen shots as needed.

Kind regards,

GES

[annajhaveri]

@GES  so i understand that you have a Reference ID column in SharePoint list and that value you can get from form, so in order to update SharePoint List Item use Get Items with filter query to get the item based on Reference ID, that way you will get SharePoint list item ID, which you can use in Update Item action to update values in existing SharePoint list item. 

[GES]

Hi @annajhaveri,

Thanks very much for coming back to me.

Would you be able to visual how you would do this? I've been attempting similar steps to the ones outlined above today and I've had no joy (flow worked but couldn't match the IDs). 

Kind regards,

George

[annajhaveri · Accepted solution]

@GES  please see below screenshot for how to configure the actions, if you are using Response Id from the form use that in Get Items - filter query, otherwise use whichever field from the form matches with the Reference ID column of your SharePoint list. Replace ReferenceID with your the column name which has Reference ID data

Please make sure the data of SharePoint List Reference ID matches with the Reference ID field value you are using from the form in filter query to make this work.

[GES]

Thank you very much @annajhaveri