Hi @azeesdinu ,
Could you please share a bit more about your scenario?
Do you create a custom form using PowerApps for your SP List?
Further, do you want to capture the value within the "Previous Assigned To Email" column in your SP List when you edit an existing record using the custom form?
Actually, when you add a Person within the "Assigned To" field first time, and click the "Save" button to submit your form data, you should also update the email value of selected Person in the "Assigned To" field into the "Previous Assigned To Email" column in your SP List.
On your side, please set the OnSuccess property of the SharePointForm1 (Edit form) to following:
Patch( /* <-- Add formula here. Use Patch function to update the email value of selected Person in the "Assigned To" field into the "Previous Assigned To Email" column */
'YourSPList',
SharePointForm1.LastSubmit,
{
'Previous Assigned To Email': SharePointForm1.LastSubmit.'Assigned To'.Email
}
);
ResetForm(SharePointForm1);
RequestHide()
If you want to capture the value within the "Previous Assigned To Email" column in your SP List when you edit an existing record using the custom form, please take a try with the following formula:
SharePointIntegration.Selected.'Previous Assigned To Email'
If you want to compare the old "Previous Assigned To Email" column value with updated value Assigned To column value, please use the following formula:
If(
AssignedValueCard.Selected.Email <> SharePointIntegration.Selected.'Previous Assigned To Email',
...,
...
)
Please take a try with above solution, then check if the issue is solved.
Best regards,
