Verify that Email and Password Match to what is Listed in SharePoint List

[Mrfunk]

Hello!!

This community has been so great and helpful, and I am hoping to see if someone can help me with yet another question that I have! I am creating an interesting app where multiple users fill out information while one person is logged in (a student is logged in and then faculty hop on and add feedback for that student - I know it may seem strange, but that is what was asked). So, in each area that faculty need to input some information, there is an email and password field that they need to type in to make sure/verify that they are on the list of faculty (that way students can't fake the feedback). I have a list in SharePoint with the faculty's email, name and password. Is there a way to look-up, validate, or do a IsMatch function to confirm that the email and password that faculty add are a match to what I have in my SharePoint list?  I haven't figured out a formula that works quite yet.

Thank you so very much for any help!

[TheRobRush]

I have a few apps like this. When the app opens, it collects the sp list data into a local collection (i just do this in case of bad wifi which we occassionally encounter). I tend to start with a drop down populated with name field of the source of names and passwords. After they choose a name, onchange will set something like employeeVar to (for example) Dropdown.Selected.Name

Once a name is chosen a textinput set to pw type will appear where they can enter their pw. 

below pw box is a forgot password? label that does a lookup for their email in the list based off a lookup using employeeVar that will email them the pw they created on their first use, also a button to change their pw(pw is needed to change pw).

once they type in the box a button to login is unlocked. clicking this does a lookup of the textbox value vs the pw value for the record matching employeeVar. if it's correct they are logged in, if not it reminds them they can email their pw to themselves if it has been forgotten. Hope this helps