Sharepoint Output Tool - Overwrite not reliably deleting old list items

[nenkler]

Hi Experts,

I have a workflow which should update a Sharepoint list with about 800 items / rows. 
In order to do that I use a Sharepoint Output Tool to overwrite the list. According to the description this deletes all the records in the list and then adds the list items.

What I see repeatably is that the overwrite action doesn't delete all rows. It essentially seems to perform the delete column by column really removing columns. When it comes to the main indexed column, lets call it "Identifier" I see that this columns remains and only about 30 of the rows are really deleted.

This seems super unreliable, any clue how to successfully and securely delete Sharepoint list items?

Thanks and best regards,

Nils

[Ishmael_Appiah]

Hi did you ever overcome your SharePoint issues? We are facing a similar issue using the latest version of the SharePoint output tool 2.7.1.

This version has the overwrite but retain exist fields option. The workflow runs without error, however the SharePoint list isn't updated/overwritten with new records.

[nenkler]

Hi Ishmael,

I did abandon the Sharepoint list write and instead rely on the much faster and more reliable Sharepoint file write. 

So instead of directly editing the list I work with CSV files which are written to a Sharepoint document library. 

From there I use a automated PowerAutomate Flow to ingest the file into a Sharepoint list. 

This works very reliably and much much quicker then the Alteryx based list modification. 

I hope that helps.

[Ishmael_Appiah]

ok thanks, I fear I may need to go down the same route.

I'll still look to progress the issue with Alteryx at the same time, since their tool should work as advertised.