And, Or, and Not functions
Applies to: 
Canvas apps
Dataverse formula columns
Desktop flows
Model-driven apps
Power Pages
Power Platform CLI
Boolean logic functions, commonly used to manipulate the results of comparisons and tests.
Description
The And function returns true if all of its arguments are true.
The Or function returns true if any of its arguments are true.
The Not function returns true if its argument is false; it returns false if its argument is true.
These functions work the same way as they do in Excel. You can also use operators to perform these same operations, using either Visual Basic or JavaScript syntax:
| Function notation | Visual Basic operator notation | JavaScript operator notation |
|---|---|---|
| And( x, y ) | x And y | x && y |
| Or( x, y ) | x Or y | x || y |
| Not( x ) | Not x | ! x |
These functions work with logical values. You can't pass them a number or a string directly; instead, you must make a comparison or a test. For example, this logical formula x > 1 evaluates to the Boolean value true if x is greater than 1. If x is less than 1, the formula evaluates to false.
Syntax
And( LogicalFormula1, LogicalFormula2 [, LogicalFormula3, ... ] )
Or( LogicalFormula1, LogicalFormula2 [, LogicalFormula3, ... ] )
Not( LogicalFormula )
- LogicalFormula(s) - Required. Logical formulas to evaluate and operate on.
Examples
The examples in this section use these global variables:
- a = false
- b = true
- x = 10
- y = 100
- s = "Hello World"
To create these global variables in an app, insert a Button control, and set its OnSelect property to this formula:
Set( a, false ); Set( b, true ); Set( x, 10 ); Set( y, 100 ); Set( s, "Hello World" )
Select the button (by clicking it while you hold down the Alt key), and then set the Text property of a Label control to a formula in the first column of the next table.
| Formula | Description | Result |
|---|---|---|
| And( a, b ) | Tests the values of a and b. One of the arguments is false, so the function returns false. | false |
| a And b | Same as the previous example, using Visual Basic notation. | false |
| a && b | Same as the previous example, using JavaScript notation. | false |
| Or( a, b ) | Tests the values of a and b. One of the arguments is true, so the function returns true. | true |
| a Or b | Same as the previous example, using Visual Basic notation. | true |
| a || b | Same as the previous example, using JavaScript notation. | true |
| Not( a ) | Tests the value of a. The argument is false, so the function returns the opposite result. | true |
| Not a | Same as the previous example, using Visual Basic notation. | true |
| ! a | Same as the previous example, using JavaScript notation. | true |
| Len( s ) < 20 And Not IsBlank( s ) | Tests whether the length of s is less than 20 and whether it isn't a blank value. The length is less than 20, and the value isn't blank. Therefore, the result is true. | true |
| Or( Len( s ) < 10, x < 100, y < 100 ) | Tests whether the length of s is less than 10, whether x is less than 100, and whether y is less than 100. The first and third arguments are false, but the second one is true. Therefore, the function returns true. | true |
| Not IsBlank( s ) | Tests whether s is blank, which returns false. Not returns the opposite of this result, which is true. | true |