Power Platform Community Forum Thread Details

Hi everyone,

Kindly help me for solving my problems about login form. I made a login form that have been connected to my Azure SQL server. These are my problems:

1. Recently, I can login using different username & password from another row. I tried to login using different name and password (ex. username : Christen, pass : itadmin), it is successfully navigate to success screen. This is not what I expected.
2. Case insensitive, which is not what I expected. I want this form can validate that if the inputted text is not match with the row, then I cannot login or proceed to success screen. (ex. username : itadmin, pass : Itadmin)

Database :

If (!IsBlank
(Filter('[dbo].[admin]',
username = Uname_SuperAdmin.Text And Password = Pass_SuperAdmin.Text And is_super_admin=1).username),
Navigate(SuperAdmin),
UpdateContext({ShowForgetMessage:true}))

Categories:

Building Power Apps