Answered

Perform a search on a List

(0) Share

Report

Posted on by sienna28

514

I am creating a login screen - the user enters a name and when a button is pressed I am trying to make it so that it performs a lookup on a Sharepoint list and looks to see if the user exists.

If the user is found in the list then navigate to a screen.

If not found then save the record and show a message that they have now signed up & make visible a button to log in.

Any help appreciated

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sienna28,

Could you please share a screenshot of your app's configuration?

Do you want to create a login screen within your app?

I have made a test on my side, please take a try with the following workaround:

Within the first screen (Login Screen), set the OnVisible property of the screen to following formula:

UpdateContext({isShowLogIn:false})

Set the Visible property of the Log in button (Button 2 control, hidden "Log in" button) to following formula:

isShowLogIn

Set the OnSelect property of the Validate button (Button1 control) to following formula:

If(
!IsEmpty(Filter('20180705_case5',UserName=TextInput1.Text)),
Navigate(Screen2,ScreenTransition.Fade),
Patch('20180705_case5',Defaults('20180705_case5'),{Title:"New Sign Up User",UserName:TextInput1.Text});Notify("Congratulations, you have signed up!",NotificationType.Success);UpdateContext({isShowLogIn:true})
)

Note: The '20180705_case5' represents the SP list data source within my app, on your side, you should add your SP list as a data source within your app.

When the user is existed in my SP list, the GIF image of my app as below:

When the user is not existed in my SP list, the GIF image of my app as below:

More details about Patch function, Notify function in PowerApps, please check the following article:

Patch function, Notify function

Please also check if the following blog would help in your scenario:

https://www.c-sharpcorner.com/article/developing-login-page-in-microsoft-powerapps/

Best regards,

Kris

Was this reply helpful? Yes No
sienna28 514 on at

Like
a
(0)

Report
Copy link

Link copied!

Thas very helpful.
Thank you very much.

One other issue is when coming to the login screen from another screen, I am finding the username and password boxes are not cleared. I tried using a set variable to "" on the onvisible property of the screen and setting the default of the text box to that variable name, but the boxes still retain their values.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sienna28,

Do you want to reset the Text Input box control within your login screen when navigating back from another screen?

I assume that there is a Back button (Button control) within your another screen, and you could click this button to navigate back to your login screen (Screen1).

Please set the OnSelect property of the Back button (Button control) within your another screen to following formula:

Navigate(Screen1,ScreenTransition.Fade);Reset(TextInput1);Reset(TextInput2)

Note: The Screen1 represents the Login screen within your app, the TextInput1 represents the Username box and the TextInput2 represents the Password box within your login screen.

In addition, you could also take a try with the following workaround:

Set the OnVisible property of the first screen within your app to following formula:

Set(IsReset,false)

Set Reset property of the Username box (TextInput1 control) and Password box (TextInput2 control) within your login screen to following formula:

IsReset

Set the OnSelect property of the Back button (Button control) within your another screen to following formula:

Navigate(Screen1,ScreenTransition.Fade);Set(IsReset,true);Set(IsReset,false)

Best regards,

Kris

Was this reply helpful? Yes No
Verified answer

sienna28 514 on at

Like
a
(0)

Report
Copy link

Link copied!

Kris

Many thanks - I just got around to testing this.

I used your first example and it worked well.

Thanks again for your help

Was this reply helpful? Yes No