File "Cannot be moved because it is in locked mode"

[alexlee1]

Tried to upload a excel file to sharepoint folder. After read the email addr in the excel file and get the approval from email owner, I am trying to move the excel file to anther folder, but the move action failed.

If I don't read the excel content, the excel file can be moved successfully. Is the any lock from system and how to solve it.

Any suggestion, thanks.

{"status":400,"message":"File 'Shared Documents/Submitted/xxxx.xlsx' cannot be moved because it is in locked mode.\r\nclientRequestId: 2e86bxxxxxx\r\nserviceRequestId: 2e86bbxxxxxx"}

From the below, there is no user check out the file.

 

[yashag2255]

Hi @alexlee1 

This error occurs if the file is open in edit or read mode in the browser. Can you close the file and try once? Also, there could be a chance that one of the team members that have access to the file may have it open in  the browser and it will pop the same error. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[alexlee1]

@yashag2255 Many thanks. There is no other team member visit this site at all. And I just upload the file without opening. 

Any suggestion, thanks.

[Paulie78]

@alexlee1 you can use solution that I wrote up on this post:

https://powerusers.microsoft.com/t5/Building-Flows/Power-Automate-Handling-Document-is-locked-for-sh...

Create a loop that waits for the file to become free and then executes the action. If you get stuck reach out and I will help you put it together.

[alexlee1]

@Paulie78 Thanks for the answer. Tried to follow the suggestion, but 'update file property' get error and stop.

The "message" is 

{
"status": 400,
"message": "The file \"https://cloudxxx.sharepoint.com/sites/xxxx/Shared Documents/Submitted/xxxxxx.xlsx\" is locked for shared use by xxxx@xxxxxxx.\r\nclientRequestId: 2017b....\r\nserviceRequestId: 2017bb...."
}

The email addr is from myself, but I only upload without opening.

Also tried to change the setup of 'update file property', when run get anther error.

When trying to delete the file from web UI, it sometime said is locked. Is there any way to force unlock. 

Also tried 'check in'/'discard check out'/'stop sharing...' functions in sharepoint, still not work.

Any suggestion, thanks.

[Paulie78]

Yes, you need to configure the step after 'update file property' to run even if 'update file property' failed. Take another look at the screeshot ( https://tachytelic.imgbb.com/ ) :

So the "Set Variable" step needs to be configured to run even if "Update File Property" failed. In this way the loop will continue until it no longer reports that the file is locked.

[larspeterson]

I did a slight variant that retries until it is able to use the move file command that I thought some might find useful. Same as mentioned, except I only update the IsDocumentLocked variable upon a success of move file and I keep delaying by two minutes until that file moves. I put in some error handling so it lets me know if it doesn't move in the end as well by putting everything in a scope block.