Hi All,
I have a gallery that is setup to look similar to an Excel table, where the gallery has input boxes instead of labels connected to my SharePoint list.
The idea is for users to be able to come into the app and update certain column values for each row. They will likely only be updating one column at a time, but I want them to be able to do this for multiple rows at once (as opposed to one row at a time in a form).
The issue I'm having is that the Patch function I currently have on a "Save Changes" button is adding a row every time instead of updating an existing row. Basically, I want to be able to do a bulk update that writes back whichever few rows were changed instead of adding all new rows to the SharePoint list. Would love some guidance on how I can accomplish this.
This is the function I currently have where ExistingID.Text is the unique ID from Sharepoint that I have embedded into each row of my gallery.
ForAll(ReportGallery.AllItems,
Patch(
'Report Audit',
LookUp(
'Report Audit',
ID = Value(ExistingID.Text),
{
Date: ExistingDueDateInput.Text,
Area: ExistingAreaInput.Text,
'Report Name': ExistingReportNameInput.Text,
Owner: ExistingOwnerInput.Text,
Reviewer: ExistingReviewerInput.Text
}
)
)
);
