cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeAnderson
Level 8

Patch not updating multiple fields in a collection record

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?

 

4 REPLIES 4
shailendra74
Level 10

Re: Patch not updating multiple fields in a collection record

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
Level 8

Re: Patch not updating multiple fields in a collection record

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

BeforeSave.png

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:

 

AfterSave.png

 

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:

 

DatasourceSave.png

 

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
Level 10

Re: Patch not updating multiple fields in a collection record

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
Level 8

Re: Patch not updating multiple fields in a collection record

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.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,985)