where validate username and password

[andresadan2000]

help please I want to generate an APP where validate username and password, this validated with a list of Share point I found this page but I can not get it to validate the records

[MatthewInwards · Accepted solution]

I have implemented this within some of my apps already and this is how you will do it.

Here are my variable names first for context:

Username = The text box for the username

Password = The text box for the password

Login = The button you press to verify the username and password

LoginList = The sharepoint list containing your logins

Put this on the onselect properties of the login button

If(CountRows(Filter(LoginList,And(Username.Text = UsernameColumn,Password.Text = PasswordColumn))) = 1, Enter here what you want it to do if it is correct, Notify("Incorrect Login Details",NotificationType.Error))

Hope this helps 🙂

[timl]

Hi @andresadan2000 

@MatthewInwards's reply will work.

The comment I would have about this approach is that it's easy for users to circumvent the security by looking up the usernames and passwords directly in the SharePoint list. Therefore, is there a way that you can secure your app by only sharing it with the users that require access?

Just for info, here's a thread with a similar question.

https://powerusers.microsoft.com/t5/General-Discussion/Created-Log-In-But-cant-log-in/td-p/196312