When you send an email via a workflow with managed metadata items they look like TERM1|ifdijfigjdiojgikdjfgidjgildjlgk.

I have tried with the new Microsoft flow and it does exactly the same (before I tried with SharePoint designer workflows).

Is there a way to clean up the code portion in order to show just the Term either in SPD Workflow or Flow? By chance is it exactly the same process? (additional 2 columns with copy=paste and removal of the extra letters with a formula?)

enter image description here


in MS Flow you can use Managed Metadata Columns Label something like this

enter image description here

and then you'll get only text


When you go to use the field in flow, there should be several entries, including:

  • MyMetaField Label
  • MyMetaField Path
  • MyMetaField Value
  • MyMetaField TermGuid

The value field is as you described, but the label field should be just the content the user sees, such as "TERM1" in your example.

Edit: To handle a multi-select managed metadata field, add the following steps prior to the email:

Data Operations - Select:
From: MyMetaField
Map: MyMetaField Label

(the map property will need to be switched to "text" mode, via the button to the right. It should only display a single textbox, not a table with two columns).

The above will generate an array with one column that has the label values. then, add the following action:

Data Operations - Join:
From: Select Output
Join With: ;

The above will generate a semi-colon separated list of the labels. Of course, feel free to replace the ; with whatever.

In the email, use the output from the join operation.

  • I have done Label now, since it was multiple items in the same field it sent an email for each item...
    – susan
    Sep 9 '19 at 14:48
  • I edited the answer to include steps for a multi-select managed meatadata field
    – Mike2500
    Sep 9 '19 at 15:16
  • when you say prior to the email you mean in the body?
    – susan
    Sep 10 '19 at 10:08
  • In flow, the "send email" step is an action. The two actions I outlined would go prior to the email action, so that you can use the output of those steps in the email.
    – Mike2500
    Sep 10 '19 at 12:40
  • If I add an action, it asks me if it is a condition or else, what is it?
    – susan
    Sep 10 '19 at 12:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.