Sharepoint Output not outputting full data

[MDonnel8]

I'm having an issue with the Sharepoint Output tool - I have a dataset thats roughly 700k rows but when I try to output it to Sharepoint it can only output 180k rows. Also, the workflow keeps running indefinitely even after the output tool has finished. Is there a limit to how much data the tool can write to Sharepoint?

[Swathi]

May be try to use csv instead

[MDonnel8]

Hi Swathi,

Still getting the same issues where it only outputs the exact same amount of rows as before (179002 - roughly 25%) and continues to run indefinitely

[jpammant]

Did you get an answer? I am having the same issue.

I have had success by using the select tool, and limiting the number of columns to 6. 

Then I run a new workflow, reading in the List just written, and using the join tool with the Excel file.

Using the block and select tools and the SP List ID and a unique ID to tie them together, I  update 6 columns at a time. Not very efficient, but it works.