🧡 Skip to main content🔎 Skip to search

The Options tab of Lookup Text Action allows you to choose whether the text search will be case sensitive or insensitive. Select the text matching type, and provide the default value when a lookup key is not found.

Matching type Choose how the text lookup will be performed on the key column:
  • Exact · requires that the value you want to look up exactly matches a value on the key column.
  • Starts with · the start of text strings must match.
  • Contains · the key value must contain the lookup value. Or in other words—the lookup value must be part/substring of the key.
  • Ends with · the end of text strings must match.
Ignore case When enabled, upper and lower case text will be treated as equivalent. When disabled, search will treat upper and lower case characters as distinct symbols.
If not found Define the default behavior in case when the lookup value is not present in the key column:
  • Return original input value · the input value will be returned as an output value.
  • Provide a new custom value · the specified custom value will be used instead.
Also, store result inThe result of the search operation is already accessible via the Variable Wizard. Optionally, choose an existing variable to store the result. To create an empty variable, use the Set Variable Action.
Variable WizardVariable Wizard buttonUse dynamic data input—substitute a parameter from a file, web, connected Trigger, other Actions, date and time presets, etc.
This Action is enabledAn Action is executed only if it is enabled. Otherwise, it will be automatically skipped (completely ignored) from the Task flow.
Use custom display nameRename this Action, to make a human-readable workflow that will help you to find, read, and make sense of the Task structure later.
Advanced fallback optionsManage the advanced fallback options—select which error types will lead to automatic execution of predefined workaround operations.
Log only errorsDo not log information and warning messages for this Action. It may be useful to keep the log file small and tidy on production systems.

Help at your fingertips…

If you have any questions, please do not hesitate to contact our support team.