Any(Text values, Text list)

Returns true if at least one value from the list exists in the values.

Parameters

values

The comma-separated list of values.

list

The comma-separated list of values to test.

Returns

Boolean

Examples

• Any("A,B,C,D", "D,A") returns true.
• Any("A,B,C,D", "D,E") returns true.

You can use this function in the filter of a view that asks the user for a checkbox column. For example, if there is a "Multiple Choices" text column in a table and you want the user to filter records including any value among the choices combination asked by them, you can use the following formula in the filter of the view: Ask(Any([Multiple Choices], [?Multiple Choices])).