Patch Function in Power Apps Not Updating Password in SharePoint List via Email Link

[PattiF]

Hi everyone,

I'm experiencing an issue with my Power Apps application. I have implemented a password update functionality using the Patch function to update a SharePoint list.

Here, is the code 

If(
    txt_newPassword.Text = txt_confirmPassword.Text,
    Patch(
        'Event Registration Form',
        LookUp(
            'Event Registration Form','Email Address'=Last(EmailCollection).Email

        ),
        {Password: txt_confirmPassword.Text}
    );
    UpdateContext({errorVisible: false}),
    UpdateContext({errorVisible: true})
);
Notify("Password updated successfully", NotificationType.Success);

Reset(txt_newPassword);
Reset(txt_confirmPassword);

The Patch function works correctly when the password is updated directly within the app, but not when accessed via the email link.

Look at my Create New Password application in Power Apps!

 Here’s the scenario:

1. Users receive an email with a link to update their password.
2.  I did deep linking to get the screen URL that I sent in the email, as shown below.
3. When they open the link and try to update their password, the Patch function does not update the password in the SharePoint list.

Has anyone encountered a similar issue or have any suggestions on how to resolve this?

Thanks in advance for your help!

[Meekou]

After checking your issue, I think you could try to check the value for "Last(EmailCollection).Email" when open the link. Did it show the expected value for the current user?

Best Regards,

Meekou

YouTube

PowerApps

PowerAutomate

[PattiF]

Yes, you can see in the reference image below that I'm getting the current user's email correctly when opening the link.  

[Meekou]

Could you try to follow steps below to narrow down?

1. Create a variable to store Lookup value to make sure you get the expected record

2. Create a new button with Patch directly to check whether issue is in Patch or not of Patch.

3. After Patch function, show the Lookup result based on email again to check the password value.

Best Regards,

Meekou

YouTube

PowerApps

PowerAutomate

[PattiF]

I followed your steps:

1. I created a variable to store the lookup value in the OnVisible property of the screen.

2. Added a new button with the Patch function.

 3. Then, I used the lookup function result stored variable in the Text property of a text label, to check the password value.

4. Later, I sent an email containing the screen link again and tried to update the password. However, it is still not updating. When I return to the Power Apps screen, the text label is displaying the old password for the current user's email address.

But, when I update the password from the app, it was updated in SharePoint list.

[Meekou]

Between step 2 & 3, did you re-run query to update Var_UserRecord?

What is the status of Run Patch with hardcode the password & user email, and then click link to update password?

Best Regards,

Meekou

YouTube

PowerApps

PowerAutomate

[PattiF]

I re-ran the query to update Var_UserRecord  after the Patch function, but the password still doesn't update when accessed via the email link.

[Meekou]

In addition, double check to make sure whether the deep link open the latest apps.

If patch with hard code still not working and there is no error, I am out of mind.

Best Regards,

Meekou

YouTube

PowerApps

PowerAutomate

[PattiF]

 Yes, I checked the deep link of the app and updated it. Additionally, I am publishing and saving the app.

I have another scenario as well. If the user does not already exist in my SharePoint list, I send a separate email with a link to the registration form. This part is working correctly. When the user clicks on the link, enters their details, and clicks the register button, the details are successfully updated in the SharePoint list. But why it is not working for updating the password? I have no idea