Syntax
Value in TextOrTableExamples
"apple" in "Pineapple"true
Filter(Products, "red" in Tags)Products tagged red
Maker notes
- On large data sources, "in" is often not delegable. StartsWith usually is.
in
Checks whether text appears inside other text, or a value appears in a table. Not case-sensitive.