Login Screen link Power App link to SQL

[fletch6]

Hi,

I am trying to create a log in page where a user enters their username and then a password. I would like the app to recognise the username from a table in SQL and then the password they enter is also in that table in another column with their password on. The function needs to use their username and match to the password in the SQL column relating to that username. 

I can't find anything on this specifically so any help would be appreciated. 

[StalinPonnusamy · Accepted solution]

Hi   @fletch6 

• Create sql connection to that environment
• Here is the code on button click

If(
    !IsEmpty(
        Filter(
            Student,
               UserName=UsernameInput.Text,
               Paswword=PwdInput.Text
        )
    ),
    Navigate(Screen2),
    Notify("Credentials  not matching")
)

Working Sample

[fletch6]

Thank you so much 🙂