I have a FLOW that changes properties on Word files in a document library. Often the files are locked becuase:
1. A user has kept Word running and has fogotten to close the file
2. Word has not shutdown properly on someone's machine and the file remains locked.
3. Someone was editing the file using Word Online and has not closed the browser session.
In all of these cases a FLOW that is trying to change the values of metadata on a file will fail the step and move on. I do know how to catch the failure and report it to a user. I would like to side step this process and unloick the file. Is there a way to do this?
Hi @Anonymous unfortunately most of these scenarios result in not being able to do anything unless the Word document has been closed. Generally locks remain in place (certainly in the Word Online scenario) for 10 minutes before timing out and releasing the file, so could perhaps build in a "retry" after 15 minutes if your Flow has failed.
I'll have a dig around and see if there's anything that can be done about locking in the other two scenarios, but I'm surprised that you're having the issue unless a file has actually been checked out.
If you have found this post useful, please give it a thumbs up. If it has answered your question, please accept it as the solution so others can benefit.
@MattWeston365
Hi @Anonymous ,
The issue you mentioned could be reproduced by me. When the file is open, Update file properties action turned failed.
I have figured out the following workaround for your scenario, please check it for a reference.
After the first Update file properties action, add a Scope to run after when it has failed.
Within the scope, get file properties, then send an email to last user who modified the file to close the file.
After the scope, add a Delay action to wait for several minutes for the user to close the file, then update the file properties again.
Best regards,
Mabel
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.
User | Count |
---|---|
26 | |
25 | |
23 | |
23 | |
14 |
User | Count |
---|---|
46 | |
33 | |
32 | |
31 | |
30 |