Use a SharePoint Online Managed Metadata Column in a Lookup
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.

- 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.
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.
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.
In the source list, select Add column > Single line of text, name the column, and save it.
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.
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.

Synchronize a metadata label to a text column with Power Automate
Use a flow to reduce manual updates when a lookup should display the label of a managed metadata term.
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.

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.




