cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pladavm
Level 8

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
45 REPLIES 45
Community Support Team
Community Support Team

Re: Cannot write file to filesource. File is being locked.

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.
pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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. 

bldial
Level: Power Up

Re: Cannot write file to filesource. File is being locked.

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

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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. 


bldial
Level: Power Up

Re: Cannot write file to filesource. File is being locked.

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

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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

anthonyfz
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

 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. 

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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

nadavcohen
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

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

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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

vishchandra
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

Is this still not solved?

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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

nadavcohen
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

please solution???????? 

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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

Administrator
Administrator

Re: Cannot write file to filesource. File is being locked.

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
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
vishchandra
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

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

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

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

pladavm
Level 8

Re: Cannot write file to filesource. File is being locked.

Hi @GabrielStJohn  any update from your colleagues?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,538)