Formula - Boolean And / Or operators - What is the order of precedence?
When building logical expressions with Power Apps, it's useful to understand which operator takes precedence when we mix the And and Or operators.
Demonstration - Filtering records with the And and Or operators
As an example, let's assume that we build an app that's based on a table of properties as shown beneath. The requirement is to search for all properties in London, which contain either 5 or more bedrooms, or 3 or more bathrooms.
Let's now add a gallery control and set the Items property to the formula beneath. Will this formula return the expected results?
Filter(Property,City="London" AndBedrooms >= 5 OrBathrooms >= 3
)
The answer to the above question is No! As the screenshot beneath highlights, this formula returns records for properties that are
not in London.
The And operator takes precedence over Or
This example highlights how the And operator takes precedence over the Or operator. To return our desired results, it's therefore necessary to parenthesis the Or part of the statement. The correct formula will look like this:
Filter(Property,City="London" And(
Bedrooms >= 5 OrBathrooms >= 3
)
)
As the screenshot beneath shows, this formula now returns the expected results.
Conclusion
When constructing boolean expressions, Power Apps performs the And/&& operators before the logical Or/|| operators.
