STARTSWITH ER function
The STARTSWITH function determines whether the specified input starts with the specified text. It returns a Boolean value of TRUE if the specified input starts with the specified text. Otherwise, it returns a Boolean value of FALSE.
Syntax
STARTSWITH (input, start 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 start 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 beginning 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 STARTSWITH ("abc", "d") returns FALSE, whereas the expression STARTSWITH ("abc", "A") returns TRUE.
Example 2
The expression STARTSWITH (model.InvoiceBase.Customer.PostalAddress.Address, "123 Coffee Street") returns TRUE if the value of the Address field of the model data source starts with the string 123 Coffee Street. Otherwise, it returns FALSE.