Hi All,
I'm trying to create a user login function in my app by looking at a SharePoint list or a data table of user and password i have created.
but when I use the function to see if the username/password is equal the username/password that's entered in the app, it dont not seems to work.
If(And('SP.Username_Column1'=PA_LS_Username.Text,'SP.Passwrod_Column1'=PA_LS_Password.Text ),Navigate('Home Screen'),Navigate('Failed To Login Screen'))
should i be using another method or is the function im using is incorrect ?
Are you taking into account that the check you are doing is case sensitive for both the userid and the password?
since im using the below, it should be case sensitive for both correct?
If(And('SP.Username_Column1'=PA_LS_Username.Text,'SP.Passwrod_Column1'=PA_LS_Password.Text ),Navigate('Home Screen'),Navigate('Failed To Login Screen'))
cos the function is checking if they the username/password that's being entered is the same whats in the database.
Since the user info is in a data table, i should use a lookup correct?
Hey @Ash2
If(LookUp(SP,Username_Column1=PA_LS_Username.Text).Passwrod_Column1'=PA_LS_Password.Text ,Navigate('Home Screen'),Navigate('Failed To Login Screen'))
it does not seem to work with the below.
If(LookUp(SP,Username_Column1=PA_LS_Username.Text).Passwrod_Column1'=PA_LS_Password.Text ,Navigate('Home Screen'),Navigate('Failed To Login Screen'))
I made some adjustment to your formula but it still now working.
If(and(LookUp(DataTable3,Username_Column1=PA_LS_Username.Text)=PA_LS_Username.Text,
LookUp(DataTable3,Username_Passwrod1=PA_LS_Passwrod.Text)=PA_LS_Password.Text),
Navigate('Home Screen'),Navigate('Failed To Login Screen'))
Hey @Ash2
Hey @Ash2
originally I was using a Sharepoint lIst to store the User info but I wanted the app to work offline as well, so I thought I would need to have a data table background somewhere in the app to check the user info.
please see below pic, not a 100% sure if m looking in the correct place.
Hi @Ash2
User | Count |
---|---|
236 | |
112 | |
94 | |
59 | |
31 |
User | Count |
---|---|
289 | |
130 | |
104 | |
62 | |
58 |