Exploring possibility of preparing Microsoft list directly from Alteryx flow

[SahadhKuruniyan]

For one of my projects, we take out put from Alteryx and then manually prepare Microsoft list in sharepoint (input is an excel file). Yesterday I get to know about sharepoint list output to prepare a new list from Alteryx output. But I am not 100% sure if this work for me. Would appreciate help from expert

[danilang · Accepted solution]

Hi @SahadhKuruniyan 

This is indeed possible and is something that we do in our company.  The only caveat is that SharePoint will impose a limit on the number of rows that you can insert at a time.  In our environment It's about 100.  To get around this, we put the List output tool in a batch macro and only send about 50 rows per batch.

Dan

[SahadhKuruniyan]

Thanks Dan for the help, Much appreciated.

For my Project line items(Rows) are 20,000. However, can you please share a dummy workflow with the macro you use. I am very new to Alteryx, so I can implement same set of tools in my workflow and give it a shot