Login page with filter option

[Anonymous]

Hello everyone,

  I need to build an app with user name and password in SharePoint Lists.

The list has User name, password and a department.

I need to navigate to different screens using matched department given that the user name and password matches.

Hoping to Get a help ASAP.

Regards,

Praveen

[v-qiaqi-msft · Accepted solution]

Hi @Anonymous,

Could you please share a bit more about your need?

Do you want to navigate to another screen based on user name and password?

Generally, you could retrieve the user name and password from the SP list once the current user login. Then find out the matched department so that you could navigate the user to the correct screen.

Here is a simple demo, please check as below:

1). Add TextInput for user name and password

2). Add a login button and set the OnSelect property as below:

If(LookUp(ListName, UserName=TextInput1.Text, Password=TextInput2.Text).Department="IT",Navigate(IT_Screen),LookUp(ListName, UserName=TextInput1.Text, Password=TextInput2.Text).Department="HR",Navigate(HR_Screen),...)

[Anonymous]

Sp listHi @v-qiaqi-msft  

Thank you for your reply. The demo you created is exactly what I wanted. But I have a new issue, can you please tell me what does .Department in your code means ?

It shows as error to me. Is it a variable or the one from Sp list?

I also have a text for " Forgot Password" which shows up only when user name passwords entered are not matched with the one in SP list.

Please refer the images attached.

[v-qiaqi-msft · Accepted solution]

Hi @Anonymous,

The Department in my scenario is just a Text column storing department info.

In your scenario, it is a Choice column, so you may need to do a little modification:

If(LookUp(ListName, UserName=TextInput1.Text, Password=TextInput2.Text).Department.Value="IT",Navigate(IT_Screen),LookUp(ListName, UserName=TextInput1.Text, Password=TextInput2.Text).Department.Value="HR",Navigate(HR_Screen),...)

Note that you should replace Department with Department.Value

[Anonymous]

Hi @v-qiaqi-msft , 

Thank you so much for your Help.

😊

Regards, 

Praveen