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

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
lreinhard7
Level 8

Re: Excel online business connector locks file and stops subsequent processes

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

Re: Excel online business connector locks file and stops subsequent processes

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

Re: Excel online business connector locks file and stops subsequent processes

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

DataViz
Level: Powered On

Re: Excel online business connector locks file and stops subsequent processes

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

nickduxfield
Level 8

Re: Excel online business connector locks file and stops subsequent processes

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
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,165)