CONTAINS ER function
The CONTAINS function determines whether the specified input contains the specified text. It returns a Boolean value of TRUE if the specified input contains the specified text. Otherwise, it returns a Boolean value of FALSE.
Syntax
CONTAINS (input, search text)
Arguments
input: String
The valid path of an item of a data source of the String type or a string constant, the value of which might contain the second argument.
search text: String
The valid path of a data source of the String data type or a string constant, the value of which might be contained in the first argument.
Return values
Boolean
The resulting Boolean value.
Usage notes
This function can be used to specify a condition expression of the FILTER function only when the relevant mapping is configured in Regulatory Configuration Services to access Microsoft Dataverse. Otherwise, an exception is thrown at design time. The message that you receive recommends that you use the WHERE function instead of the FILTER function.
Example 1
The expression CONTAINS ("abc", "d") returns FALSE, whereas the expression CONTAINS ("abc", "C") returns TRUE.
Example 2
The expression CONTAINS (model.InvoiceBase.Customer.PostalAddress.Address, "DEU") returns TRUE if the value of the Address field of the model data source contains the string DEU. Otherwise, it returns FALSE.