The formula
Set(_contact, LookUp(Contacts, Email = Lower(User().Email)));
throws the following error (if error handling is enabled),
while the following code (which does the same but in 2 steps) works without error and returns the record
Set(_user, User());
Set(_contact, LookUp(Contacts, Email = Lower(_user.Email)));
It looks like the Lower function has a hiccup.
This appears in all environments (US and EUROPE based) with all available Studio versions.


Report
All responses (
Answers (