'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to View All Items in the SharePoint User Information List
Question details
The user wants to find a way to view all items in the SharePoint User Information List because the default browser view caps the displayed results.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Attempting to view the complete list of registered users in a SharePoint environment with thousands of items.
- Observed behavior
- The browser view (/_catalogs/users/detail.aspx) only displays approximately 300 to 350 users out of thousands, even when modern experience is enabled, indexes are added, and there are no grouping or sorting restrictions.
Ensure you have the appropriate administrative permissions in your SharePoint environment and access to PowerShell, as resolving this requires administrative querying tools.
Use PowerShell to Retrieve the Complete User Information List
Since SharePoint does not provide a separate browser URL to display every item, PowerShell is the recommended administrative method to retrieve and manage the full list.
The built-in SharePoint browser URL for the User Information List is hardcoded to display a limited subset of users. Modifying the list-view threshold or adding indexes will not bypass this specific page's display limit.
To get a complete export of all users (for example, all 6,248 items), administrators must connect to the environment via PowerShell and query the list directly.
Launch Windows PowerShell or SharePoint Management Shell with administrative privileges on your device.
Use the appropriate connection command (such as Connect-SPOService for SharePoint Online or Connect-PnPOnline) to authenticate with your SharePoint environment.
Run a script to query the hidden User Information List and pipe the results to the Export-Csv cmdlet. This will generate a complete file of all users that you can view locally.
Manage Your Exported SharePoint Data with WPS Office
After exporting your complete SharePoint User Information List to a CSV file using PowerShell, use WPS Office as a lightweight and free alternative to Microsoft Office to quickly view, filter, and organize your user data.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your computer.
- 2. Open WPS Spreadsheets: Launch WPS Spreadsheets, click on 'Menu', and select 'Open'.
- 3. Load Your Exported Data: Locate the CSV file generated by your SharePoint PowerShell script and open it to view all your users without any row limits.
Frequently Asked Questions
Why does my SharePoint User Information List only show 300 to 350 items?
The default browser view located at /_catalogs/users/detail.aspx is designed to only show a limited subset of users for performance and architectural reasons. There is no built-in alternative URL that displays the entire list in the browser.
Will changing the list-view threshold fix the user display limit?
No. Even if you disable the list-view threshold, enable the modern experience, or add indexes, the specific page for the User Information List will still restrict the number of displayed items.
How can I get the exact PowerShell script to view all SharePoint users?
PowerShell scripts differ based on your specific SharePoint version and configuration. It is recommended to consult SharePoint experts by posting your question on the Microsoft Q&A forum using the 'office-sp' tag for precise commands.
