How to get metadata column value in SharePoint Designer Workflow 2010 or 2013 ?
For getting metadata column in SPD, create one calculated column for metadata and then get calculated column in workflow.
We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.
This is a related question also asked around the same topic.
Here is a good resource around Parsing managed metadata value for sharepoint designer workflows
A typical structure would be something like
“TX | c61d9028-824f-446e-9389-eb9515813a42”
Basically, you have to
- Pick the value from the column
- Split the value based on
- Copy the zeroth index element to the destination variable and trim it.
To get the field in SPD wf -
- Choose action - set
- In the value section (popup when you click
value)- choose the
data sourceas the list which you are fetching the column from -
- In the
field from source- choose the managed metadata column internal name
- In the
find in the list item section- choose the
IDand value to be
CurrentItem -> ID(should look like
- Click on OK. This should get you value of the managed metadata column.
- If you want, you can use the action
Log item to the history listto check the value.
You need to search on the basis of the internal name of the column. In order to find out the internal name of the column - Go to -
List -> List Settings -> Scroll Down to Columns Section -> Click on the Managed Metadata Column The url should look something like this -
Field's value is the internal name of the column