Managed Metadata column is a lookup column that points to the hidden system list in SharePoint, named TaxonomyHiddenList. This list contains column values in other languages, as well as other metadata. You can use the ManagedMetadataColumn function to retrieve Managed Metadata column values in your preferred language.
Returns Managed Metadata column values from a selected term set of managed terms.
The ManagedMetadataColumn function syntax has the following arguments:
- ManagedMetadataColumn Required. The column name of the Managed Metadata column in your Sharepoint list or library.
- TermXXXX Required. The LCID decimal language code of which you want to display the term (e.g., Term1033 returns the English value of the term and Term1036 returns the French value of the term).
- To use the function, you need to add content controls to a JungleDocs template.
- There is a known issue when generating a report or using functions to access other lists (e.g., GetView()). Managed Metadata column default values will be in the default site language, not in the current UI or user language.
In the picture above, we have a document library with a Managed Metadata column named Document type.
To get the English values of the Document type, we use Document type: Term1033 in the Tag field of a content control. To get the French values, we use Document type: Term1036 or simply drag the placeholders from a sample document.