Skip to content

What Me Pa..Panic?

A BLOG about SharePoint & O365 Administration, Design, Development, and Customization . . .

  • Don’t Pa..Panic Consulting
  • About Me
  • Contact Me
  • RSS feed
  • Twitter
  • Facebook
  • LinkedIn

Upcoming Events

M365 Twin Cities

EduCon DC 2023

Archive

Tag Cloud

Admin Anonymous_Access ASP.NET Branding Certification Development External_Sharing Flow General Hybrid Installation MCM Microsoft Forms MVP News Office_365 Office_365 Updates OneDrive_NextGenSync Power Apps PowerApps Power Automate Power Virtual Agents Security Service_Packs SharePoint SharePointFest SharePoint_2007 SharePoint_2010 SharePoint_2013 SharePoint_2016 SharePoint_2019 SharePoint_Designer SharePoint_Online ShareSquared Slide_Decks Speaking SP_Saturday Strategy Tips Training Upgrading User_Group User_Profiles Virtualization WCM

SharePoint’s Managed Metadata service is NOT case sensitive

I’ve done programming in a variety of environments over the years.  Case sensitivity was one of the things that was the most difficult for me to get used to when I moved from VB to C# a number of years ago.  In fact if it weren’t for Intellisense I would probably still be swearing at C# on a regular basis. I’ve learned to live with, and even make use of, case sensitivity in my C# programs over the years.  But it doesn’t come naturally.  I still tend to think in a case insensitive fashion. 

As a result I was somewhat surprised to run into someone having an issue recently when trying to add SharePoint Managed Metadata terms to a user profile programmatically.  They reported that SharePoint wasn’t consistent when adding terms to the Ask me About profile field programmatically.  It turns out that the real problem was that they had duplicate fields where the only difference was the case of the first character of the abbreviation.  After some investigation here’s what I discovered.

  1. SharePoint won’t let you add two metadata terms under the same parent if the only thing that differs is the case sensitivity of the term.  The image below shows what happens if you try to add “ABC” as a term when “Abc” already exists under the same parent term.

    mms error1

  2. You can add (but probably shouldn’t) a term that differs only based on case sensitivity if you also change the hierarchy that the term inherits from.  The image below shows the same “ABC” term added to a different parent.  This time the addition is successful.

    MMS 2

  3. When you try to add any combination that starts with abc to a managed metadata column you get both terms.  You can of course choose the one you actually want, but that’s based on the hierarchy of the term, not its case sensitivity.

    mms3

The lesson here is that unlike some things like C#, the Managed Metadata service is NOT case sensitive.  You should try to avoid adding terms to the service that differ only based on case sensitivity.  This is particularly true if you intend to add managed metadata to fields programmatically.

Published by

Paul Papanek Stork

I am a SharePoint MVP who has specialized in Microsoft products since the mid-1990s. As a "Jack of all Trades" I have developed expertise as a network administrator, developer, and DBA. I works as a consultant/trainer where my breadth of knowledge makes me ideally suited to combine Administrative, Development, and SharePoint Designer topics. My 20+ years of experience and broad background make me a much sought after resource for SharePoint questions that cross traditional boundaries. I was a contributing author to the Developer's Guide to Windows SharePoint Services v3 Platform and the SharePoint Server 2007 Deployment Best Practices. My most recent book, the MCTS Windows SharePoint Services 3.0 Configuration Study Guide: Exam 70-631, was released in October, 2009. View all posts by Paul Papanek Stork

Posted on November 1, 2011November 1, 2011Author Paul Papanek StorkCategories SharePoint 2010 DevTags Development, Managed_Metadata, SharePoint_2010, User_Profiles

Post navigation

Previous Previous post: Best Practices for SharePoint 2010 Upgrade & Configuration
Next Next post: SharePoint Saturday: Denver – Nov. 11-12
Proudly powered by WordPress