@ScottF,
I’ve managed to figure out what the issue was. My issue and the issue I referenced was with column 1/n.
Column 1 in a SharePoint list is the Title column. I excluded the Title column from my table in KNIME as a test and the SharePoint Online List Writer node successfully added my entry to the List.
When i’ve checked my list online, despite having excluded it, the Title column has been written to and populated with the Row ID from KNIME.
Net, I believe the error is happening because KNIME is trying to write the RowID into the Title column but if a user has tried to add their own text into the Title col. in KNIME the list writer fails.
p.s. Please allow us to add only additional rows to a list