SharePoint Document Issues

How to Fix SharePoint 2016 Bulk Upload Fails for Person or Group Fields

Adam DavisAdam Davis Nov 13, 2026 869 views

Question details

The user needs to bulk import items into a SharePoint 2016 list that includes Person or Group fields, but the JavaScript creation process fails with user-not-found or user-not-unique errors.

How to Fix SharePoint 2016 Bulk Upload Fails for Person or Group Fields
Product
SharePoint Server 2016
Device & OS
not provided
Scenario
Large SharePoint 2016 list imports using JavaScript to create list items with Person or Group columns.
Observed behavior
The import fails with a user-not-found or user-not-unique error when JavaScript creates items containing Person or Group fields.
Before you start

Confirm the exact display name format that the SharePoint Person or Group column expects, and collect one sanitized failed request payload with field names and values.

Solution 1Recommended

Bulk Import Items with PowerShell and SharePoint CSOM

Use this when you need to create many list items and repeated JavaScript requests fail with user-not-found or user-not-unique.

Repeated JavaScript requests inside a loop can be fragile for large SharePoint 2016 imports. PowerShell with SharePoint CSOM lets you resolve each user once, batch operations, and inspect clear errors.

1
Load SharePoint CSOM assemblies

Open Windows PowerShell ISE as administrator and run Add-Type for Microsoft.SharePoint.Client.dll and Microsoft.SharePoint.Client.Runtime.dll from the SharePoint 2016 ISAPI folder.

2
Connect to the SharePoint 2016 site

Create a ClientContext with your site URL, set credentials, and execute context.ExecuteQuery() to establish the connection.

3
Resolve Person or Group field values

Use context.Web.EnsureUser(userPrincipalName) or Utility.ResolvePrincipal to map each display name or email to a unique user before setting the field value.

4
Create items and execute batches

Set the Person or Group column with FieldUserValue, add each ListItem to the list, and call context.ExecuteQuery after each batch to avoid timeouts.

Bulk Import Items with PowerShell and SharePoint CSOM
Recommended for repeatable imports: PowerShell CSOM resolves user identity once and batches item creation, reducing user-not-found and user-not-unique errors.
Free Microsoft Office alternative

Use WPS Office to Work with SharePoint Documents When SharePoint List Imports Stall

WPS Office is a free, lightweight Microsoft Office alternative that keeps your SharePoint document work moving. It opens and saves Word, Excel, and PowerPoint files with high compatibility, a familiar ribbon UI, and seamless migration from Microsoft Office.

  1. 1. Download WPS Office: Go to the WPS Office official download page and click Download WPS Office Free.
  2. 2. Open SharePoint documents: Launch WPS Writer, Spreadsheets, or Presentation and open the .docx, .xlsx, or .pptx file downloaded from SharePoint.
  3. 3. Edit and save: Make changes and use Save As to keep the same Microsoft Office format before uploading back to SharePoint.
Opens and edits Word, Excel, and PowerPoint files downloaded from SharePoint without reformatting document librariesFull compatibility with Microsoft Office .docx, .xlsx, and .pptx formatsLightweight installer and familiar ribbon interface reduce migration effortFree to download and use for daily document tasks while you troubleshoot SharePoint Server issues
microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint 2016 return user-not-found when JavaScript creates items with a Person or Group field?

SharePoint resolves Person or Group columns against the User Profile Service. If the supplied display name, email, or login name does not exactly match a unique user profile, the create request can fail with user-not-found or user-not-unique.

How can I bulk create SharePoint 2016 list items without repeated JavaScript REST calls?

Use PowerShell with SharePoint CSOM. Load the SharePoint client assemblies, connect with ClientContext, call context.Web.EnsureUser to resolve each Person or Group value once, then create and batch ListItem objects.

What information should I include when posting a SharePoint 2016 import issue to the SharePoint Developer Community?

Include sanitized JavaScript or PowerShell code, the list and Person or Group field schema, a sample payload, and the exact server error or ULS log message. Remove URLs, passwords, and internal names.

Can WPS Office manage SharePoint 2016 list import settings?

No. WPS Office is not a SharePoint Server administration tool. It can open, edit, and save Office documents stored in or downloaded from SharePoint, but PowerShell and CSOM are required for server-side list imports.

Does WPS Office preserve Microsoft Office formats when I upload files back to SharePoint?

Yes. WPS Office supports .docx, .xlsx, and .pptx and can save in the same Microsoft Office formats, so documents remain compatible with SharePoint document libraries.