Answered

Updating one column if the other column matches (Reset a password)

(0) Share

Report

Posted on by SecretAdmirer09

Hi Everyone,

I would like to seek help please if it's possible to update just one column (database) if the other column matches what's on the database.

This will serve as my reset a password or forgot password. I'm thinking if i should use Patch or UpdateIf.

If so, can anyone help me with the formula?

We can call the database as Database1, Name as Name, Age as Age and Password as Pass.

Hope this one is clear, Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (3)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @SecretAdmirer09

try this please:

Patch( Database1, LookUp(Database1, Name = "SpecificUserName"), {Pass: "NewPassword"} )

Remember to replace "SpecificUserName" and "NewPassword" with the appropriate values or variables from your application.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SecretAdmirer09 ,

Can you elaborate your table and use-case?

UpdateIf can update several records if condition is matched, good for Bulk-Edit or say password reset.

If you need to update 1 record only, then Patch is suitable.

What is the datatype of your 1 column?

Was this reply helpful? Yes No
SecretAdmirer09 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Apologies for the confusion. Let me give my table:

Database name is Ticketing Tool, under this database are:
Username, Password, When Question, Where Question, Member First Name, Member Last Name, Member ID

What i want to do is if the member forgot his/her password, he/she can click the forgot password button then will direct to this page where they will need to fill out this data; Username, when question, where question, member ID and New Password. Only if Username, when question, where question and member ID matches what is in the database, then that's the only time that the new password will change or update.

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
another try for ur explanatuon:

If( CountRows( LookUp( 'Ticketing Tool', Username = txtUsername.Text && 'When Question' = txtWhenQuestion.Text && 'Where Question' = txtWhereQuestion.Text && 'Member ID' = txtMemberID.Text ) ) > 0, Patch( 'Ticketing Tool', LookUp( 'Ticketing Tool', Username = txtUsername.Text && 'When Question' = txtWhenQuestion.Text && 'Where Question' = txtWhereQuestion.Text && 'Member ID' = txtMemberID.Text ), {Password: txtNewPassword.Text} ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
SecretAdmirer09 51 on at

Like
a
(0)

Report
Copy link

Link copied!
The last part is not working, only showing error.

{Password: txtNewPassword.Text}

If(
CountRows(
LookUp(
'eProc Ticketing Tool (Access List)',
Username= 'Fill 1'.Text&&
Password='Fill 2'.Text&&
'When Question'='Fill 3'.Text&&
'Where Question' = 'Fill 4'.Text &&
'Member ID' = 'Fill 5'.Text)
) > 0,
Patch(
'eProc Ticketing Tool (Access List)',
Username= 'Fill 1'.Text&&
'When Question'='Fill 3'.Text&&
'Where Question' = 'Fill 4'.Text &&
'Member ID' = 'Fill 5'.Text
),

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

which error do u get?

Was this reply helpful? Yes No
SecretAdmirer09 51 on at

Like
a
(0)

Report
Copy link

Link copied!

{Password: txtNewPassword.Text}

This part, it is not working. it's all red. Tried doing this {'Password'='fill 2'.Text} but still doesn't work.

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

on the top right there is a stetoscope, there u should see an error. can u please tell us what it says?

Was this reply helpful? Yes No
SecretAdmirer09 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Here's what it says

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

it wants an else value here, so u need to define what outcome u need when the condition is false

Was this reply helpful? Yes No