Multiple And conditions within text.Contains

[Anonymous]

Hi,

I'm trying to write a statement so that if a cell  within a specified column contains 2 or more specified strings then add value to another column

e.g. say I was using email To line data. If the To line (Column A) contained both "john.smith@gmail.com" and "smith.john@gmail.com" then fill Column B with "Multiple Inboxes"

delimiter used in this case between emails would be ";"

I have tried the following but does neither seem to work:

= if Text.Contains([DisplayTo], "john.smith@gmail.com") and Text.Contains([DisplayTo],"smith.john@gmail.com") then "Multiple Inboxes"
else "Not Applicable")

= if Text.Contains([DisplayTo], "john.smith@gmail.com" and "smith.john@gmail.com") then "Multiple Inboxes"
else "Not Applicable")

[v-rzhou-msft · Accepted solution]

Hi @Anonymous ,

I think first codes should be correct.

=
if Text.Contains([DisplayTo], "john.smith@gmail.com") and Text.Contains([DisplayTo],"smith.john@gmail.com") then "Multiple Inboxes"
else "Not Applicable"

Please make sure the specified strings in your code are correct. In my sample it works.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.