Term Store Terms Displaying Extra Characters

Question

Hello,

I'm creating a workflow to send an e-mail when an item is created in a list to display certain fields with a message in the e-mail.  The list contains columns with terms from the managed term store. I do not have this problem using a regular column.

 

Data Source: Current Item

Field from source: ManagedTerms

Return field as: I've tried both "String" and "Plain text"

 

If the ManagedTerm = Hotdog, I will get the a similar value to "Hotdog|d6665b83-9cca-4900-a8ce-704600ba14ee" as the string or plain text value in the e-mail.  How do I get rid of the extra values after the term?

Answer 1

This has to do with the way that managed metadata is stored in the site.  I think the only way to get around this would be to create a variable in the workflow and do some type of trim operation that removed the | and everything after that.  Either that or you would have to develop some type of custom action or solution that allowed you to work with managed metadata in the workflow.  This is just one of those areas that gets a little tricky when managed metadata is used.

---

~Jennifer Mason ~My Blog~ ~SharePoint Support~ ~SharePoint Training~ ~Follow me on Twitter!~

Answer 2

If you use the term store API, you will get just the term.

I assume you're reading the list data directly.

---

- cawood

 blog |  twitter

Answer 3

If you use the term store API, you will get just the term.

I assume you're reading the list data directly.

---

- cawood

 blog |  twitter

Yes, I am using the out of the box features that come along with SP/SP Designer to get this accomplished from the list data directly.  

I'm fairly new to SharePoint.  I took a Microsoft SP classes which included workflows but the data was always pulled straight from a list.  Do you have a link to a tutorial or blog that explains how to use the term store API with the workflows?  

Answer 4

Can someone help with this problem?  I would imagine you can get rid of these extra characters if you pull the information into a workflow using SP designer..

Answer 5

Hi dc5guy,

Jennifer is correct. Please use Custom Activity to remove the GUID, which is easier than using Term Store API.

There have some String activities in the CodePlex:
SharePoint Designer Workflow String Actions: http://spdwfstringactions.codeplex.com/

Please install it, and then use IndexOf and SubString to get  rid of the GUID.

Thanks,
Jinchun Chen

---

Jin Chen - MSFT