Email rule to cater for case sensitivity

Hi There,

How can I can make the below expression to be case insensitive and just match the wording?

If (IsSet(EmailAddressLocalPart(Email.Message.from)), Contains(EmailAddressLocalPart(Email.Message.from), "MPSA.MASDRA"), false)
and
If(IsSet(EmailAddressDomainPart(Email.Message.from)), Contains(EmailAddressDomainPart(Email.Message.from), "WXCRTCT.TECH"), false)

The assistance will be highly appreciated.

Regards

Hello,

You can use Upper function to convert a String to uppercase characters, and then compare with your value (in uppercase).
Like:
Contains(Upper(EmailAddressLocalPart(Email.Message.from)), "MPSA.MASDRA"), false)

Or even (the second Upper on MPSA.MASDRA is just to cover cases where someone would modify this value and forget to set it in uppercase):
Contains(Upper(EmailAddressLocalPart(Email.Message.from)), Upper("MPSA.MASDRA")), false)

Regards,

Great, thank you Jerome, your suggestion works perfectly.

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.