I have used the faster way to patch to a SharePoint list for updating a column and wanted to now do the same for creating new rows, but I'm getting an error. I loaded a collection with many rows with the same column names in my list, but on the line to patch the list using the collection an error shows saying "Invalid argument type (Table), expecting record".
This is the code to build the collection and then call the patch.
ForAll(
sessionCon,
Collect(
attendCol,
{
ProgID: ThisRecord.ProgID0,
CustCID: ThisRecord.CustCID,
CustID: ThisRecord.CustID,
SessionID: varsessID,
Title: ThisRecord.ProgID0 & " " & varsessID & " " & ThisRecord.CustID & " " & ThisRecord.CustCID,
Participated : ThisRecord.Participated
}
)
);Patch(Attendance,attendCol)
If I only put one line in the collection it works, but it doesn't seem like it likes more. When I did this to update multiple records, I loaded a collection with the IDs and columns to change, so I don't get why I can't pass many records this way....
