cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JBHorne
Advocate I
Advocate I

Excel Get Rows - Error 423 - Cannot write file to filesource. File is being locked.

I have a Create Table action and then immediately need to Get Rows from that table. The Create Table action though doesn't release the lock on the file when it's done with it. Files are on OneDrive. Added a 10 minute delay and that's not enough, but any more delay and my Flow won't work timely for looping through files.

 

Previously I was using the "List rows present in a table" action, which was working, but found out the hard way this is (stupidly) limited to 256 rows with no workaround (and no warning).

 

Is there any way either issue can be fixed? Working thourgh these "gotchas" in Flow has been quite frustrating...

4 REPLIES 4
v-bacao-msft
Community Support
Community Support

Hi @JBHorne

 

I'm afraid that you have the same issue as MatthewGrantAU .

 

Generally, I have to operate for a while, so that it will automatically be fine.

 

We will keep track of this issue.

 

You could post your idea to improve it in the Flow Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Maybe the link below also could help you a little:

https://powerusers.microsoft.com/t5/Using-Flows/Microsoft-Flow-Excel-File-Locked-While-Not-Open/m-p/...

 

https://support.office.com/en-us/article/excel-file-is-locked-for-editing-by-another-user-6fa93887-2...

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GabrielStJohn
Community Champion
Community Champion

Hello, @JBHorne!

 

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-bacao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


Thank you for being an active member of the Flow Community!

 

-Gabriel
Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



No. Microsoft has yet to fix this issue. Workarounds are not solutions. When something worked in the past and then stopped, that needs to be fixed. How do we escalate this to whatever department has control over these actions to get them fixed?

@JBHorne

I have reproduced this issue when using Excel - connector. 
But when using Excel Online (Business/OneDrive), the problem of locked file is not appearing. 

The normal Excel is the old connector and it's a know issue. So just use the Online connectors and you will have no worries about locked Excel files.

 

Regards,

 

Frederik Bisback

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,445)