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?
Solved! Go to Solution.
Okay, got it. Thank you. I believe your formula will work in that case. I misread your requirement that you wanted to validate emails only in one of the cases-lower or higher.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |