How to Get All the Users From a Specific SharePoint Group Using NINTEX Workflow

Introduction

In this article you will see how to get all the users from a specific SharePoint group using a NINTEX workflow. We will be getting all the users from a specific SharePoint group by calling the web service "_vti_bin/usergroup.asmx". I have created a custom list named "User Collection" in which I have the following columns.



Workflow Design



Call web service action is used to get the user collection from a specified SharePoint group. Query XML action is used to query the XML and get the login name of the users. Set field value action is used to set the users to the field in the item.

Get User Collection

Use the following procedure to get a user collection from a group workflow:

1. Navigate to the User Collection list.
2. Click on the "List" tab and then click on "Workflow Settings".
3. Click on "Create a Workflow in Nintex Workflow".
   
   
   
   
4. Click on "Cancel".
   
   
   
   
5. Drag and drop the Call web service action from the Integration section.
   
   
   
   
6. You will be able to see the warning symbol in the workflow action, click on that and then you will see the following warning message:
   
   
   
7. Click on "Configure" from the drop down list in the Call web service action.
   
   
   
   
8. Click on the "Insert Reference" button for the URL column and then click on the "Common" tab. Select "Web URL" and then click on "Ok".
   
   
   
   
9. Append "/_vti_bin/usergroup.asmx" tp the URL column.
10. Enter the User Name and Password to call the web service and then click on the "Reference" button.
11. Click on "Ok".
    
    
    
    
12. All the web service methods will be populated. Select the "GetUserCollectionFromGroup" web method that will be used to get all the SharePoint groups from the website.
    
    
    
    
13. Click on the "Variables" button.
    
    
    
    
14. Enter the variable name and select the variable type.
    
    
    
    
15. Click on "Save".
    
16. The variable is created successfully.
    
    
    
    
17. Click on the "Insert Reference" button for the groupName column and then click on the "Item Properties" tab. Select "Group Name" and then click on "Ok".
18. Select "Specify elements", click on the "m:GetUserCollectionFromGroupResult" element and then click on the "Apply" button.
    
    
    
    
19. Select the userCollectionXML variable for the "Store result in" drop down.
    
    
    
    
20. Click on "Save".
21. Drag and drop the Query XML action from the Integration section.
    
    
    
    
22. Click on "Configure" from the drop down list in the Query XML action.
23. Click on the "Variables" button.
    
    
    
    
24. Enter the variable name and select the variable type.
    
    
    
    
25. Click on "Save".
26. The variable is created successfully.
    
    
    
    
27. Select "XML" from the XML Source drop down list.
28. Click on the "Insert Reference" button for the XML column and then click on the "Workflow Variable" tab. Select "userCollectionXML" and then click on "Ok".
29. Enter the XPath "/defaultNS:GetUserCollectionFromGroup/defaultNS:Users/defaultNS:User/@LoginName".
30. Select the "users" variable from the "Store result" in the drop down list.
31. Click on "Save".
    
    
    
    
32. Drag and drop the "Set field value" from the "Libraries and lists" section.
    
    
    
    
33. Set the value to the field.
    
    
    
    
34. Click on "Save".