Sharepoint Output not outputting full data

Question

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?

MDonnel8 · Answer

No unfortunately I have not gotten a solution to this problem

_wlm_horton · Answer

Is there any update on this @AlteryxAdmin? This would be a great tool if it worked! It would allow us to automate some workflows and justify the purchase of a server.

jpammant · Answer

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.

Update 6 columns at a time.png