In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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