Add The Users To The SharePoint Groups Using Microsoft Flow

Gunasekaran M

11 Comments

Join the conversation! Your thoughts help the community grow.

Nilanka Perera6y ago
This is what worked for me: Set the URL of the SiteSet method to “POST” URI set to “_api/web/sitegroups({GROUPID})/users”, example: _api/web/sitegroups(10)/users Add header with key=”accept” and value = “application/json;odata.metadata=none” Add header with key =”content-type” and value = “application/json” Set the Body to be {‘LoginName’:’i:0#.f|membership|[EMAIL ADDRESS]’}, example: {‘LoginName’:’i:0#.f|membership|[email protected]’}
Jaipal Singh7y ago
Hi - newbie to Sharepoint online and struggling on how to enter the values in the 'headers' input box. Is there some kind of special entry format?? Thanks
- Jaipal Singh7y ago
  Sadly I don't get that ..... this is what I see: https://imagebin.ca/v/4m4tjM0hGxrC - there's only the bit about entering JSON
- Peter Hartmann7y ago
  In the screenshot under Step 2 above, there is a row with two columns. Each contain a "grey-ed out" message of "Enter key". You should be able to enter text directly in those cells.
Valdo Gjonikaj7y ago
Hi, i'm getting the error:{ "Invalid JSON. The property name '' is not valid. The name of a property cannot be empty.}, i don't know how to except it.
- Peter Hartmann7y ago
  I found that I had to do a combination of Gunasekaran's and Laurent's solutions. What worked for me is: {'__metadata':{'type':'SP.User'},'LoginName':'i:0#.f|membership|your_user_name'}
- Laurent (Theartemis)7y ago
  Found the solution, had to remove the “_metadata”:{“type”:”SP.User”}, it looks like that {”LoginName”:”i:0.#f|membership|your_user_name”}
- Laurent (Theartemis)7y ago
  Got the same issue, didn't managed to solve it yet
Sumit Prusty7y ago
Hi i am getting the following error while implementing the same functionality of adding an user to a sharepoint group. "The property '_metadata' does not exist on type 'SP.User'. Make sure to only use property names that are defined by the type. "
- Gunasekaran M7y ago
  Are you using the People picker property in the _metadata?
- Gunasekaran M7y ago
  It should be like this {“_metadata”:{“type”:”SP.User”},”LoginName”:”YourPepoplePickerFieldValue”}

As we all know, Flow is a replacement for SharePoint Designer based workflows. In my one of the latest assignments I had a requirement to update (or) add the user to the SharePoint groups, but by default we do not have any connectors to do this. Hence, in order to achieve this we shall use the send HTTP request to SharePoint connector and pass the rest endpoint URL and its required parameters.

Here is the step by step approach:

Step 1

Navigate to your flows, click on add action, and choose the “Send HTTP request to SharePoint”. You can also search for this in the search box below or click on SharePoint to choose this action.

Step 2

Pass the required parameters,

Site Address

Select the site where you want to add the users.

Method

POST, the method should post since we are adding the user.

Uri

_api/web/sitegroups(43)/users, this is the typical REST Endpoint URL to fetch the users from the particular group. Here (43) is the group ID. We shall not use the group name here we can only use the group id.

Headers

Body

{“_metadata”:{“type”:”SP.User”},”LoginName”:”xyz”}

In place of xxxx, you shall replace it with your required name, you shall also use any of the people picker field names in place of XYZ.

Save the flow and test it; your users now should have been added to the group.