cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Anonymous
Not applicable

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.

Anonymous
Not applicable

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.

Anonymous
Not applicable

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

Anonymous
Not applicable

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 Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (91,211)