Unanswered

Ignoring case sensitivity for login emails

(0) Share

Report

Posted on by fdlsklfsdkk

Hello everyone, hope you're all are safe.

I'm developing a login screen that takes in emails and passwords from a Sharepoint list as well as a couple of specific emails hardcorded into the formula. It's all working fine but the only issue I'm facing is that the emails are case sensitive. i've tried using IgnoreCase but I think I'm using it incorrectly because it does not work as intended.

Here's my formula

If(!IsBlank(
 LookUp( SharePointList,email = TextInput12_3.Text).email)
|| TextInput12_3.Text= "example@email.com" && ignoreCase
|| TextInput12_3.Text= "example@email.com"&& ignoreCase
|| TextInput12_3.Text= "example@email.com"&& ignoreCase
|| TextInput12_3.Text= "example@email.com"&& ignoreCase
|| TextInput12_3.Text= "example@email.com"&& ignoreCase
|| TextInput12_3.Text= "example@email.com" && ignoreCase
|| TextInput12_3.Text= "example@email.com"&& ignoreCase
|| TextInput12_3.Text= "example@email.com"&& ignoreCase
,
 Navigate(Screen2), UpdateContext({alert:true}))

Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (2)

Report
@fdlsklfsdkk
I would suggest using the lower function to convert the input email to lowercase.

If(!IsBlank( LookUp( SharePointList,email = TextInput12_3.Text).email), || Lower(TextInput12_3.Text)= "example@email.com" || Lower(TextInput12_3.Text)= "example@email.com" || Lower(TextInput12_3.Text)= "example@email.com" || Lower(TextInput12_3.Text)= "example@email.com" || Lower(TextInput12_3.Text)= "example@email.com" || Lower(TextInput12_3.Text)= "example@email.com" || Lower(TextInput12_3.Text)= "example@email.com" || Lower(TextInput12_3.Text)= "example@email.com" , Navigate(Screen2), UpdateContext({alert:true}))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
fdlsklfsdkk 22 on at

Like (0)

Report

Thank you so much, it works flawlessly!

Was this reply helpful? Yes No