I'm trying to have a button click on a form patch a status and date of application to a SharePoint record from that SharePoint record's custom Power Apps form.
I'm using the format below which worked when I only had it applying the date (previously it did not attempt to patch the status value).
Set(
varPreviousStatus,
ThisItem.Status
);
Set(
varStatus,
"Assigned"
);
Set(
varAssignedDate,
Today()
);
Patch(
'LIST NAME',
LookUp(
'LIST NAME',
ID = ThisItem.ID,
{
'Assigned Date': varAssignedDate,
Status: varStatus
}
)
);
Now that I'm attempting to patch both the status value and the date it was set, a new record is created with those values instead of updating.
The Status field is single line of text. The date field is a date field.
I don't understand how it is creating a new record when I am clearly indicating the filter for the current item's ID. This is in edit mode. The Status update buttons aren't available for New items.
Is there something I am missing in the code?
