Answered

Get E-mail address of LockedbyUser

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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(filerelativeurl)/lockedByUser

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!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Is this what you are looking for?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GHobbs 6 on at

Like (0)

Report
Copy link

Link copied!

Can you share the Parse JSON code to do this?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
{ "type": "object", "properties": { "d": { "type": "object", "properties": { "LockedByUser": {} } } } }

Was this reply helpful? Yes No
GHobbs 6 on at

Like (0)

Report
Copy link

Link copied!

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(filerelativeurl)/lockedByUser

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?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GHobbs 6 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No