Unanswered

Unable to get a Microsoft form to create new submissions or update old submissions in SHarepoint when a condition is added for updating a previous form submissions.

(0) Share

Report

Posted on by jabrehmer

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

@grantjenkins

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

jabrehmer 13 on at

Like (0)

Report

{ "status": 404, "message": "Could not find list item.\r\nclientRequestId: f4c9243e-bd62-4596-9fea-a3defef8edc3\r\nserviceRequestId: f4c9243e-bd62-4596-9fea-a3defef8edc3" }

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.

Was this reply helpful? Yes No
jabrehmer 13 on at

Like (0)

Report

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.

Was this reply helpful? Yes No