Cannot write file to filesource. File is being locked.

[pladavm]

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

[v-yamao-msft]

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

[pladavm]

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]

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

[pladavm]

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]

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

[pladavm]

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

[anthonyfz]

 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]

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

[nadavcohen]

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

[pladavm]

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

[Anonymous]

Is this still not solved?

[pladavm]

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

[pladavm]

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

[nadavcohen]

please solution???????? 

[pladavm]

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

[GabrielStJohn]

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

[Anonymous]

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]

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

[pladavm]

Hi @GabrielStJohn  any update from your colleagues?