Answered

Loging Screen (issue)

(0) Share

Report

Posted on by crazor123

I'm building an app with a login screen, if the user provides a true login and password, I want him to be redirected to Home screen if not to Error Screen.

All data about user and pw will be stored in a sharepoint list:
Sharepoint listname = user_logins

Screen buildes and textinput

Code i'm trying to use =

If(!IsBlank(Lookup(users_logins;Title= TextInput1.Text and Password= TextInput2.Text).Title;Navigate(Home);Navigate(ErrorScreen))

Any help with the code would be great, thx

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @crazor123 ,

I think you added semicolon after title which is wrong .

If(!IsBlank(Lookup(users_logins,username= TextInput1.Text and Password= TextInput2.Text).Title;Navigate(Home);Navigate(ErrorScreen))

Thanks,

Was this reply helpful? Yes No
crazor123 52 on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried the adjustment , still not working. (i'm using the Dutch version).
The error message says, he expects parentclose, and there is an issue with the lookup function

Was this reply helpful? Yes No
vikas1606 206 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @crazor123 ,
It seems to issue in an If condition. Use the below statement and let me know.

If(!IsBlank(Lookup(users_logins;Title= TextInput1.Text and Password= TextInput2.Text).Title),Navigate(Home),Navigate(ErrorScreen))

Was this reply helpful? Yes No
crazor123 52 on at

Like
a
(0)

Report
Copy link

Link copied!

If(!IsBlank(Lookup(users_logins;Title= TextInput1.Text and Password= TextInput2.Text).Title),Navigate(Home),Navigate(ErrorScreen))

Same issues, 1 new issue, he doesn't reconigze title.

Was this reply helpful? Yes No
vikas1606 206 on at

Like
a
(0)

Report
Copy link

Link copied!

Use this, This time, you should not have the issue.

If(!IsBlank(LookUp(users_logins,Title= TextInput1.Text && Password= TextInput2.Text).Title),Navigate(Home),Navigate(ErrorScreen))

Was this reply helpful? Yes No
crazor123 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Still no go 😞

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Your closing parenthesis for !IsBlank is in the wrong place. I replicated your app and it works for me (note that your semicolons are commas for me:

If( !IsBlank( LookUp( users, username = TextInput1.Text && password = TextInput2.Text ).username ), Navigate(scrSuccess), Navigate(scrError) )

Was this reply helpful? Yes No
Verified answer

zuurg 546 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Note that in the fake list I created to test out your situation, I renamed the Title field to username (which normally you shouldn't do. If you did the same, that's probably why it isn't recognizing Title, you need to be trying to match username instead.

Was this reply helpful? Yes No
crazor123 52 on at

Like
a
(0)

Report
Copy link

Link copied!

I've rebuilded the app from scratch, new list.
And used your code and changed the comma with ; and works.

If(
!IsBlank(
LookUp(
user_logins;
Title= TextInput1.Text && password = TextInput2.Text
).Title
);
Navigate(Home);
Navigate(Error)
)

Is there a reason why dutch users need to use ; instead of comma? (i changed language to English) doesnt make a difference.

Anyways thx!

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not really sure. If you use commas over there as a decimal separator instead of a period, that might be why - to avoid confusion with numbers?

I'm happy you got it working. 🙂

Was this reply helpful? Yes No