You’re offline. This is a read only version of the page.
9
Hi,
I am pretty new to flow. I have built a few flows connecting to an Excel file stored in Sharepoint, and this particular flow which was scheduled to update the file once a day early in the morning to allow various Excel formulas to process (NOTE: all the other flows connected to the file are scheduled and run successfully). It worked fine but then started erroring because the file is 'locked for shared use' - by myself. No-one has been editing or even viewing the file. I tried opening and closing, checking out/in, deleting all browser caches, restarting my machine every day and it still didn't unlock. I did some more reading and built in a Do Until to keep the flow trying until the lock timed out - it just runs endlessly. Nothing has worked. The strangest thing is that the flow did succeed once 5 days ago but then failed again.
Here's the flow:
Any help would be greatly appreciated, I don't want to have to recreate the file if possible.
This is now fixed! I went back into the other flows that were connecting to the file and discovered that the recurrence was set to every 5 minutes for each of them, meaning that the file was constantly being accessed. I switched the recurrence to just once per day (at different times) and manually ran the flow which was failing, and it was successful.
Share
Report
All responses (
Answers (
