Any(Text values, Text list)
Returns true if at least one value from the list exists in the values.
- The comma-separated list of values.
- The comma-separated list of values to test.
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])).