Limit on contains() expression?

[Colin_Lough]

Is there a limit on the number of criteria in the contains() expression?

I have the filter applied on a table, and my 3rd contains() is not selecting the ‘Tax’ values.

AND
(
[Portfolio Status]= “Active”,
OR
(contains([Obligation Categories],Privacy),
(contains([Obligation Categories],Data Localization),
(contains([Obligation Categories],Tax),
[Team Name] = “Privacy”
))))

Thanks

[Suvrutt_Gurjar]

May be you wish to try the following expression, if you wish to OR() the three CONTAINS() sub-expressions and AND() them with the remaining two.

AND
(
[Portfolio Status]= “Active”,
OR
(
contains([Obligation Categories], “Privacy”),

contains([Obligation Categories], “Data Localization”),

contains([Obligation Categories], “Tax”)
),
[Team Name] = “Privacy”
)

[Colin_Lough]

Thanks, @Suvrutt_Gurjar.
I updated to the below, I don’t know why it now worked. The suggestion above made [Team Name] = “Privacy” to be required.

AND
(
[Portfolio Status]= “Active”,
OR
(
contains([Obligation Categories], “Privacy”),

contains([Obligation Categories], “Data Localization”),

contains([Obligation Categories], “Tax”),

[Team Name] = “Privacy”
)
)