Hello,
I'm having a bit of a frustrating issue with the beginning of one of my flows that runs off of a PowerApps connector.
In the beginning of my flow I need to "check out" a document in Sharepoint, and I have built the flow so that if it cannot checkout the file it tries a different backup file, then a second backup if that fails.
Beginning of flow. Check Out is problem actionWhen this flow runs from PowerApps as intended this step runs totally fine every time, however occasionally I recieve requests from users who need me to manually resubmit the run prompted by their PowerApps request- this is where the trouble begins.
About 70% of the time I resubmit the flow the documents immedietly lock up giving the error that they are "locked for shared use" by me. I have done a lot of testing and before resubmitting the run the documents are not locked, and can check in and out just fine. However the moment I resubmit and the flow tries to check them out all 3 documents become locked (even if I try to manually check them out on the Sharepoint page).
30% of the time I resubmit they check out just fine.
This is incredibly frustrating and I would really appreciate if anyone has suggestions.
To fix I have tried:
-putting a delay after each failed attempt
-turning off the retry attempts in settings of "CheckOut"
-turning off asynchrous pattern in settings of "CheckOut"
Ex. of error :
{
"status": 400,
"message": "The file https://******************************/Template2.xlsx is locked for shared use by **me**@****.com [membership].\r\nclientRequestId: 642c478b-3294-4ccc-a9e6-2e2ba8ed46d3\r\nserviceRequestId: 642c478b-3294-4ccc-a9e6-2e2ba8ed46d3"
}
