Adding multiple users to SharePoint Group using rest api with Power automate

(0) Share

Report

Posted on by PI-28080747-0

t adds the first user SoI'm using power automate to add users to a patcicular SharePoint group. Somtimes it adds the user sometimes it doesn't.

Is this api reliable or can it only add one user at a time?

The api i'm using is (Leveraging Send an HTTP request to SharePoint). See below

_api/web/sitegroups/getbyname('SharePoint Group')/users

Method : Post
Body :{ 
"__metadata": { "type": "SP.User" }, 
"LoginName": "i:0#.f|membership|Usersemailaddress" 
}

Are there any api to do this?

Thanks in advance

FYI - in my power automate the rest call is in side an Apply each and adds the users in the loop one at a time.Sometimes it adds the first user only or the last one

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WillPage 2,339 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

When you click through each iteration of the loop in the run history, do you see any error responses from the API for the ones that didn't work?

Was this reply helpful? Yes No
PI-28080747-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi WillPage,
I don't see any errors at all. Everthing looks ok.
I have 2 users added but i only see one for example in the group.
If there is an existing user does it actually do a replace or it doesn't do anything

Hope someone from MS can help its very strange

Was this reply helpful? Yes No
Suggested answer

PI-28080747-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

All sorted.
For some reason i changed my api to start using GroupID ad its performing better.
It seems there is a bit of a bug when using SP group names

Was this reply helpful? Yes No
Suggested answer

Jalpa Mahesh Dhola 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Please add the API and body in http request as I stated below. I tried this in my tenant and added two users in the SharePoint group together.

_api/SP.Web.ShareObject

{"url": "https://<TenantName>.sharepoint.com/sites/<SiteName>","peoplePickerInput": "[{'Key':'i:0#.f|membership|UserPrincipalName'},{'Key':'i:0#.f|membership|UserPrincipalName'}]","roleValue": "group:<groupId>"}

Thanks

Was this reply helpful? Yes No