And, Or, and Not functions in PowerApps
Boolean logic functions, commonly used to manipulate the results of comparisons and tests.
The And function returns true if all of its arguments are true. The && operator is equivalent to And.
The Or function returns true if any of its arguments are true. The || operator is equivalent to Or.
The Not function returns true if its argument is false; it returns false if its argument is true. The ! operator is equivalent to Not.
These functions work with logical values. They can't be passed a number or a string directly; instead a comparison or test must be made. For example, a comparison such as x > 1 is a logical formula that evaluates to the Boolean value true if x is greater than 1. If x is less than 1, the formula evaluates to false.
And( LogicalFormula1, LogicalFormula2 [, LogicalFormula3, ... ] )
Or( LogicalFormula1, LogicalFormula2 [, LogicalFormula3, ... ] )
Not( LogicalFormula )
- LogicalFormula(s) - Required. Logical formulas to evaluate and operate on.
Step by step
Use this function to determine whether a slider's value falls outside the 50 to 100 range:
Or(Slider1.Value < 50, Slider1.Value> 100)
If a table contained a Dept column and a Salary column, you could use this function in a Result column to show true in all rows in which the value in the Dept column was HR or the value in the Salary column was larger than 200000:
Or(Dept = HR, Salary >= 200000)
As an alternative, use the || operator to get the same results as what the previous formulas return:
Slider1.Value < 50 || Slider1.Value> 100
Dept = "HR" || Salary > 200000
We'd love to hear your thoughts. Choose the type you'd like to provide:
Our feedback system is built on GitHub Issues. Read more on our blog.