locked
SPD Workflow Compare Managed Metadata Field Value RRS feed

  • Question

  • Hi all,

    I am trying to compare a Managed Metadata field value for my workflow via an IF condition but running into issues because I need the correct format for a Managed Metadata term.

    Per number 6 of this post, it would appear that the format is "termlabel|guid" but I can get it to work.

    http://www.sharepointanalysthq.com/2011/06/managed-metadata-column-limitations/

    How have others referenced Managed Metadata values in their SPD workflows. All I need to do is a create a simple IF statement for "IF MYTaxonomyField equals TermLabel|GUID" then "Log this".


    Personal Blog: http://thebitsthatbyte.com

    Wednesday, February 29, 2012 7:56 PM

Answers

  • Found a way around it. The GUID that gets logged is not listed in the TaxonomyHidden list (Lists/TaxonomyHidden) so I created a list with a simple List Workflow that sets the value of a text field named GUID to the "ManagedMetadataField_0" Field that someone selects (ex. a MM field is named "MYMMs" and another field is named "MMGUID", the workflow sets the "MMGUID" field to the value obtained from the "MYMMs_0" field.) 

    Important: In SharePoint Designer you will see two fields for your Managed Metadata field, the one with the _0 after is the one you want to use to retrieve the GUID. This is the GUID you will use in the comparison aspect of a workflow (The IF condition).


    Personal Blog: http://thebitsthatbyte.com

    Wednesday, February 29, 2012 9:11 PM

All replies

  • I have also looked at the "hidden" taxonomy list and the GUID I retrieved via logging a current item field is not listed. What is the best way to find the "real" GUID of a taxonomy term?

    Personal Blog: http://thebitsthatbyte.com

    Wednesday, February 29, 2012 8:27 PM
  • Found a way around it. The GUID that gets logged is not listed in the TaxonomyHidden list (Lists/TaxonomyHidden) so I created a list with a simple List Workflow that sets the value of a text field named GUID to the "ManagedMetadataField_0" Field that someone selects (ex. a MM field is named "MYMMs" and another field is named "MMGUID", the workflow sets the "MMGUID" field to the value obtained from the "MYMMs_0" field.) 

    Important: In SharePoint Designer you will see two fields for your Managed Metadata field, the one with the _0 after is the one you want to use to retrieve the GUID. This is the GUID you will use in the comparison aspect of a workflow (The IF condition).


    Personal Blog: http://thebitsthatbyte.com

    Wednesday, February 29, 2012 9:11 PM
  • I found that the pattern "Termname|GUID", e.g. "Approved|7ea7b335-fba1-443a-b53a-e2f5ed72ea49" works in SPD workflow both for setting value and doing comparison in an IF statement.

    I also found that the GUID, contrary to what Kelly says can be found in the TaxonomyHiddenList (<siteURL>/lists/taxonomyhiddenlist), it is the value in the "IdForTerm" column of the list for each record, respectively.


    Monday, June 18, 2012 10:00 AM