Get a list of site users with no code via SharePoint Designer

Just like last time, when we created a list containing the sub sites, we can use the data source and a data view to display all site users that have access to a site.

1)Open the site in SharePoint Designer.

2)Go to the Data Sources block and click on the button SOAP Service Connection

3)Add the link to your site in the field “Service description location” and add the part: _vti_bin/usergroup.asmx
This will give you a link like this:

http://yoursitecollection/sites/yoursite/ _vti_bin/usergroup.asmx

4)Click the “Connect now” button: SPD automatically adds the select statement, the WebsSoap port and GetUserCollectionFromSite (if not, choose these values)

5)Click “ok”

6)Go to the page where you want to add the list in SharePoint Designer. On the insert tab, add a Data View with the SOAP Services connection we just made
Done!

If you save the page and open it in your browser, you will see a list of all site users that have access. If you have AD Groups, those will be displayed instead of the people that are in them.

About: Marijn

Marijn Somers (MVP) has over 14 years experience in the SharePoint world, starting out with SP2007. Over the years the focus has grown to Office 365, with a focus on collaboration and document management. He is a business consultant at Balestra and Principal Content Provider for "Mijn 365 Coach" that offers dutch employee video training. His main work tracks are around user adoption, training and coaching and governance. He is also not afraid to dig deeper in the technicalities with PowerShell, adaptive cards or custom formatting in lists and libraries. You can listen to him on the biweekly "Office 365 Distilled" podcast.