Currently the SharePoint Online List Writer node only allows ‘Overwrite’ or ‘Fail’ if the list already exists. This means the current work around is to use the SharePoint Online List Reader node to bring into KNIME the current list, append our new list items, and re-write the whole thing again.
This is ok for small lists, but going beyond a few 100 list items, the performance of the writer node is then extremely poor.
Enabling the ‘append’ option will be extremely beneficial.
Thank you for the feedback!
1 Like
Hi @darspir - do you know if this feature will be developed? Or is there a workaround available?
Hi @mewalsh ,
thanks for posting!
I have added plus one on this matter in our internal tracking system on your behalf (nr. AP-21548).
Best,
Daria
2 Likes
@Ultraman @arrtee Hi both, I found a thread where you both wanted an append option for SharePoint lists. Here is an idea on this very topic. If you add your vote to it, hopefully it will increase chance of getting developed.
Thanks, this is a good idea because it also enables the node to be used in cases where it’s not possible to overwrite, i.e., where the Sharepoint row ID needs to be preserved. @darspir The other thing I find really frustrating is trying to use variables as list names in the Sharepoint reader node. It can’t seem to handle this without manually choosing the list name from the dropdown in the node config. This kind of obviates the need for a variable if it can never be applied.
1 Like
We work with data saved in SharePoint lists as well (it’s, for practical everyday use, a great way to have people obey a more stricter form for their data entry, without making them use a database tool/make a technical data upload), and it would be really helpful for our office workflow automation if KNIME were able to add individual items (= lines) to SharePoint lists. Definitively my top missing feature of KNIME as we use it here.
2 Likes
@hariharanpavan @benpope @s3marube Hi folks. I found a few different threads where you were interested in an append option for the SharePoint lists writer node. If you add your vote to this idea request, hopefully it will increase the chance of getting developed. Thanks.
1 Like
@darspir any update on if this has been accepted/added to a development list?
Is there any update on this? I am going insane over here from having to use PowerAutomate for list updating. PLEASE implement this in KNIME!
2 Likes
@darspir any update on this item please?
It looks like Daria does not work for KNIME anymore. @ScottF Perhaps you can gather insights into AP-21548? 
I checked the ticket and don’t have anything new to report. Let me ask internally and see what I can find out.
2 Likes
Thanks @ScottF , much appreciated
@ScottF were you able to find anything?
Hi @mewalsh I checked again today. Short answer is that the developers are aware of the issue, they have just had higher priorities in other areas recently. I would encourage the community to keep voting here, that really does have an effect!
1 Like
Hello,
I am new to KNIME. Just to confirm, (because I can’t see how to do it) we can’t add or edit items on a SharePoint list? We can only delete a whole list and put it back? Surely there needs to be a way to do this.
1 Like
Hi @fodelement. Yes that’s correct. I have been following up on this request for 12 months, but we are still waiting development of this feature.
Hi all, do we have any news here? Isnt there any workaround?
Br,
Count me in, I would also love the ability to append!
I need to push a decent number of rows into a list (60k-130k), and it just dies. Tried various things, changing the timeout, nothing worked I gave up. Today I revisited the flow with the “genius” idea that if I Chunk Looped the data it, I would be saved. Then, I was heartbroken again by the lack of an append feature, so here I am.
I don’t know what Knime developers are “running on”, I am assuming Pizza and Coffee, but I am willing to chip in if needed
Name your price 
This single feature would save me countless hours of Access struggle.
Hopefully it will come with a column name matching option, that would be perfect, but I’ll take whatever I can get.
Thank you!
2 Likes