You’re offline. This is a read only version of the page.
13
I am currently working on creating a link between a Microsoft Form and a Sharepoint list, with a condition to directly update information in the custom SharePoint list if the Part Number in the new submission already exists in the list. I want to use SharePoint rather than the standard excel sheet that the Microsoft form defaults to.
This would allow entries for the same number to update the information in SharePoint rather than populating a brand-new row as it does in excel.
I have created my list, my form, and I have tried a couple custom flows in Power Automate. Each flow that I have created will run successfully, however, the list in SharePoint remains empty. I'm not sure if the issue is permissions based, or if my flow is incorrect. If this is something you could help with, I would be very grateful. I appreciate your time and consideration.
I'm able to get it to populate the sharepoint list when I run the "create items" action directly following the "get response details" action. However, when I attempt to add the condition to check the Part Number and "Update items" if it is a duplicate, or "create items" if it is unique, it "successfully" runs, but fails to either update a previous item or create a new item.
I tried switching the condition from using a filter query to this array filter as suggested in this previous post linked below, however this also failed in the same manner as my previous attempt.
https://powerusers.microsoft.com/t5/Building-Flows/Update-SharePoint-List-existing-line-item-from-form-entry-using/m-p/2060664#M227658
Below is my flow as it currently exists
This is an updated version of the flow which runs "successfully" every time but fails to create new Sharepoint list items or update existing items.
The error message indicates that Power Automate was unable to find a specific list item. The "status" field of the message shows that the error was a 404 error, which is a common HTTP error code that indicates that the requested resource could not be found on the server.
The "message" field of the error provides more information, indicating that the specific list item that Power Automate was looking for could not be found. The error also includes two unique identifiers: "clientRequestId" and "serviceRequestId". These identifiers can be useful for troubleshooting the issue with Microsoft support if further assistance is needed.
In summary, the error message suggests that there was an issue with retrieving a specific list item in Power Automate, possibly due to incorrect input or a problem with the underlying SharePoint list.
^ error I am consistently getting in the current configuration.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
