ENDSWITH ER function
The ENDSWITH function determines whether the specified input ends with the specified text. It returns a Boolean value of TRUE if the specified input ends with the specified text. Otherwise, it returns a Boolean value of FALSE.
Syntax
ENDSWITH (input, end 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 end with the second argument.
start text: String
The valid path of a data source of the String data type or a string constant, the value of which might be at the end of 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 ENDSWITH ("abc", "d") returns FALSE, whereas the expression ENDSWITH ("abc", "C") returns TRUE.
Example 2
The expression ENDSWITH (model.InvoiceBase.Customer.PostalAddress.Address, "USA") returns TRUE if the value of the Address field of the model data source ends with the string USA. Otherwise, it returns FALSE.