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.
Microsoft has confirmed it as a bug today.
The id for the corresponding support case is #2209290050001406.
The bug only came up by accident, as it is not necessary to use the Lower() function for User().Email, as the query is case insensitive.
Nevertheless, the formula should return a correct value and not crash.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2