Using Update Item to update a Sharepoints List when an MS Form is submitted

(0) Share

Report

Posted on by SteveTaylor

Hi, I am new to Power Automate and looking for some help with the following:

I have a Sharepoint List with a list of Contacts which triggers a flow to send an email with a link to an MS Form. When the email is sent, it updates a second List and creates a row with the data from the Title column. When the MS form receives a response, I want the row on the second list to be updated with if Title data matches. I am using the following, but the error message states as per below saying the item cannot be found - it cannot match the two fields in the Lists?:

The data in the both lists and the MS form field it matches from is identical.

Error:

{

"status": 404,

"message": "Could not find list item.\r\nclientRequestId: 24eb2582-8e53-4d55-be56-695c3e2cab73\r\nserviceRequestId: 24eb2582-8e53-4d55-be56-695c3e2cab73"

}

Any assistance would be greatly appreciated.

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (3)

Report

Re: Using Update Item to update a Sharepoints List when an MS Form is submitted

Hello @SteveTaylor ,

the action needs the ID of the SharePoint item it should update, not the Forms response ID. You should check if the item with the Title exists, and if it does, use its ID to update it, as described here.

Was this reply helpful? Yes No
SteveTaylor on at

Like (1)

Report

Re: Using Update Item to update a Sharepoints List when an MS Form is submitted

@tom_riha Perfect - that has resolved it. Many thanks for your help.

Was this reply helpful? Yes No