web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : OV46EcsKj4UK/Y4o7llTtC
Power Apps - Building Power Apps
Unanswered

Internal Error in the the IfError function: TypeError: e.replace is not a function

Like (0) ShareShare
ReportReport
Posted on 22 Sep 2022 16:21:23 by 173

The formula

 

Set(_contact, LookUp(Contacts, Email = Lower(User().Email)));

 

throws the following error (if error handling is enabled),

image.png

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.

 
Session ID: 6000e8bc-ab83-44f5-b4cc-50b46ee32fb7

  • TxH Profile Picture
    173 on 07 Oct 2022 at 10:07:30
    Re: Internal Error in the the IfError function: TypeError: e.replace is not a function

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete