I have a string in Salesforce that contains the to and from addresses of an email, e.g.:
From: email@example.com to: (firstname.lastname@example.org, email@example.com)
A process should set a picklist to internal if that string does only contain @gmail.com and @yahoo.com and set it to external if the string contains another domain.
My process builder formula looks like this:
However, the process always sets the flag to internal right now, no matter if the string contains an external domain or not.
How can I make it work in process builder?