Lookup with Three conditions.

[Anonymous]

So I have the following function:

IF(!ISBLANK(LOOKUP( Users, User_Name=Name_Input.text AND User_Password=Password_Input.text).Title), Navigate(Screen 2), UPDATECONTEXT({ShowForgetMessage:true}))

Its referencing a SharePoint List that looks like this

I want User_Type to be a fixed Condition kind of like:

IF(!ISBLANK(LOOKUP( Users, User_Name=Name_Input.text AND User_Password=Password_Input.text AND User_Type="System Admin").Title), Navigate(Screen 2), UPDATECONTEXT({ShowForgetMessage:true}))

But this doesnt work. Are there any ways of going about this?

[Anonymous]

@v-qiaqi-msft

I saw that you answered something similar here:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Login-page-with-filter-option/m-p/1450391#M3...

and I tried

If(LookUp(Users, UserName=TextInput1.Text, Password=TextInput2.Text).Department.Value="SystemAdmin", Navigate(Screen23),
LookUp(Users, UserName=TextInput1.Text, Password=TextInput2.Text).Department.Value="EVSManager", Navigate(Screen23),UpdateContext({ShowForgetMessage}))

But its not working for some reason.

[Anonymous · Accepted solution]

Hi!

I tried to replicate your code in a similar way. If it's onSelect of a button it can be like this:

If(
    IsBlank(
        LookUp(
            Users,
            UserName= TextInput1.Text && Password= TextInput2.Text
        )
    ),
    Notify("UserName and password don't match),
    Switch(
        LookUp(
            Users,
            UserName= TextInput1.Text && Password= TextInput2.Text
        ).Department.Value,
        "SystemAdmin",
        Navigate(AdminScreen),
        "EVSManager",
        Navigate(ScreenManager)
    )
)

This code will check if there is a user with the exact name and password, if don't notify the user in the app. If there is it will check its department and navigate depending on the one they have.

You can optimize the code by using the with() function so you only use the LookUp once (if you are interested check this video in this time mark: https://youtu.be/AYD2oWue7fw?t=825)

[Anonymous]

This is what I get. I think the issue Im having is in the

Lookup(Users, UserName=TextInput1.Text && Password=TextInput2.Text).Department.Value

What is that supposed to result in?

[Anonymous]

In anticipation of the question, these are the values for Department.

[Anonymous]

@Anonymous 
Oh you have more department choices.
You can put more conditions for the department value or just use a default navigate for the rest of the departments on the Switch() function.

If this doesn't work can you show the error?

[Anonymous]

If(
IsBlank(
LookUp(
Users,
UserName= TextInput1.Text && Password= TextInput2.Text
)
),
Notify("UserName and Password don't match, if the problem persists contact your Administrator"),
Switch(
LookUp(
Users,
UserName= TextInput1.Text && Password= TextInput2.Text
).Department.Value,
"SystemAdmin",
Navigate(SystemAdmin),
"EVSManager",
Navigate(EVSManagerMain),
"EVSEmployee",
Navigate(EVSMain),
"SupplyManager",
Navigate(SupplyManagerMain),
"SupplyEmployee",
Navigate(SupplyMain),
"DietaryManager",
Navigate(DietaryManagerMain),
"DietaryEmployee",
Navigate(DietaryMain),
"Administration",
Navigate(AdministratorMain),
"AdministratorAssistant",
Navigate(AdministrativeAssistantMain)
)
)

---

This is what I landed on, once I realized what you have is iterative.

[Helpmepls_0405]

If(!IsBlank(LookUp(Credentials, Title = username_txt.Text And Password = password_txt.Text). Title), Navigate(one), UpdateContext({ShowForgetMessage:true})) can you help me pls? why it is not navigating to "one" when I got a correct credentials? i already have a "one" screen ready.