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
@pladavm wrote:Received a response from Microsoft, it is because using the wrong Excel connector. Need to use Excel Online (Business) connector.
Thanks a lot: works flawlessly!
But why did it took so long to receive the correct answer?
The solution works, but why is there no 'add rows' command for the Excel Online (Business) connector?
This solved my problem. Apparently Powerapps hangs on and keeps Flow thinking something else is using it. Thanks for the help!
I am using Excel Online (Business) connector to "Update a row" and "Get a Row" in my Flow. I am still facing the "File is locked" issue.
Flow uses Excel Online (Business)
I am still seeing the problem, though it may be due to multiple flows interacting with the Excel sheet as well as multiple users from different computers using it through the day. It is disappointing that there are this many issues with such an integral part of the Microsoft Office package.
Hello,
is this still an issue ?
Pls close the excel file and reload.
I had the error and immediately i close the excel file, i reloaded and it worked for me.
No, you are wrong. The issue will still persist if you keep running the Flow (even if it doesn't at first, it will eventually happen again).
The only solution is to use the business connector.
I am having this error, and I am using the Excel Online Business Connector.
How often does this happen?
All the time, here is the thread I created yesterday...
I am having this issue, but I'm not using Flow. I'm just using Patch within my PowerApps app to add a row to an Excel spreadsheet (in OneDrive for business) and it locks regularly, making my new attempts to add a row fail.
The common issue such as the Excel file placed on OneDrive is open. But, another problem is with the table you define in PowerApp, if you assign the row size 1000000 which is maxed, in the current version of PowerApp. The APP which you are trying to build assign a PowerAppID key against all those blank rows/records & table assume to completely loaded to its limit, thus no new record is allowed to insert. Just keep the single row in the table, which helps PowerApp to identify your data types. And let PowerApp to handle your row limit.
Regards,
AD
I this forum post is stale. I'm still having the issue. Has there been a resolution?
3 years yet no solution.
I had the same issue! I disable the auto-save on the excel file and it works perfectly.