A record-triggered flow is used to pull data from the Case Description field to populate other fields on the Case. There is a GET element that searches if the email address exists and takes different actions based on the result. The records used for testing are in the system, but the element is failing to find them
#Flow
That confirms it exactly, Abigail - one hidden character is riding along (16 instead of 15), almost certainly a line break or non-breaking space that got pulled in from the Description. TRIM won't remove those, but CHAR() will.
Wrap your extracted value in this - either as a Text formula resource, or directly in the formula that feeds your Get filter:
TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({!yourEmailValue}, CHAR(13), ""), CHAR(10), ""), CHAR(160), ""))
What each piece strips:
- CHAR(13) = carriage return
- CHAR(10) = line feed (newline) - this is the most common culprit when copying out of a free-text field
- CHAR(160) = non-breaking space
- TRIM() = any normal leading/trailing spaces
Run LEN() on that formula's output and it should read 15 now. Then point your Get element's filter at this cleaned value instead of the raw one, and it will match.
If it somehow still shows an extra character, reply back - we can pinpoint the exact one with UNICODE(MID(value, 16, 1)) - but those three cover it almost every time.