Unanswered

Login Lookup Forgotten Password Formula Help

(1) Share

Report

Posted on by jamescosten

643

I have a Login Screen that works perfectly, however I have added a forgotten password button and would like the user to enter their name, then when you press the button it lookups the person email and send them an email with the details.

The button needs to look at the EnterNameLogin.Text, Lookup the Access List Name Column then send an email containing the Password Text in the column to the Email column text.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Sorry what is the question?

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report

The question is what would the on select for the "Forgotten Password" Button.

Was this reply helpful? Yes No
Suggested answer

CA1105 545 Super User 2025 Season 2 on at

Like (0)

Report
I'm assuming you have already created screen for Forgot password and user is being navigated to that screen when they click on the button. On the Forgot password screen you can have the name/email text box setup and when user enters their name on button click you can check their entered name in DB.

IsBlank(Lookup('Your Source', Name=Textbox.Text))

If the expression is true that mean user is there in the system then you can give password textbox to reset it and patch it to DB.

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report

So I have setup a password reset screen that the user enters their name and the new password. And I thought the follwoing would work to lookup the Name and patch a new password?

Patch('WTRF Access List',LookUp('WTRF Access List',Name=TextInputCanvas1.Value),{Password:=TextInputCanvas1_1.Value})

But i get this error:

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi Jamescosten

With regards to the formula that you're using to reset/patch a new password, removing the = sign in the section where you define the new password should resolve the error.

Patch('WTRF Access List', LookUp('WTRF Access List',Name=TextInputCanvas1.Value), {Password:TextInputCanvas1_1.Value} )

Was this reply helpful? Yes No
Suggested answer

CA1105 545 Super User 2025 Season 2 on at

Like (0)

Report
you'll have to remove (=) operator.

Patch('WTRF Access List', LookUp('WTRF Access List',Name=TextInputCanvas1.Value), {Password:TextInputCanvas1.Value} )

Was this reply helpful? Yes No