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...
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.
Maybe the link below also could help you a little:
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!
Flow Community Manager
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.