Person Column Cannot Find a New User: Root Cause and Fix
🔍 WiseChecker

Person Column Cannot Find a New User: Root Cause and Fix

When you type a name in a SharePoint person column, the search often returns no results for a user who was just added to the organization. This happens because SharePoint does not automatically sync new user profiles from Microsoft Entra ID. The person column relies on the SharePoint User Profile service, which can take 24 to 48 hours to update after a new account is created. This article explains the root cause of this delay and provides a manual fix to force the sync so the new user appears in the person column immediately.

Key Takeaways: Force Sync the User Profile to Fix the Person Column

  • SharePoint admin center > User profiles > Manage user profiles: Locate and delete the incomplete profile to trigger a full import.
  • Microsoft 365 admin center > Users > Active users: Verify the user license and sign-in status before syncing.
  • SharePoint Online Management Shell: Run Start-SPProfileSync to force an immediate profile synchronization for all users.

ADVERTISEMENT

Why the Person Column Cannot Find a New User

SharePoint person columns query the User Profile Service Application (UPSA) to resolve names. When a new user is created in Microsoft Entra ID, the profile is not immediately available in SharePoint. The SharePoint User Profile Service runs a scheduled import job from Microsoft Entra ID every 24 to 48 hours. Until that job completes, the person column cannot find the user.

The root cause is the separation between identity management and profile synchronization. Microsoft Entra ID holds the authoritative user list. SharePoint maintains its own profile database. The sync process is not real-time. It uses incremental imports that run on a timer.

Another common factor is the user profile deletion policy. When a user is deleted from Microsoft Entra ID and later restored, the old profile in SharePoint is not automatically re-created. In that case, the person column will not find the user until a full profile import runs.

How the User Profile Import Works

The SharePoint User Profile Service Application imports user data from Microsoft Entra ID using a timer job called “User Profile Service Application – Full Synchronization.” This job runs by default every 24 hours for full syncs and every 5 minutes for incremental changes. However, incremental syncs do not always pick up new users immediately. The full sync is required to populate the profile database with new accounts.

Steps to Fix the Person Column Search

You can force the profile sync in two ways. Use the SharePoint admin center for a manual trigger or run a PowerShell command for an immediate result.

Method 1: Force Sync Through the SharePoint Admin Center

  1. Open the SharePoint admin center
    Sign in to Microsoft 365 with a SharePoint administrator account. Go to Admin centers > SharePoint.
  2. Navigate to User Profiles
    In the left menu, select More features. Under User profiles, click Open.
  3. Manage user profiles
    In the User Profiles section, click Manage user profiles.
  4. Find the missing user
    In the Find profile box, type the user’s display name or email. Click Find. If the profile exists but is incomplete, delete it by clicking the X icon next to the profile.
  5. Trigger a full profile import
    Go back to the User Profiles section. Click Schedule profile synchronization. Select Start full synchronization and click OK. This queues a full import job that runs within minutes.

Method 2: Force Sync Using PowerShell

  1. Install the SharePoint Online Management Shell
    If not already installed, download and install the SharePoint Online Management Shell from the Microsoft Download Center.
  2. Connect to SharePoint Online
    Open PowerShell as an administrator. Run Connect-SPOService -Url https://[tenant]-admin.sharepoint.com. Replace [tenant] with your tenant name. Sign in with a SharePoint administrator account.
  3. Run the profile sync command
    Execute Start-SPProfileSync -ProfileType User. This forces an immediate synchronization of all user profiles from Microsoft Entra ID to SharePoint.
  4. Verify the user appears
    Wait 2 to 5 minutes. Go to the site where the person column is used. Refresh the page and type the user’s name in the column. The name should now appear in the picker.

Method 3: Check User Licensing and Sign-In Status

  1. Open the Microsoft 365 admin center
    Go to Admin centers > Microsoft 365 admin center.
  2. Verify the user license
    Under Users > Active users, find the new user. Check that a SharePoint Online or Microsoft 365 license is assigned. Without a license, the user profile is not created.
  3. Confirm the user has signed in
    The user must sign in to Microsoft 365 at least once. The first sign-in triggers the initial profile creation in Microsoft Entra ID. If the user has never signed in, the profile sync will not find them.
  4. Wait 30 minutes after first sign-in
    After the first sign-in, the profile is created in Microsoft Entra ID. The SharePoint sync may take up to 30 minutes to pick up the new profile even with a forced sync.

ADVERTISEMENT

If the Person Column Still Cannot Find the User After the Fix

Person column shows an error message instead of a name

If the person column displays an error like “Could not find this user” after the sync, the user profile may be corrupted. Delete the user’s profile from the SharePoint admin center (Manage user profiles) and run a full synchronization again. This forces SharePoint to recreate the profile from scratch.

Person column only finds users from the same site collection

By default, the person column searches all user profiles in the tenant. If the column is restricted to a specific site collection audience, it will only find users who have visited that site. To fix this, edit the site’s audience settings in the SharePoint admin center. Go to Active sites, select the site, and click Settings. Under Audience, remove any audience filter.

Person column works on one site but not another

This happens when the site is using a custom permission level that blocks the “Use Remote Interfaces” permission. The person column requires that permission to query the User Profile Service. To fix this, go to Site permissions > Advanced permissions settings > Permission Levels. Select the permission level assigned to the user. Check the box for Use Remote Interfaces and save.

Person Column Search Behavior: Before Sync vs After Sync

Item Before Profile Sync After Profile Sync
User visibility in person column User not found User appears in search results
User profile in SharePoint Missing or incomplete Complete with all attributes
Sync method required None available Full synchronization or PowerShell command
Time to resolve 24 to 48 hours 2 to 5 minutes after forced sync
User license requirement Not checked Must have SharePoint Online license

You can now force a profile sync to make a new user appear in a SharePoint person column. Start by verifying the user has a license and has signed in. Then use the SharePoint admin center or the Start-SPProfileSync command to trigger an immediate full synchronization. If the column still fails, check for audience filters or corrupted profiles. For ongoing management, schedule a weekly full profile import to prevent similar delays for future new users.

ADVERTISEMENT