Power Platform Community Forum Thread Details

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?

Categories:

General Questions

Connecting to Data