How to Remove Extra Spaces in Power Apps with Trim and TrimEnds
Text typed by people often has spaces you can't see: one at the end of a job title, two between words. They look harmless, but "Sales Engineer " isn't equal to "Sales Engineer", so lookups quietly fail. Power Fx has two functions to clean them up, Trim and TrimEnds, and they don't do quite the same thing.
