cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pladavm
Helper V
Helper V

Cannot write file to filesource. File is being locked.

I have created several flows to update rows in Excel worksheet but I get this error a lot randomly, why does it say my file is locked? Even after I close the browser.

Details

Start time
Jun 29, 12:29 PM (2 minutes ago)
Duration
00:00:04
Status
Failed
Error
Action 'Insert row' failed
Error Details
Cannot write file to filesource. File is being locked. clientRequestId: 7f78bd52-b9ec-4ade-a3d1-d955aafdf79c serviceRequestId: 7f78bd52-b9ec-4ade-a3d1-d955aafdf79c;7f78bd52-b9ec-4ade-a3d1-d955aafdf79c;7f78bd52-b9ec-4ade-a3d1-d955aafdf79c
55 REPLIES 55
v-yamao-msft
Community Support
Community Support

Hi @pladavm,

 

I made a simple test to insert row in Excel, and it worked without any issues.

 

What’s the current situation on your side? Have you shared the Excel file with others? If yes, please make sure they are not opening the file when you are running the flow. If now, I would suggest you recreate the flow to see if it will work.

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

The file is not shared with anyone, there is no reason it should be locked I am definitely not in it. It happens whenever a flow is run to add row to the excel sheet future flows do not work because the "file is locked" for like 10 - 15 mins at a time. 

Any resolution to this.  I'm having a similar issue.

Use Google Sheets, no issue when using this.

The MS Flow team doesn't understand this Excel issue, I have given up explaining to them. 


Thanks for the suggestion!  I suspected this was an issue with no current resolution.

@v-yamao-msft reraising this again because it is still not resolved

 I am also having this problem - flow step to add a row in an excel table. Then Flow locks that document for anywhere between 10 and 30 minutes and any subsequent flows or manual attempts to edit the file, fail. 

@v-yamao-msft another one, why do you not respond?

nadavcohen
Regular Visitor

having the same issue here.. rendering the flows i worked on useless.. any news about a soution? 

Microsoft really need to solve this! So many people affected. 

Anonymous
Not applicable

Is this still not solved?

@Anonymous Google Sheets doesn't have this issue, I am not sure how to draw Microsoft attention to this thread....still an issue. 

@v-yamao-msft please attend to this thread, number of us are waiting...

please solution???????? 

You need to get Microsoft to bring attention to this thread. I tried but couldnt. You try?

GabrielStJohn
Microsoft
Microsoft

Hey, @pladavm!

Thank you for posting on the Microsoft Flow Community! I would be happy to bring in some more help to see if they can offer you some assistance to resolve this issue!

 Thanks Again!

-Gabriel

Microsoft Flow Community Manager

 

 Hey, @v-bacao-msft@v-micsh-msft!

Would you be able to assist @pladavm in resolving this issue? Please offer all the insight that you can as this issue has been standing for some time now. 

 Thanks in advance!

-Gabriel

Microsoft Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Anonymous
Not applicable

I was able to reslove this by doing the following steps.

 

1. Close all the PowerApps tabs

2. Re-Authenticate/Sign Out and Sign back In again

Hi @Anonymous, yes this is a temporary fix but not a permanent solution as it will lock again. 

Hi @GabrielStJohn  any update from your colleagues?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,995)