Fix Word SharePoint Lookup Field Displaying ID Instead of Text
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.

- 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 attempting these workarounds, ensure you have sufficient permissions to modify your SharePoint document library columns and create workflows in Power Automate.
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.
Navigate to your SharePoint document library settings and replace the existing Lookup column with a new Choice column.
Open Power Automate and create a new flow that triggers whenever a file is created or modified in your document library.
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.
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 Word Dropdown Content Control as a Building Block
Bypass SharePoint lookup properties entirely by storing a dropdown content control as a Quick Part in a global Word template.
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. Download the Software: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install and Launch: Follow the simple installation prompts, then open WPS Writer on your device.
- 3. Open Your Documents: Directly open your existing .docx files and enjoy seamless editing without unexpected formatting loss.

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.




