PowerApps In Operator And Exactin Operator Explained

PowerApps In Operator Exactin Operator

PowerApps in operator and exactin operator are used to check whether a collection contains an item or not. The expression evaluates to a boolean value (true or false).

Left to the operator is the searched item and right to the operator is the collection where the item is potentially contained.

The only difference between the in operator and the exactin operator is that exactin is case sensitive and in is not.

PowerApps In operator examples

Let’s see some examples.

In with numbers

The in operator is not limited to strings. You use it with numbers as well.

ClearCollect(numbers,[1,2,4]);
1 in numbers // returns true
3 in numbers // returns false

In with strings

Please note that joe is found in names also it is provided with a lowercase ‘j’. The in operator is not case-sensitive. If you need case sensitivity use the exactin operator.

ClearCollect(names,["Joe","Mike","Sally"]);
"joe" in names // returns true
"paul" in names // returns false

Exactin with strings

In the example below you can see how exactin is case-sensitive. Providing ‘joe’ with a lowercase ‘j’ does not evaluate to ‘true’ in contrast to the in operator.

ClearCollect(names,["Joe","Mike","Sally"]);
"joe" exactin names // returns false
"Joe" exactin names // returns true

Not in operator

To negate the result of in just use the Not function.

ClearCollect(names,["Joe","Mike","Sally"]);
Not("joe" in names) // returns false

 Filter using in operator

ClearCollect(names,["Joe","Mike","Sally"]);
Filter(names,"joe" in Value); // Returns collection with one record 'Joe'

In operator delegation

In case you want to filter or lookup data from a SharePoint list using the in operator, you will get a delegation warning. Unfortunately the in operator can not be delegated for SharePoint Lists. For a SQL datasource it is.

2 thoughts on “PowerApps In Operator And Exactin Operator Explained”

Leave a Comment

Your email address will not be published. Required fields are marked *