Microsoft.SharePoint.SPFileLockException

[DavidLozzi]

I have used the template for saving email attachments to SharePoint library. I modified it to target a specific email I get weekly from ops, which has an Excel file attached. All I want to do is upload that attachment to the same SP Library with the same file name. I have a separate flow listening on that SP library for modified files, and then it parses the Excel file for me and alerts me to my content. 

Today, I got the email and the flow ran, but I got this error. I haven't touched the existing file in about a week.

{

"status": 423,

"message": "The file https://twodegrees1.sharepoint.com/teams/LozziPlayground/Shared Documents/test-Meaningful Work Metrics v2 Dashboard.xlsx is locked for shared use by david.lozzi@slalom.com [membership].\r\nclientRequestId: 0fc5f713-34e5-4cc7-a40d-894584d6aa58\r\nserviceRequestId: ffaac69e-e0ac-8000-a56d-17f91e9e4597;ffaac69e-b0b4-8000-a56d-1b7141aee703",

"source": "https://aaa.sharepoint.com/site/url/_api/web/GetFolderByServerRelativePath(decodedUrl=@p)/files/AddU...'",

"errors": [

"-2147018894",

"Microsoft.SharePoint.SPFileLockException"

]

}

Is there a way to force an overwrite or unlock the file? If I try to delete the file through SP it errors similarily

(I appended test- to the file name, both flows know about the new file name)

When I go into the Excel file, I see that I am also editing the file.

Which is leading me to believe that Flow hasn't let go of it, over a week ago... It's been a week, I haven't touched it, I've rebooted my laptop numerous times, it's gotta be flow holding on for dear life...

[v-bacao-msft]

Hi @DavidLozzi ,

It seems that an action in Flow caused the file to be checked out. Could you manually check it in SharePoint library?

When the action inside Flow edits the file, the connection account will check out the file for change.

You could turn this Flow off and the file will be checked in automatically.

Or you could use “Send HTTP request to SharePoint” action to check in the file.

Please check this thread and see if it helps:

https://powerusers.microsoft.com/t5/Flow-Ideas/Allow-to-check-in-check-out-and-publish-files-in-a-Sh...

Best Regards,