Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Exploring possibility of preparing Microsoft list directly from Alteryx flow

SahadhKuruniyan
8 - Asteroid

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

 

SahadhKuruniyan_0-1686422777958.png

 

 

2 REPLIES 2
danilang
19 - Altair
19 - Altair

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
8 - Asteroid

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

Labels
Top Solution Authors