Others

Use a SharePoint Online Managed Metadata Column in a Lookup

John WilsonJohn Wilson Nov 13, 2026 868 views

Question details

The user wants to use a Managed Metadata column from one SharePoint Online list as the source for a lookup column in another list.

Use a Managed Metadata Column in a SharePoint Online Lookup
Product
SharePoint Online
Device & OS
not provided
Scenario
Create a lookup relationship between two lists without tagging the same information twice.
Observed behavior
The Managed Metadata column was created successfully but does not appear among the available source columns when configuring the lookup.
Before you start

Identify the source list, its Managed Metadata column, and the destination list. Check that you have permission to edit both lists and, if using automation, create a Power Automate flow.

Solution 1Recommended

Use a text column as the lookup source

Use a supported single line of text column when you can maintain a text representation of each metadata value in the source list.

1
Add a text column

In the source list, select Add column > Single line of text, name the column, and save it.

2
Enter lookup values

Open each source list item and enter the value you want displayed in the new text column. Use distinctive values if similar term labels could be confused.

3
Create the lookup

In the destination list, select Add column > Lookup. Choose the source list and select the new text column as the column to display, then save.

Use a text column as the lookup source
Keep the text current: The text column is separate from Managed Metadata. Update it when the term changes, or use Power Automate to synchronize it.
Free Microsoft Office alternative

Work with Office files in WPS Office

WPS Office is a free, lightweight alternative for working with Office documents, spreadsheets, and presentations. Its familiar interface and format compatibility make moving everyday file work straightforward, although it does not fix SharePoint lookup limitations.

Review and edit list data exported to a spreadsheetOpen and edit Microsoft Office formats including DOCX, XLSX, and PPTXUse familiar document, spreadsheet, and presentation toolsGet started with a free, lightweight Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is my Managed Metadata column missing from the lookup settings?

SharePoint Online does not support Managed Metadata columns as source columns for standard lookups. Creating the metadata column successfully does not make it available in the lookup column selector.

Can I display a metadata term in a lookup anyway?

Yes, as text. Add a Single line of text column to the source list, populate it with the term label, and select that column when creating the lookup in the destination list.

Will a lookup to a text column preserve the managed term's identity?

No. The lookup references the source list item and displays its text value; the text itself does not carry the managed term's identity or hierarchy.

How can I avoid typing the same term label twice?

In Power Automate, use the SharePoint trigger When an item is created or modified and an Update item action to copy the metadata label into a text column. Add a condition so the flow updates only when the values differ.

What happens if a metadata term changes?

A manually maintained text column will not automatically follow the change. Update the source item's text value or use and test a Power Automate flow to synchronize it.