Working with locked documents in Power Automate Flows #PowerAutomate

Blog post with all the details...

[karlstenator]

It's a shame that the loop delay time tallies up the overall Flow duration - and also frustrating that the RetryPolicy of a Step doesn't allow for an error 400 check.

Appreciate the workaround you've detailed in your video.

[RicardoCarneiro-ketj]

Hi Paulie, first of all many thanks for sharing. I am using your approach to move a group of Excel files that I need to insert a TABLE, because the RAW file only contain SHEETS and Power Automate can't run it. So it worked perfectly for me, after I update all excel files I need to copy then to another Doc.Library and the files were blocked but it is OK now. The only problem is I am getting an error that does not affect the functionality, but I am a little bit worried if it will bring issues in the future because it attached to a SharePoint trigger the will run every time new files will be uploaded>

I don't know how to insert images here but at least I can show you the message:

The provided 'Wait' action 'interval' value '1' 'Second' is not supported for the 'Consumption' SKU. The value must be between '5' seconds and '30' day(s).

Thanks for sharing

[bushmanjack]

Love this solution - very elegant and simple compared to others I've seen.
Two questions:
1. In your logic checking to see if a lock message has been returned - is the IF() portion redundant given the AND() portion already returns TRUE/FALSE Bool?
2. In the proc I want to use this for, the file I want to move is actually being locked by the flow itself as it has just been created and read from by the flow. In this instance - could I remove the test logic and simply switch the status from locked to unlocked?

[astatine]

where do you find the document id I found something that said use itemid, but it's not showing up in my search.

[dskw]

cool! what if the file lock is cause by an action itself? e.g Add a row into a table -> then needing to move the source file?

[mrwhammer]

yeah but you could lock the document by clicking it open and closing it quickly

[tmcpang]

Hi Paulie,
I am wondering if there are ways to force unlock the documents. Let says the user who had the document locked is not available to close the document, how do we force unlocking it?