cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pion_G
Level: Powered On

Re: Cannot write file to filesource. File is being locked.


@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?

 

emanon
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

The solution works, but why is there no 'add rows' command for the Excel Online (Business) connector?

AlexDades
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

This solved my problem. Apparently Powerapps hangs on and keeps Flow thinking something else is using it. Thanks for the help!

goDynamic
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

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.

image.pngFlow uses Excel Online (Business)

image.png

emanon
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

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.

goDynamic
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

In my case, I am the only user using the App with just one flow as I am still developing it. I haven’t opened the excel file today since I logged in to my computer. I am able to update the excel less frequently but the issue persists if I update repeatedly. I haven’t monitored the duration yet after which it allows me to update.
AdhamFH
Level: Powered On

Re: Cannot write file to filesource. File is being locked.

Hello,

is this still an issue ? 

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

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!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (5,282)