Get Metadata Termstore column value in a Nintex Workflow
You can evaluate a Managed Metadata term value with the following actions:
- Set variable
- Query list
Let's compare the approaches.
In this example, I use a custom list named Routing and added a Managed Metadata column named Office. The column Office is restricted to a single Matadata value.
The column refers to a term set named Offices:
I tagged an item with Berlin.
1/ “Set variable” action
Let us use the following actions:
Used actions in detail:
Result:
Office: Berlin|27ed5e3e-5191-412f-affa-e5a8f0911e22
This is the string implementation of Managed Metadata term Berlin. It consists of 3 parts: <value> | <GUID>
To extract string Berlin from variable txt_term you can use RegEx for instance - Pattern in clear text: ([^\|]*)\|(.*)
2/ "Query list" action
Query list action in detail:
Result:
Office: Berlin
Conclusion
To extract a Managed Metadata term value the "Query list" action approach is very simple.
In complex scenarios, where you have to compare the GUID explicitly or you do not want to name the list explicitly, you can use "Set variable" action instead.