About Functions

To help you define particular Expressions or include individual operations while designing your app, an out of the box set of Functions is provided within the designer.

Note: Depending on the function specifications some have a graphical representation, while others do not.

Start using the available functions by selecting the needed operator, input the parameters, and wait for the output value to be returned.

Note:

• The accepted parameters can be the same type of arguments or implicit cast of arguments.
• The output value can be primitive or an object.

Function Operators

Mathematical Operators and Functions

Please access this page for more details.

Arithmetic Operators

Operator	Description	Example
+	Addition	x = y + 2
-	Subtraction	x = y - 2
*	Multiplication	x = y * 2
/	Division	x = y / 2
%	Modulus (division remainder)	x = y % 2
++	Increment	x = ++y
--	Decrement	x = --y x = y--

String Operators

We'll use the following hypothesis to present the string operators: text1 = "Good ", text2 = "Morning", and text3 = "".

Operator	Example	text1	text2	text3
+=	text1 += text2	"Good Morning"	"Morning"	""
&	text3 = text1 + text2	"Good "	"Morning"	"Good Morning"

Comparison Operators

We'll use the following hypothesis to present the comparison operators: x = 5.

Operator	Description	Comparing	Returns
=, ==	equal to ("=" is the same as "==")	x == 8 x == 5	false true
>	greater than	x > 8	false
>=	greater than or equal to	x >= 8	false
!=	not equal	x != 8	true
<	less than	x < 8	true
<=	less than or equal to	x <= 8	true

Logical Operators

We'll use the following hypothesis to present the logical operators: x=6 and y=3.

Operator	Function	Description	Example
!, not, NOT	Not()	not	!(x === y) is true
&&, and, AND	And()	and	(x < 10 && y > 1) is true
||, or, OR	Or()	or	(x === 5 || y === 5) is false

Other Operators

The in operator returns a true result if the specified property is in the specified object, otherwise, it returns a false result.

Note:

The in operator only supports primitive data types, such as string, number, boolean, null.

The in operator is not supported in Data Service scenarios using choice-set. You can use the contains operator instead, but only for one input.