Am trying to create a filter pulling information from another table by matching emails. Everything was going GREAT, and then for some reason the filter recognizes some emails as matches and others as not. Same code, same email tests, but because of the letter it is not recognizing the match. Any help would be awesome.
I first made a new column in two tables to make the email lowercase and totext()
email linked → email
[Lead Assignment].filter(Email.ToText().Lower()=thisRow.Email).[Phone Number]