cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Excel online business connector locks file and stops subsequent processes

Hi, 

When using the excel online business task in a flow, the link to the excel file seems to lock it. 

That is, in related flow steps that refer to the same excel document, I receive the error message

"The file is currently checked out or locked for editing by another user."

... and cannot proceed with this task as an error is triggered. 

Is there any way how to overcome this locking issue?

Best regards, 

Ludwig

1 ACCEPTED SOLUTION

Accepted Solutions

Hello Kris,

Many thanks for your response and the idea provided.

I tested something similar but noticed that the file is still locked and prevents me updating the data.

So, I modified my flow and created two additional steps

Step 1: Updates the lines in a template and Step 2: retrieves the rows via a get lines action.

Because I still experiences locks of my files I did something like this:

flow1.png

That is basically a loop that tries to update my file multiple times until it succeeds. In my tests I noticed that it took me up to 13x before the file was unlocked and the data were updated. But finally everything worked out fine Smiley Happy ... but it costed me a lot of sweat and tears Smiley Sad

Many thanks for you feedback and support!

Much appreciated.

Best regards,

Ludwig

View solution in original post

4 REPLIES 4
v-xida-msft
Community Support
Community Support

Hi @lreinhard7,

 

Could you please share a screenshot of your flow's configuration?

 

The error message told that the Excel file is currently checked out or locked for editing by another user. There is no direct way to overcome this issue in Microsoft Flow currently, you could not complete your task within your flow until the another user closes the editing Excel file.

 

In addition, you could consider take a try to configure Run after action for the error step (the action where the error occurs) within your flow. I have made a test on my side and please take a try with the following workaround:17.JPG

 

18.JPG

Note: I assume that the error may occur in the "Add a row into a table" action, you could configure a Run after action under the "Add a row into a table" action, if the "Add a row into a table" action failed, send a failure email notification to yourself.

 

More details about configuring a Run after action in Microsoft Flow, please check the following article:

https://flow.microsoft.com/en-us/blog/error-handling/

 

 

Best regards,

Kris

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

Hello Kris,

Many thanks for your response and the idea provided.

I tested something similar but noticed that the file is still locked and prevents me updating the data.

So, I modified my flow and created two additional steps

Step 1: Updates the lines in a template and Step 2: retrieves the rows via a get lines action.

Because I still experiences locks of my files I did something like this:

flow1.png

That is basically a loop that tries to update my file multiple times until it succeeds. In my tests I noticed that it took me up to 13x before the file was unlocked and the data were updated. But finally everything worked out fine Smiley Happy ... but it costed me a lot of sweat and tears Smiley Sad

Many thanks for you feedback and support!

Much appreciated.

Best regards,

Ludwig

I implimented this but it timesout before the file is unlocked. Is there anyway to force an unlock?

m currently trying to implement this very logical and simple FLow to update the content of the file. This is the only hurdle and Configure run after doesnt exist directly after action.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,475)