Detecting a locked file--other methods

(1) Share

Report

Posted on by annetoal

1,934 Moderator

I need to intercept locked files in SharePoint before they error out (SP can't update or delete files if they're locked).

I have been using the Send a HTTP request to SharePoint with this code

_api/web/GetFolderByServerRelativeURL('@{outputs('Get_file_properties')?['body/{Path}']}')/files/getbyurl('@{outputs('Get_file_properties')?['body/{Path}']}@{outputs('Get_file_properties')?['body/{FilenameWithExtension}']}')/LockedByUser

This works as long as the system thinks there is a LockedByUser, but occasionally it doesn't see the lock even though the file is open on someone else's computer. I think, but am not certain, this is because the login session has expired on the locking user's PC.

So, the locked file detection fails a certain percentage of times, and I am looking for a different parameter to query SharePoint about in the Send a HTTP request connector. Any suggestions or workaround would be most gratefully appreciated.

Thank you,

Anne

Categories:

Building flows

I have the same question (0)