I've been exploring the patch function, and I have a SharePoint list and a Dataverse table. Each data source has a Title (primary name) column, progress (text), outcome (text) and ID (autonumber).
I have the following code:
ClearCollect(
colUpdateWorkLog,
Table(
WorkLog@{
ID: 2,
Title: "New Value",
Outcome: "Updated Outcome"
},
WorkLog@{
ID: 4,
Progress: "Active"
},
WorkLog@{
ID: 5,
logDate: Date(2022, 08, 01)
}
)
);
Patch(
WorkLogs,
ShowColumns(
colUpdateWorkLog,
"ID"
),
colUpdateWorkLog
);
In SharePoint this code works as expected, though in Dataverse it does not and creates new rows with the values in the collection rather than updating the relevant rows in the table.
Any advice on this would be appreciated as I'm scratching my head and can't seem to come up with an answer.