cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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
Highlighted
Anonymous
Not applicable

Re: Patch not updating multiple fields in a collection record

Hi @Anonymous 

 

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.

Highlighted
Anonymous
Not applicable

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.

Highlighted
Anonymous
Not applicable

Re: Patch not updating multiple fields in a collection record

Hi @Anonymous 

 

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

Highlighted
Anonymous
Not applicable

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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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