Unanswered

Bulk Patch to Dataverse is updating all records, how to update just the ones modified?

(0) Share

Report

Posted on by wezhema

Hey,

I have a gallery that updates a Collection every time I change a value, and I have a button (Submit button) that Patches all the data to a Dataverse table.

The problem is that, when I click the Submit button to patch the data, it updates all the columns in Dataverse, changing the 'Modified on' and 'Modified by' columns.

This is the event that updates the Collection:

If(
 ThisItem.'#001_UserList_Project1' in col_UserUpdates.'#001_UserList_Project1',
 Update(
 col_UserUpdates,
 LookUp(
 col_UserUpdates,
 '#001_UserList_Project1' = ThisItem.'#001_UserList_Project1'
 ),
 {
 Country: If(drp_Country.Selected.Value <> Blank(), drp_Country.Selected.Value, ThisItem.Country),
 FullName: If(txt_FullName.Text <> Blank(), txt_FullName.Text, ThisItem.FullName),
 StartDate: If(dte_StartDate.SelectedDate <> Blank(), dte_StartDate.SelectedDate, ThisItem.StartDate),
 Notes: If(txt_Notes.Text <> Blank(), txt_Notes.Text, ThisItem.Notes),
 '#001_UserList_Project1': ThisItem.'#001_UserList_Project1'
 }
 ),
 Collect(
 col_UserUpdates,
 {
 Country: drp_Country.Selected.Value,
 FullName: txt_FullName.Text,
 StartDate: dte_StartDate.SelectedDate,
 Notes: txt_Notes.Text,
 '#001_UserList_Project1': ThisItem.'#001_UserList_Project1'
 }
 )
)

And this is the Submit button code:

Patch(
 '#001_UserList_Project1',
 col_UserUpdates
);
ClearCollect(
 col_UserUpdates,
 '#001_UserList_Project1',
);
Notify(
 "Records saved!",
 NotificationType.Success,
 2000
)

Does any one know, how to bulk update but at the same time just Patch the items modified?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

bengo83 159 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wezhema

I assume you have an id column in the dataverse table. If you don't have any one you can use another field for the LookUp.

You can use this code for the submit button:
Patch( '#001_UserList_Project1', LookUp('#001_UserList_Project1',ID = YourGallery.Selected.ID), Gallery.Selected );

On this way you only patch the selected row from the gallery to dataverse.

I hope it helps 🙂

Best regards
Beny
wezhema 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Beny,

Thank you for your response, the thing is that I am bulk editing an Editable Grid, like in this video:
https://youtu.be/vRn7br2OaxE?t=2037

I am not editing just a single item, so when I hit 'Submit' it is updating all the rows in Dataverse
bengo83 159 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wezhema
Great, thanks for the clarification 🙂 The colums 'Modified on' and 'Modified by' are always updated, even if you only one value update in a row. As far i know there is no way to avoid this.

The formula to update just several columns in a table is:

ForAll( YourTable, // Replace this with the name of your table Patch( '[dbo].[YourTable]', LookUp('[dbo].[YourTable]', PrimaryKeyField = YourTable[@PrimaryKeyField]), { YourField: YourTable[@YourField } ) )

Best Regards
Beny