I have created a Blank Vertical Gallery that displays data from the SharePoint list. There are several dropdown fields and some text fields.
I have added a button field with the following code in its OnSelect and called Select(button) on all the above field's OnChange property.
If(
IsBlank(
LookUp(colGridUpdates1,
ID = ThisItem.ID
)
),
Collect(colGridUpdates1,
ThisItem
)
);
UpdateIf(
colGridUpdates1,
ID = ThisItem.ID,
{
Location:drpdLocation1.Selected,
Reference_ID:Value(txtReference_ID.Text),
Approved:drpdApproved1.SelectedText
}
)
I then path the collection to the SharePoint using the following code. I clear the collection at the end of "Save" but the collection reloads all the items again as if the OnChange action was called on all items.
Patch(
'GFS FSS',
ShowColumns(
colGridUpdates1,
"Location",
"Reference_ID",
"Approved",
"ID"
)
);
Notify("Grid changes updated successfully",
NotificationType.Success,
1500
);
Clear(colGridUpdates1);
