Power Platform Community Forum Thread Details

Hi all,

I'm pretty new to PA, so I'm basically scrabbling at code until it works.

At the moment, I'm working on a sharepoint integration. The user hits a button, it copies a folder to a different library, deletes the old one, sends an email the people who need to know, and updates an excel sheet in the folder with details about the update.

All of it works except the excel sheet part.

The sheet has two tables. One stores basic data (order number, customer name, etc) called "Basic_Detail". The second is a list where every action adds a row and adds a username and timestamp called "Order_Updates".

At the moment, I have the process check the file out, run the two steps, then check it back in. I was hoping this would stop the "locked for shared use" errors I was previously getting, but all it seems to have done is changed it from the old error to this:

{
 "status": 409,
 "message": "Graph API is unable to acquire or refresh a lock on the file because it is already locked. Please close edit sessions and try again.\r\nclientRequestId: b1de24a7-b940-4ed6-b87f-9daadb9f5abb\r\nserviceRequestId: 8b1ee0a5-6316-4902-b6c1-3f8a2b85d061",
 "error": {
 "message": "Graph API is unable to acquire or refresh a lock on the file because it is already locked. Please close edit sessions and try again."
 },
 "source": "excelonline-ukw.logic-ase-ukwest.p.azurewebsites.net"
}

The problem being that the process that has it locked is the flow itself. I've been trying to find ways around it but gotten nowhere with my limited understanding.

The problematic part flow as it stands is below (the flow itself is much larger, but the rest all works). Previously, I had it more or less identical, without the checkout/checkin steps. Only thing I've blanked are the company name.

Any help on this one would be appreciated, as I really need to be able to perform both updates as part of this process.

Flow Error.jpg