Finding TaxonomyHiddenList

Recently, I needed to view some additional information about the meta-data defined for a client. I tried using SharePoint Designer 2010 to view the TaxonomyHiddenList, but the list does not show up for some reason (if I am missing something, someone educate me please).

Some digging in PowerShell to get all lists for a given site gave me enough information to go on and then by simply pointing my browser to [site url]/Lists/TaxonomyHiddenList/AllItems.aspx I was able to get the information I needed.

Taxonomy Hidden List Item

By the way, once you have the information like the ID, TermSetId and others (see the List Settings for the list schema), you can then query for list items based on meta-data and many other things using custom code. Peter Holpar has a great post, Some words about TaxonomyFieldValue and its WssId property, for using this information in custom solutions.

Hope this helps someone else in the future.

Pete SkellyFinding TaxonomyHiddenList
  • sapnashenoy82

    Hi am using a metadata field with multiple selection,trying to display the text in emial thru SPD workflow..
    it shows the whole string value|GUID..Am trying to get just the value..Could you please let me know how i can get values from taxonomyhiddenlist?

    • http://www.threewill.com pskelly

      @sapnashenoy82 Since the values come back formatted as you indicated, this is a limitation of the taxonomy field implementation.  Have a look at the blog post from Marc Anderson on the known resolution to this issue.  http://sympmarc.com/2012/11/09/displaying-managed-metadata-column-values-in-an-email-sent-from-a-sharepoint-designer-workflow/

  • Pingback: Taxonomy Hidden List | SharePoint interests()