Recently I came across a thread related to checking USEREMAIL() against a list of email records, and it was mentioned that the check may fail due to difference between uppercase and lowercase characters.
Has anybody dealt with this issue before? Is there a robust solution? My opinion is that it would be helpful a list-expression that converts into LOWER-case or UPPER-case all the text records in the list. But it doesn’t seem to exist. Alternatively, one should implement an hack like forcing user inputed emails to be lowercase or uppercase, but I’d prefer the first solution.
Using such a function, I could write:
IN(LOWER(USEREMAIL()), LOWER(SELECT(Users[Email]), [Role] = "Manager")))
Any ideas? Should I raise a feature request?