Resources For IT Professionals
Post an article
Wikis - Page Details
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2013 Best Practice: Lookup or Taxonomy (managed metadata) column

SharePoint 2013 Best Practice: Lookup or Taxonomy (managed metadata) column

SharePoint 2013 Best Practice: Lookup or Taxonomy (managed metadata) column

Well, first of all, you have to consider some boundaries that may affect your choice. In a list you can have a max of 32 choice fields, and 16 lookup fields (check http://social.technet.microsoft.com/wiki/contents/articles/12438.sharepoint-2013-best-practices.aspx#Capacity_Planning for details).

If you're not impacted by these constraints, my choice would be like this:

  • A choice column is very informal and for a limited list of choices that doesn't change that often it's the preferred choice.
  • List lookups are great for managing larger amounts of data, while still remaining the informality that makes it inviting to change. Also, people only need list contributor permissions to make adjustments.
  • Taxonomy is more formal and most powerful, as it also supports hierarchical structures. So if you need hierarchy or need to manage a formal dictionary within the organization, the best option.

See also

See SharePoint 2013 Best Practices: http://social.technet.microsoft.com/wiki/contents/articles/12438.sharepoint-2013-best-practices.aspx#Capacity_Planning

, , , , , [Edit tags]
Leave a Comment
  • Please add 6 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
Page 1 of 1 (2 items)