Answered

SharePoint remove user

(0) Share

Report

Posted on by stormin_30

Hello All,

I am trying to add and remove users to a SharePoint site using the "Send an HTTP request to SharePoint" action. The add action works but the removal does not.

Any ideas where I am going wrong?

Error message: The expression "web/SiteGroups(https:/normyoung.sharepoint.com/sites/SharePointDemo/_api/Web/SiteGroups/GetById(5))/users/removeByLoginName" is not valid.
clientRequestId: b2bf9405-1b0c-438e-80a5-c8d575776e18
serviceRequestId: a5ac849f-b04d-b000-cc44-463d26a3000d

Thanks.

Norm

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

ChrisPiasecki 6,428 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @stormin_30,
Try adding the user login into the request string as such.
..../removeByLoginName(@v)?@v='<USER CLAIMS>'
https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-rest-reference/dn531432(v=office.15)#removebyloginname-method-1
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
stormin_30 89 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChrisPiasecki, thank you for the suggestion, I appreciate it. I was not able to get "removeByLoginName" to work and went with "removeById".

It's working now and I will post the solution to help others.

Norm

Was this reply helpful? Yes No
Verified answer

stormin_30 89 on at

Like
a
(1)

Report
Copy link

Link copied!
Solution:

Get user ID

Compose user ID
@{body('Send_an_HTTP_request_to_SharePoint_-_Get_User_Id')['d']['id']}

Remove user

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

Like
a
(0)

Report
Copy link

Link copied!

The solution is to let the body empty and put everything in the URI, but url-encode the claim/login name (--> the whole string starting with 'i:0#.f|...').

My SPO HTTP-REST-POST-Request looks like this:

_api/web/sitegroups(@{variables('vSharePointGroupId')})/users/RemoveByLoginName('@{encodeUriComponent(items('Apply_to_each')?['AssignedTo/Claims'])}')

See also this screenshot:

Was this reply helpful? Yes No
delicatebeing1 23 on at

Like
a
(0)

Report
Copy link

Link copied!

hello,
I would like to receive your help that in my use case it takes forever to remove a user when I test it. Adding a user is too easy and direct, whereas removing is nearly impossible, there must be more details into that is not clearly mentioned in this post.

Was this reply helpful? Yes No