Exploring possibility of preparing Microsoft list directly from Alteryx flow

Question

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 Answer

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