Patch not updating multiple fields in a collection record

[MikeAnderson]

Hello,

I'm attempting to use Patch to update multiple fields in a record inside a collection. This collection will then be Patched to the datasource which is an Azure SQL database.  I haven't been able to successfully update multiple fields within the collection, but I am able to update a single field.

This works:

Patch(
    PendingEquipmentRequestsCollection,
    First(
        Filter(
            PendingEquipmentRequestsCollection,
            ID = PendingEquipmentGallery.Selected.ID
        )
    ),
    {
        IsDeleted: true,
    }
);

This does not:

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

I can't figure out why I can't update more than one field in the collection record. Any suggestions?

[shailendra74]

Hi @MikeAnderson 

I dont' see any issue in the code you shared.

Can you refresh the datasource and also ensure that the collection has all fields mentioned in the update and the datatype are matching.

Thanks.

[MikeAnderson]

Nor do I :-).  I tested a few more things and have found the following odd behavior.  Here is the collection before modification:

Here is the patch code:

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

Here is the result after the patch code runs:

What makes this even more interesting is that if I remove the collection and patch directly against the database, IT WORKS!

Patch(
 '[dbo].[EquipmentRequests]',  //This is the azure sql db data source
    First(
        Filter(
            PendingEquipmentRequestsCollection,
            ID = PendingEquipmentGallery.Selected.ID
        )
    ),
    //LookUp(PendingEquipmentRequestsCollection, ID = PendingEquipmentGallery.Selected.ID),
    {
        IsDeleted: true,
        ModifiedDate: Now(),
        ModifiedBy: varCurrentUser.Email
    }
);

And here you can see the record was modified:

So, I'm even more befuddled now.  It works against the data source, but not against the collection and I have no idea why.

[shailendra74]

Hi @MikeAnderson 

Can you run below code separately to check which field is causing a problem.

Patch(
 PendingEquipmentRequestsCollection,  //your collection
    First(
        Filter(
            PendingEquipmentRequestsCollection,
            ID = 4 //hardcoded here
        )
    ),
    //LookUp(PendingEquipmentRequestsCollection, ID = PendingEquipmentGallery.Selected.ID),
    {
        IsDeleted: true,
        ModifiedDate: Text(Now(), "mm-dd-yyyy") // change the format
        // ModifiedBy: varCurrentUser.Email // commented
    }
);

Patch(
 PendingEquipmentRequestsCollection,
    First(
        Filter(
            PendingEquipmentRequestsCollection,
            ID = 4 //hardcoded here
        )
    ),
    //LookUp(PendingEquipmentRequestsCollection, ID = PendingEquipmentGallery.Selected.ID),
    {
        IsDeleted: true,
        // ModifiedDate: Text(Now(), "mm-dd-yyyy") //commented
        ModifiedBy: "testmail.com" // hardcoded
    }
);

Thanks

[MikeAnderson]

Thank you for the suggestion. Due to some app redesign changes I haven't been able to test your suggestion but will and report back.