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.
I was having this issue today too. I disabled auto-save on the excel file and it ran just fine after that. I don't know why that would have worked since I don't keep the file open, but maybe there's something server-side? Worth a shot.
I disabled auto-save on the excel file and it ran just fine after that.
How do you do that ? I'm unable to locate that option (I'm using Excel Online)
Hi @SCTdan and @Pion_G, thank you for participating. I think we definitely need an answer that works with online Excel, for business can't really offer a solution where people have unsynced Excel files on their desktop.
We need to continue our campaign to reach Microsoft on this issue.
@v-bacao-msft, @v-micsh-msft @GabrielStJohn
Same issue here. However, I want to access the Excel file that was updated with a Check-In row with a timestamp using Flow with a Check-out timestamp update in PowerApps.
Before turning off autosave as suggested earlier, the Excel file was locked. Now it is not locked, but it does not show the newly created Check-in row because Flow is still shown as editing the file and the row will not update with a ___PowerAppsid___.
Yes but that doesn't exactly work for excel online and what if you want additional flow logic that relied upon the Excel table data.
Turning off the autosave is not a solution.
I am getting the same issue here, which is deeply frustrating. Powerapps and Flow working together could create some incredible results, but this error is killing my ability to create functional, live data. Waiting 30 minutes to get notified of something time-critical happening is not acceptable whatsoever.
Any new person that visits this thread, please leave a message with the above mentions so Microsoft are notified each time we have this issue.
Thanks for posting on the Flow forum! Please report this issue to our support team for further assistance if it appears that the community is unable to further assist you. Heres the link:
Microsoft Flow Community Manager
To write data in excel file please follow these steps.
- Create Table in Excel file so you can append table row using flow action.
- Other important thing is when your flow writing the data in excel file your excel file must be closed , no one can editing it otherwise flow gives error of file locked and insert row failed error whether it is online excel sheet or using file system.
@pladavm I'm Sorry that my solution not work for your scenario but i tried and add rows in excel online sheet during editing and closed sheet. Please see the below images.
Received a response from Microsoft, it is because using the wrong Excel connector. Need to use Excel Online (Business) connector.
@Harry_G Change your trigger from every day to every minute and then wait 30 minutes and see if it still continues, usually it will lock out after a few minutes.
@pladavm I change my trigger to every minute every thing running smoothly, I'm using Excel online (Bussiness) connector. please see the below images;
You can clearly see that i run flow for approximately more than 30 minutes but files working fine.