This tutorial shows how to access the user names from People or Groups using
Step 1: On DataSource Library pane, XML Web Services is the option to invoke
Step 2: Paste the web services link (https://<sharepointLocation>/_vti_bin/usergroup.asmx?WSDL)
for the user group data and click on connect. This will retrieve data of people.
In this below screenshot, GetUserCollectionFromGroup is an operation which retrieves the
people details belongs to the specified group name.
Step 3: Once the operation selected, it will show the parameters required for
that operation. In this case, groupName is the input parameter for
GetUserCollectionFromGroup. I have created a NewGroup group in my sharePoint. So
here i am passing “NewGroup” to that operation.
Step 4: Click on Login tab. Enter Username and password to establish the
Step 5: Now click on show data, it will show all the data.
Step 6: Select Name and click on Insert Selected Fields and select multiple item
Step 7: This will show the data into the screen . The next step is to filter
the data based on the current login.
in the above screenshot, UserID needs included in order to use the CAMLVariable
Step 8: Please change the below code to see if the current user name exists in
|In order to get the Number
<xsl:variable name=”Rows” select=”/soap:Envelope/soap:Body/ddw1:GetUserCollectionFromGroupResponse/ddw1:GetUserCollectionFromGroupResult/ddw1:GetUserCollectionFromGroup/ddw1:Users/ddw1:User”/>
to<xsl:variable name=”Rows” select=”/soap:Envelope/soap:Body/ddw1:GetUserCollectionFromGroupResponse/ddw1:GetUserCollectionFromGroupResult/ddw1:GetUserCollectionFromGroup/ddw1:Users/ddw1:User[@Name=$UserID]“/>