'%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)
Fix SharePoint People Column Not Resolving Users in a Group
Question details
A SharePoint Online People column restricted to a specific group displays a "No Result Found" error when searching for users who appear to belong to that group.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Searching for a specific user in a restricted People column within a SharePoint list or document library.
- Observed behavior
- The People column displays "No Result Found" even though the user seems to belong to the designated security group, often caused by inactive Microsoft Entra ID accounts or nested group limitations.
Ensure you have site administrator privileges in SharePoint Online and access to the Microsoft 365 Admin Center or Microsoft Entra ID to verify user account statuses.
Verify User Account Status in Microsoft Entra ID
Ensure that the users encountering the error are active and have not been blocked in your Microsoft 365 tenant.
SharePoint People columns cannot resolve user accounts that are inactive, blocked, or have been removed from the organization. Verifying the account status in Microsoft Entra ID is the first step in resolving this issue.
Go to the Microsoft 365 admin center or Microsoft Entra ID portal and log in with your administrator credentials.
Navigate to 'Users' and then select 'Active users'. Use the search bar to find the user account that is not resolving.
Open the user's profile and ensure their account is active. Confirm that the 'Block sign-in' option is not enabled.
Remove Nested Groups and Ensure Direct Membership
The SharePoint People column may fail to resolve users if they belong to a nested group rather than being direct members of the assigned security group.
Create and Test a New People Column
If the current column is corrupted or caching old group restrictions, creating a fresh People column can help isolate the issue.
Looking for a Simpler Way to Collaborate? Try WPS Office
If complex SharePoint permission structures and list configurations are slowing down your team's productivity, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly environment for document sharing and real-time collaboration without the administrative overhead.
- 1. Download the Application: Visit the official WPS website and download the free desktop application for your operating system.
- 2. Open Existing Files: Easily open and edit your existing Microsoft Office files with perfect formatting and layout compatibility.
- 3. Collaborate Instantly: Share your files via simple links and collaborate in real-time with your team without configuring complex group permissions.
Frequently Asked Questions
Why does the SharePoint People column say 'No Result Found' for an existing user?
This usually happens if the user's account is inactive or blocked in Microsoft Entra ID, or if they are part of a nested group rather than a direct member of the security group the column is restricted to.
Can I use nested Microsoft 365 groups for a SharePoint column restriction?
SharePoint People columns often do not fully support resolving users through nested groups. It is highly recommended to add users directly to the specified group to ensure reliable search functionality.
How long does it take for a newly unblocked user to appear in the People column?
After unblocking a user or changing their group membership in Microsoft Entra ID, it may take a few hours for the backend synchronization to fully update SharePoint Online search indexes.
