cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Login page with filter option

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

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),...)

 

Best Regards,
Qi

View solution in original post

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

 

Best Regards,
Qi

View solution in original post

4 REPLIES 4
v-qiaqi-msft
Community Support
Community Support

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),...)

 

Best Regards,
Qi
Anonymous
Not applicable

Sp listSp listUntitled.pngHi @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.

 

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

 

Best Regards,
Qi
Anonymous
Not applicable

Hi @v-qiaqi-msft , 

Thank you so much for your Help.

😊

Regards, 

Praveen

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,087)