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
Solved! Go to 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 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.
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
@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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
77 | |
26 | |
20 | |
16 | |
16 |
User | Count |
---|---|
145 | |
44 | |
44 | |
33 | |
30 |