SharePoint Document Issues

How to Fix SharePoint Person Fields Changing to Numbers in Linked Access Tables

Maira MehtabMaira Mehtab Oct 29, 2026 870 views

Question details

The user needs a way to prevent SharePoint Person or Group fields from converting into numeric data types when transferred to another list via linked Microsoft Access tables.

How to Fix SharePoint Person Fields Changing Data Type in Linked Access Tables
Product
Microsoft SharePoint and Microsoft Access
Device & OS
not provided
Scenario
Transferring user data between SharePoint lists using linked tables and append queries in Microsoft Access.
Observed behavior
Microsoft Access converts the SharePoint Person or Group field into a numeric (Long Integer) field instead of preserving the user's display name or email.
Before you start

Ensure you have the necessary site permissions to create or modify workflows in SharePoint and edit the design of your linked Microsoft Access tables.

Solution 1Recommended

Use a SharePoint Workflow to Extract Text Values

Create a workflow to copy the display name and email into plain text columns before linking to Access to prevent data type conversion.

SharePoint Person or Group fields are essentially lookup columns. When Access links to them, it often pulls the underlying numeric ID instead of the text string. By extracting the text directly into a separate column, you bypass this conversion.

1
Create new text columns in SharePoint

Go to your original SharePoint list (List A). Open the list settings and add two new 'Single line of text' columns named 'User Display Name' and 'User Email'.

2
Build an extraction workflow

Open SharePoint Designer or Power Automate. Create a new workflow that triggers automatically whenever an item is created or modified in List A.

3
Extract the person data

Add actions to set the values of 'User Display Name' and 'User Email'. Configure these actions to extract the respective string values from the original Person or Group field.

4
Run the append query in Access

Refresh your linked tables in Microsoft Access. Modify your append query to use these new plain text columns instead of the Person field. This transfers the data to the destination list without data type conversion issues.

Use a SharePoint Workflow to Extract Text Values
Data Preservation: Passing text values via Access preserves the readable data, allowing the destination list to display the correct names and emails without numerical errors.
Free Microsoft Office alternative

Looking for a Lightweight and Free Alternative to Microsoft Office?

While complex database mapping between SharePoint and Access requires Microsoft's specific ecosystem, everyday document management and data analysis can be handled efficiently with WPS Office. Enjoy a free, all-in-one office suite that is highly compatible with Microsoft Word, Excel, and PowerPoint formats.

  1. 1. Download the Installer: Visit the official WPS Office website to download the free installer for your operating system.
  2. 2. Install WPS Office: Run the installer and follow the quick on-screen instructions to set up the lightweight office suite.
  3. 3. Open Your Documents: Launch WPS Office and directly open your existing Microsoft Office files. All formatting and formulas will remain intact.
Seamlessly open, edit, and save Microsoft Office formats (.docx, .xlsx, .pptx) without compatibility issues.Manage data, build reports, and analyze spreadsheets effortlessly with WPS Spreadsheet, an excellent alternative to Excel.Lightweight software that runs smoothly on Windows, Mac, Linux, iOS, and Android.Familiar user interface with tabbed document viewing for maximum productivity without a steep learning curve.
QA img-9

Frequently Asked Questions

Why does Microsoft Access convert SharePoint Person fields to numbers?

SharePoint stores Person or Group fields as lookup values linked to a hidden User Information list. Access retrieves the ID (a numeric value) of the lookup record rather than the display text you see in SharePoint.

Can I change the data type of a linked SharePoint list directly in Access?

No, you cannot modify the design or data types of linked SharePoint tables directly within Microsoft Access. All structural changes must be made via the SharePoint list settings.

Will exporting an Access query with the numeric user ID work if I import it back to SharePoint?

If the destination SharePoint list also relies on a Person/Group field, directly mapping the numeric user ID might fail or display incorrectly because the user ID mappings might not align perfectly. It is safer to pass plain text emails or claim strings.