You’re offline. This is a read only version of the page.
29
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 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
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
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:
Best Regards,
Barry
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,962
Most Valuable Professional
Share
Report
All responses (
Answers (
