ArrayContains
The ArrayContains function searches for a specific value in a list (or array). If the value is found in the list, the function returns "True," otherwise it returns "False."
Syntax
ArrayContains(list, target)
Function arguments:
- list (required) - the column containing the list to search
- target (required) - the column containing the value to find
The list argument must reference a list parameter or a column containing list values. The target argument must reference a column containing text values.
Example
A table contains an Array column that returns list values from the Product Type PRM list parameter. You can use the ArrayContains function to search the Array column list for the value in the Product Type column.
ArrayContains([Array], [Product Type])
You can also use the function to determine whether or not the value in the Product Type column is currently selected in the Product-Type-PRM list parameter.
ArrayContains([Product-Type-PRM], [Product Type])
When the value in the Product Type column is found in the Array column or Product Type PRM list parameter, the function output is "True." If the value is not found, the function output is "False."