Exploring possibility of preparing Microsoft list directly from Alteryx flow
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Designer Cloud
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
