Get E-mail address of LockedbyUser

[Anonymous]

Hi,

I'm running a flow which updates certain file properties. The flow fails if the file is open by someone, the error message says something like "the file is locked by user". The flow works in a loop, so eventually when the user closes the file it updates the properties, however it can take a while. I want to send an HTTP request to SharePoint to get the LockedbyUser and send an E-mail to that person asking to close the file. Now the request I believe should look like this:

GET http://<sitecollection>/<site>/_api/web/folders/getbyurl(folderrelativeurl)/files/getbyurl(filerelat...

However I'm struggling with translating this into an E-mail address to use in the "To" field of the Send an E-mail action. Can anyone help with this part, please?

Thanks!

[Anonymous]

Is this what you are looking for?  

[Anonymous · Accepted solution]

Yes, in the end I managed to find the Parse JSON code to do this.

[GHobbs]

Can you share the Parse JSON code to do this?

[Anonymous]

{
    "type": "object",
    "properties": {
        "d": {
            "type": "object",
            "properties": {
                "LockedByUser": {}
            }
        }
    }
}

[GHobbs]

Hi again, I am struggling with the first part of this process i.e. the HTTP request to SharePoint to get the LockedbyUser.

I understand that I need to enter this formula:  http://<sitecollection>/<site>/_api/web/folders/getbyurl(folderrelativeurl)/files/getbyurl(filerelat...

But I am not sure which dynamic values to use... here's what it looks like on my end. Any thoughts on what I am doing wrong?

[Anonymous]

I use a different approach to get the file:
getbytitle('library name')
items(item ID of document)

This post looks like it might be using the same approach as you:
https://www.thetindog.com/dynamics-as-we-go/identifying-sharepoint-file-locks-with-power-automate

[GHobbs]

Thanks, but now I am getting an error 404 with the message "Cannot find resource for the request getbytitle".

Any thoughts?

[Anonymous]

Are you using the correct name for the library?
If your display name is Library Name, then you'd want to use Library%20Name in the flow Uri.

If that doesn't work, please post the full URL of your site and library, being sure to mask any sensitive words.
sites/parent/?child?/My%20Library/Forms/Allitems.aspx