SharePoint Document Issues

Fix Word SharePoint Lookup Field Displaying ID Instead of Text

Adam DavisAdam Davis Oct 23, 2026 868 views

Question details

The user needs to resolve an issue where a SharePoint lookup property inserted into a Word document displays an ID number rather than the actual text.

Fix Word SharePoint Lookup Field Displaying an ID Instead of Text
Product
Microsoft Word, SharePoint
Device & OS
not provided
Scenario
Inserting a SharePoint lookup property into a document via Word Quick Parts.
Observed behavior
The lookup field may initially show the correct selected item name but subsequently reverts to displaying only the document or lookup index number/ID.
Before you start

Before attempting these workarounds, ensure you have sufficient permissions to modify your SharePoint document library columns and create workflows in Power Automate.

Solution 1Recommended

Use a Choice Column and Synchronize via Power Automate

Replace the problematic Lookup column with a Choice column in Word and use Power Automate to keep the values synchronized with SharePoint.

Lookup columns natively struggle to display text in Word Quick Parts, often defaulting to the item's index number. By migrating to a Choice column within the document template, the text will render correctly.

To maintain data integrity, you can automate the synchronization between the SharePoint list and the document's Choice column.

1
Create a Choice Column

Navigate to your SharePoint document library settings and replace the existing Lookup column with a new Choice column.

2
Set Up Power Automate

Open Power Automate and create a new flow that triggers whenever a file is created or modified in your document library.

3
Retrieve the Text Value

Add an HTTP request action using the SharePoint REST API within your flow to retrieve the actual text value of the item ID from the source list.

4
Update the File Properties

Add an 'Update file properties' action to synchronize the retrieved text into the newly created Choice column, ensuring it displays correctly in Word.

Use a Choice Column and Synchronize via Power Automate
API Requirement: Using the SharePoint REST API requires a basic understanding of HTTP requests and JSON parsing in Power Automate.
Free Microsoft Office alternative

Edit Documents Without the Hassle Using WPS Office

If complex SharePoint integrations and Word formatting bugs are slowing down your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling your daily document editing needs without unexpected display errors.

  1. 1. Download the Software: Visit the official WPS Office website to download the free installation package for your operating system.
  2. 2. Install and Launch: Follow the simple installation prompts, then open WPS Writer on your device.
  3. 3. Open Your Documents: Directly open your existing .docx files and enjoy seamless editing without unexpected formatting loss.
Free to download and use with a highly intuitive user interfaceSeamless compatibility with Microsoft Word (.docx) formatsLightweight architecture ensures large files open quicklyRobust support for standard document formatting and content elements
microsoft office alternative - wps office

Frequently Asked Questions

Why does the Word Quick Part show a number instead of my text?

Word Quick Parts often fail to correctly parse the display values from SharePoint Lookup columns. Instead of fetching the associated text, it defaults to rendering the underlying index number or ID associated with that list item.

Can I use the SharePoint REST API to fix this issue?

Yes, you can use Power Automate to make a SharePoint REST API call that retrieves the correct text value based on the item ID, and then automatically updates a separate Choice column to display properly in Word.

Is it possible to avoid using SharePoint properties in Word altogether?

Absolutely. You can rely on native Word tools by inserting a Dropdown List Content Control from the Developer tab and saving it to your global template's Quick Parts gallery for easy access and reuse.