4 Solutions For Excel File Is Locked Error In Power Automate
![4 Solutions For Excel File Is Locked Error In Power Automate](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-featured.jpg)
The Power Automate error message file <filename> is locked for shared use by <user email> is caused by attempting to update SharePoint file properties after performing an Excel action. I have encountered this message many times and I will share 4 methods to deal with the locked file error.
Table of Contents
β’ Introduction: The Store Inventory Report Automation
β’ Generate The Excel File Locked For Shared Use Error Message
β’ Solution #1 - Loop Until The Excel File Is Unlocked
β’ Solution #2 - Delete The Excel File & Bypass The Shared Use Lock
β’ Solution #3 - Copy Excel File To Temp Folder To Read The Rows
β’ Solution #4 - Write A Filled-In Excel Template To Another Folder
Introduction: The Store Inventory Report Automation
An automation reads the rows of an Excel table and updates the file properties in SharePoint. When the automation is run the following error message appears: the file <filename> is locked for shared use by <user email>.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-1-1-1024x780.jpg)
Generate The Excel File Locked For Shared Use Error Message
The best way to understand why the Excel file is locked for shared use error message occurs and prove the solutions will work is to recreate the error message in a simple flow.
Open SharePoint and make a new document library named File Lock Testing. Then create a new blank Excel file titled Store Inventory List.xlsx.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-15.jpg)
In the Store Inventory Excel file, create a new table named tblInventory. Setup the table and populate its data as shown in the image below.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-16.jpg)
Go to Power Automate and create a new instant flow. Add the following actions.
- Excel – List Rows Present In A Table
- SharePoint – Update File Properties
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-0-679x1024.jpg)
Save the flow and then try to run it. The flow run will fail with the error message the file <filename> is locked for shared use by <user email>. This is because the Excel actions locks the file making it impossible for SharePoint to update its file properties.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-1-1024x780.jpg)
Solution #1 – Loop Until The Excel File Is Unlocked
An Excel file will become unlocked up to 10 minutes after the file is closed. We can incorporate a loop into the flow to check when the file is unlocked and finish updating the file properties.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-4-scaled.jpg)
When the flow encounters a locked Excel file it will throw an error. Configure the Run After settings for the Condition action to ensure the flow continues to run whether the update file properties action succeeded or failed.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-20.jpg)
The condition action checks the update file properties outputs for status code 400. Status code 400 means the file was locked for shared use. If the file was locked for shared use the flow will delay for 30 seconds before it goes back to the start of the loop. Otherwise, the loop will end.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-2-1.jpg)
Result: Loop Until The Excel File Is Unlocked
When we run the flow we can see the Do Until loop executes its actions 20 times before succeeding. The flow retries the update file properties action several times and leaves the loop once the Excel file becomes unlocked.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-3.jpg)
Solution #2 – Delete The Excel File & Bypass The Shared Use Lock
If we want to delete an Excel file that is locked there is a simple solution. We can tell SharePoint to ignore the file lock and delete it anyways.
To do this add a SharePoint – Send An HTTP Request action to the flow. Select the Site Address and use the POST method.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-6.jpg)
Copy and paste this Uri into the flow action.
_api/web/Lists/GetByTitle('File Lock Testing')/GetItemById(1)/recycle
And supply this key-value pair to the headers.
Prefer | bypass-shared-lock |
Result: Delete The Excel File & Bypass The Shared Use Lock
When we run the flow action it deletes the Excel file from SharePoint while ignoring any potential files locks.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-7.jpg)
The Excel file no longer appears in the File Lock Testing document library.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-17.jpg)
Solution #3 – Copy Excel File To Temp Folder To Read The Rows
There is no need to wait for an Excel file to become unlocked when we only need to read the rows. We can copy the Excel file to a temporary folder, read the rows of the Excel file, and delete it when we are done.
Go to the File Lock Testing SharePoint document library and create a new folder named Temporary Files.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-13.jpg)
Modify the flow to update the Store Inventory Excel file status to In Progress. Then copy the file to the temporary folder. Read the rows from the Excel file and delete the file when done. Change the final status of the original Excel file to Succeeded.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-8a-scaled.jpg)
An expression is required to get the the Excel table identifier.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-9.jpg)
Use this expression in the Table field of the Excel – List Rows Present In A Table Action.
first(body('Filter_array:_Name_eq_tblInventory'))?['id']
Result: Copy Excel File To Temp Folder To Read The Rows
Run the flow to see the result. The flow successfully bypasses the Excel file lock by copying it to a temporary folder and reading the copied file’s rows.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-10-956x1024.jpg)
Solution #4 – Write A Filled-In Excel Template To Another Folder
The final example is useful when we want to fill-in an Excel template without locking the file. We can copy the Excel file to a temporary folder to perform updates. Then copy the updated file to an output folder and delete the temporary file.
Add another folder named Output Files to the File Lock Testing document library.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-14.jpg)
Update the flow we made for Solution #3 to look like this. An Excel – Update A Row action is substituted for the Excel – List Rows Present In A Table Action. And we add an additional SharePoint – Copy File action to move the completed file to the Output Files folder.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-18-scaled.jpg)
Result: Write A Filled-In Excel Template To Another Folder
Give the flow a test run to ensure it works.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-19.jpg)
The newly updated Excel file is created in the Output Files folder and its status property is changed to Succeeded.
![](https://www.matthewdevaney.com/wp-content/uploads/2023/11/powerautomate-excelfilelock-11.jpg)
Did You Enjoy This Article? πΊ
Subscribe to get new Power Apps & Power Automate articles sent to your inbox each week for FREE
Questions?
If you have any questions or feedback about 4 Solutions For Excel File Is Locked Error In Power Automate please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion.
What a timely article! I’ve been working on several flows that grab an attachment from email, save to OneDrive, and then create a table. I get getting “locked” issues and realized that I need to give time between saving to OD before editing the file. So I set all the flows to wait between 15 minutes. However, I never considered the looping through until the file is unlocked. Genius. Thank you again for a great and resourceful article!
Bob,
Iβm glad this came at the proper moment for you. This error has caused me great pain. And I have trouble fathoming why the connectors were built in this way.
Anyhow, the community always finds a way doesnβt it?
Hey Matthew. Nice article. There is a Solution #5 tho: if you are (hopefully) working on a solution, you can create a child flow that performs whatever you want to do with the Excel file. The child flow will keep kicking retries until the lock is gone. Of course your flow will take longer to fully run.
Thanks for #2 and bypassing the lock, had no idea!
Pablo,
Yes, I agree. The child flow could also substitute for #1. The only advantage of doing it the way I described is targeting the specific error code 400. But it’s not really a huge deal.
I suppose the user would need to have a license since child flows are premium. I have a license and I love them.
The child will also generate a failed flow instance over and over until it succeeds. I guess you could minimize the retries to cut down on those dreaded pink lines.
Terrific !!!
George,
I’m glad you think so π
I assume I could adapt this for a Word document in a Sharepoint library, too? I have a flow that is updating a metadata field and I get frequent notifications that this step in the flow has failed because the Word document is locked for editing.
Debra,
Yes, this technique can be used for any type of document. Excel is just the most common. Word is the 2nd most common π
In solution #4, if I have the file already open, the action “Update file properties: Status in progress” will fail
RealSlimShady,
It’s OK to use a blend of these strategies. Look at step #1 for how to check if the file is currently locked. Then follow-up with strategy #4.
Hi Matthew – Thanks for the awesome post. I know it’s been mentioned in prior posts about looping through and waiting for a OneDrive file to unlock… Just wondered if you have come across a solution for OneDrive use cases similar to your Sharepoint (HTTP call) solution, where one could possibly make a call to immediately delete a OneDrive file versus looping and waiting until the lock is gone?
Jorge,
I think you have misread my post. #2 ignores the file lock and deletes immediately.
Thanks a lot, it was killing me.
Larisa,
It was killing me too. So I’m glad the article was a painkiller for you π
What a nice article!!, I have a problem with solution 1, because i don’t know how to define the variable status in the condition, it would help me a lot.
Thanks for the help.
Yes! Everything else in this post is spelled out except that step. This isn’t an option from dynamic content.
Nate,
The status will still appear if the flow action fails even if there is not dynamic content. You could target it by manually writing an expression.
outputs(‘flow_action_name’)?[‘body’]?[‘status’]
Thank you for this article!! I spent a day and a half racking my brain on how to address this issue until finally I found this article. You’re a lifesaver!!
Kendra,
You’re welcome. I also spent 1/2 a day racking my brain too. Then I wrote it down because I knew it would definitely help others.
Hi Matt, thanks for this great article but i am stuck in condition status code eq 400. i dont see or cant find that in my list of dynamic contents
Thanks
Ola,
See Approach #1. Get the status from the “Update file properties: Store Inventory (Excel)” action.
That dynamic content does not exist. I’m using Move file. I don’t have status as an option.
Nate,
The status will appear if the flow action fails and you could target it by manually writing an expression.
outputs(‘flow_action_name’)?[‘body’]?[‘status’]
Using the outputs(‘Update_file_properties_5’)?[‘body’]?[βstatusβ] results in a “The expression is invalid error message.” I’m having the same issue as everyone else in that the Status is not available as dynamic content. Yes, I see that status appears when the flow fails, but that does not help me add Status to the condition. Any other suggestions? Why does status appear as dynamic content for you, but not for others? π
Well, suddenly the expression is valid!! Probably some errant character somewhere. Thank you for this solution!!!