Patch creating duplicate record

[Anonymous]

Hello,

I'm having an issue with Patch() creating duplicate records in my collection.  My goal is to update a few fields in a record within a collection and then Patch the collection to the database to update the fields in the database.  The issue I'm running into is that Patch is creating a duplicate record in the collection.  I have a gallery, where a user selects a record and can delete the record.  The delete is a soft delete in that a field in the record contains an IsDeleted value. Here is the collection before modification:

Here I've selected the record I wish to delete and verfied that the selected record is correct by using a label to display the PK ID of the record.

Here is the orignal collection now showing a duplicate value:

Finally, here are the various permutations of Patch I've tried to make this successfully work:
Using Lookup:

Patch(PendingEquipmentRequestsCollection, Defaults(PendingEquipmentRequestsCollection),
    LookUp(PendingEquipmentRequestsCollection, ID = PendingEquipmentGallery.Selected.ID),
    {IsDeleted: true, ModifiedDate: Now(), ModifiedBy:varCurrentUser.Email}
);

Using First/Filter:

Patch(PendingEquipmentRequestsCollection, Defaults(PendingEquipmentRequestsCollection),
    First(Filter(PendingEquipmentRequestsCollection, ID = PendingEquipmentGallery.Selected.ID)),    
        {IsDeleted: true, ModifiedDate: Now(), ModifiedBy:varCurrentUser.Email}
);

Here is the validation of the selected record displayed in the label box:

First(Filter(PendingEquipmentRequestsCollection, ID = PendingEquipmentGallery.Selected.ID)).ID

If I don't include 

Defaults(PendingEquipmentRequestsCollection),

Nothing happens at all, but when I include it, it duplicates. Any suggestions on what I'm doing wrong?

[Pstork1 · Accepted solution]

YOu can't use Patch to update existing records in a collection.  For that you need to use Update().  Patch can only be used to create new records in a collection.  It can update records in a datasource, but not a collection.

[Anonymous]

Hey,

Defaults() will automatically create new item. You just have to try using it without it and be sure that the ID validation is correct.

Patch(DataSource, {ID : MyID}, {field: value})

Hope this helps.

[Anonymous]

Also you should not use, I think, modified date and by who it was modifaied as this happens automatically in Sharepoint.