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.
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?
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.
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.
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.
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.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!