How To Use Text Columns in a Workflow Conductor Widget Condition

How To Use Text Columns in a Workflow Conductor Widget Condition

APPLIES TO
The following widgets in Workflow Conductor 1.1 and higher:

  • Conditional Branch
  • Compare
  • Repeat While
  • Wait For Field Change
  • Repeat For Each Item (Workflow Conductor 1.5 and higher)
  • Field Lookups
  • External List Lookups

Some Widgets in Workflow Conductor allow you to specify a condition that must be met in order for the Widget to run. If the condition is comparing a value with a SharePoint Single line of text, SharePoint Multiple lines of text column, or Bamboo Rich Text column, here are some important tips:

  • When matching text strings, use less specific match conditions. For example, use Contains instead of Equal To.

  • Comparisons are case-sensitive. “Text” and “text” are different strings and will not match.

  • If you change the settings for a SharePoint Multiple lines of text column from Plain text formatting to Rich text or Enhanced rich text formatting, an Equal To condition that worked before may stop working. This is because a rich text field contains non-printing characters, even if the text does not appear formatted.

  • Field Lookup conditions that require an Equals match will not match Bamboo Rich Text columns or SharePoint Multiple lines of text columns formatted as Rich text or Enhanced rich text. Perform the lookup using a different column in the list.

The Field Lookup conditions shown here will not match any items, even if the text appears to match the column text:
sa08_kb12555_04.jpg sa08_kb12555_06.jpg

For Bamboo Rich Text and SharePoint Multiple lines of text columns configured for rich text or enhanced rich text formatting, be aware that any text formatting adds non-printing characters that can make the condition false.

The conditions shown below will not match if the word “text” is in bold in the list column:
SA08_kb12555_01.jpg SA08_kb12555_02.jpg
SA08_kb12555_03.jpg