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.

SharePoint Designer and its sister product, Microsoft Expression Web are successors of Microsoft FrontPage. While Expression Web serves as the full-featured successor to FrontPage, SharePoint Designer focuses on designing and customizing Microsoft SharePoint websites. For instance, it only includes SharePoint-specific site templates. The first version, SharePoint Designer 2007, retains more FrontPage features than Expression Web (such as web components, database, marquee, hit counter, navigation bars and map insert.) SharePoint Designer 2007 was initially a commercial software product. On March 31, 2009, however, SharePoint Designer 2007 was made available as a freeware.

On April 24, 2009, Microsoft released SharePoint Designer 2007 Service Pack 2. On April 21, 2010, SharePoint Designer 2010 was released and made available for download. On October 24, 2011, Microsoft released SharePoint Designer 2007 Service Pack 3.

SharePoint Designer 2010, the successor to SharePoint Designer 2007, was released to web on April 21, 2010 in two flavors for IA-32 and x64 CPUs. Unlike its predecessor, however, it does not operate in absence of Microsoft SharePoint Server or Microsoft SharePoint Foundation and therefore cannot be used as a generic HTML editor.

On October 30, 2012, Microsoft released SharePoint Designer 2013.[1] This was the last version of SharePoint Designer; following the announcement of SharePoint 2016 in Ignite 2015 conference, Mark Kashman, Senior Product Manager of Microsoft announced that a corresponding SharePoint Designer would not be released with this product.[2][3]

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()