When trying to use an IF activity to compare emails in the condition it is following the Else path as if the email address is incorrect. I added a write to cell to verify that the email being pulled in the previous activity was working correctly and it is. I’m not sure why the condition being used cannot compare email address. I’m selecting the email address and saving as a Saved Value. I compare the saved value in the condition to the current row email address in the excel file. Even though the email addresses match it still defaults to the Else statement. Is there an issue with comparing email addresses?
“Equal to” means that every character in the string matches exactly including capitalization. A few things to check:
- They have the same capitalization for every character
- There are no extra characters such as spaces on the beginning/end of the inputs
An easy way to force this to be true is add a “Modify Text” activity for each of the inputs, apply “Trim” and “To Lowercase” operations to both strings, then compare them.
Thank you, Andrew. I will try this and see if I can get it to work. Thanks!