Managed Metadata
Common Use Cases
- Department and region tagging: one Departments term set powers columns, filters, and views on every site, so HR, Human Resources, and H.R. never drift apart
- Client and project taxonomies: tag deliverables across many sites with the same client list, then roll related content up by client in search and highlighted content
- Document type classification: a Document Types term set paired with content types keeps contracts, policies, and reports consistently labeled across libraries
- Records and compliance: retention and classification rules key off standardized term values instead of unreliable free text
- Multilingual intranets: terms carry labels in multiple languages, so users tag and filter in their own language while the underlying term stays one record
- Search refinement: managed metadata values can drive search refiners, letting users narrow results by department, region, or product
Benefits
- One dictionary for the whole tenant: terms are defined once in the Term Store and reused by every site, list, and library
- Central renaming: rename a term once and every item already tagged with it updates automatically
- Synonyms and hierarchy: other labels catch users’ shorthand, and parent-child terms let people tag broadly or precisely
- Cleaner data entry: type-ahead suggestions against official terms eliminate misspellings and duplicate values
- Governance built in: layered roles for administrators, group managers, and contributors keep the taxonomy maintained without opening it to everyone
- Scales with the organization: support for up to 1 million terms per tenant means the taxonomy grows as the company does
How It Works
The Term Store is the central dictionary. It holds term groups, which hold term sets (like Departments or Document Types), which hold the individual terms users pick from.
- Global and site-level scopes: global term sets are managed centrally and available to every site, while site-level term sets stay local to the site that created them.
- Column scope: a Managed Metadata column points at one term set, or one branch of it, and users tag items by typing ahead or browsing the term tree.
- Synonym matching: typing matches other labels too, so ‘HR’ can resolve to ‘Human Resources’.
- Reuse and central renaming: terms can be reused or pinned into other term sets, and renaming a term updates every item already tagged with it.
- Layered roles: Term Store administrators manage everything, group managers own their term groups, and contributors maintain individual term sets.
Settings
A Managed Metadata column has a handful of options of its own, while the term set behind it carries its own settings in the Term Store.
- Term set: pick the term set, or a specific term within it, that the column draws from.
- Allow multiple values: users can apply several terms to one item.
- Allow fill-in: lets users add new terms on the fly; only works when the term set’s submission policy is open.
- Default value: pre-tag new items with a term so content is classified even when users skip the form.
- Submission policy: an open term set accepts new terms from users, while a closed set only accepts terms from designated contributors.
- Term set management: languages, synonyms (other labels), descriptions, custom sort order, and term deprecation are all maintained on the term set itself.
Limits and Nuances
- Still a column: Managed Metadata lives on lists and libraries like any other field, so it must be planned into views and forms.
- Lookup threshold: Managed Metadata counts toward the 12-column List View Lookup Threshold alongside Lookup and Person columns, so budget view columns accordingly.
- Needs an owner: plan the taxonomy up front and assign Term Store managers, because routine changes go through them.
- Closed term sets block fill-in: users cannot add terms unless the set’s submission policy is open and the column allows fill-in.
- Tenant limits: 1 million total terms, 1,000 global term sets, and 1,000 global term groups.
- Large term sets slow the picker: keep the sets users browse to a manageable size and use hierarchy to organize them.
- No sorting on multi-value columns: multi-value Managed Metadata columns cannot be sorted in views; use a single-value column where sorting matters.
- Calculated column restriction: formulas cannot reference Managed Metadata columns.
- Training matters: a taxonomy only works when people pick the right terms, so add term descriptions, defaults, and synonyms to guide them.
- Not every scenario needs it: for a short, stable value list used on one site, a Choice column is the simpler out-of-the-box tool.
Common Questions About Managed Metadata
What is Managed Metadata in SharePoint?
Managed Metadata is SharePoint’s centralized tagging system. Terms – like department names, regions, or document types – are stored once in the Term Store and reused across every site in the tenant. Users tag documents and list items by picking from the official terms instead of typing free text, which keeps spelling and naming consistent and makes filtering and search dramatically more reliable.
What is the Term Store?
The Term Store is the central dictionary behind Managed Metadata. It lives in the SharePoint admin center under Content services and organizes everything in a hierarchy: term groups contain term sets, and term sets contain the individual terms users pick from. Term Store administrators, group managers, and contributors maintain it, and changes made there flow to every column that uses the affected term set.
What is the difference between Managed Metadata and a Choice column?
A Choice column stores its values inside one list, so the same options retyped on another site can drift apart. Managed Metadata stores terms centrally and shares them tenant-wide, with extras a Choice column lacks: hierarchy, synonyms, multilingual labels, and central renaming. The trade-off is governance – the Term Store needs an owner. For a short value list used in one place, a Choice column is the simpler tool.
Can users add their own terms to a Managed Metadata column?
Only when two settings line up. The column must have Allow fill-in enabled, and the term set it points to must have an open submission policy in the Term Store. If the term set is closed – the common choice for governed taxonomies like departments – users can only pick from existing terms, and new ones must come from the term set’s designated contributors or managers.
How many terms can the SharePoint Term Store hold?
SharePoint Online supports up to 1 million total terms per tenant, with limits of 1,000 global term sets and 1,000 global term groups. Those ceilings are far beyond what most organizations ever need – in practice, the real constraint is usability, since a term set with thousands of entries becomes hard to browse in the picker. Keep the sets users interact with focused and use hierarchy to organize them.
Who should manage the Term Store?
Someone has to own it – that is the difference between a taxonomy that works and one that decays. Most organizations name one or two Term Store administrators centrally, then delegate term groups to the departments that own the vocabulary, such as HR owning the job titles set. Greg Zelfond, the consultant behind LookBook 365, builds this governance into every Managed Metadata rollout, because untended term stores fill with duplicates fast.