Not Bringing in ALL items from Sharepoint List
I am using bridge to connect to an existing list in SharePoint. This is part of a bi-directional connection I am making between my Smartsheet and SharePoint. I have been successful in pushing updates made in Smartsheet to Sharepoint. However, when creating the workflow to push updates (for separate fields from the push to SharePoint) I am not retrieving all rows from the SharePoint list . The connection is live, however the array generated for my Child Workflow seems to be capped at 200.
Below are screenshots of the simple Parent Workflow at the moment as well as a capture of the data array captured with the 'Get SharePoint List' module. According to the SharePoint module reference, I should be capturing ALL rows (as I am not applying any filters to the data). https://help.smartsheet.com/articles/2482598-sharepoint-module-reference
Any help would be greatly appreciated!
Tagging @Genevieve P. since she's a rockstar!
Thanks,
Ben
Answers
-
Hey @plbc
Thanks for the tag and the kind words!
I've actually seen this before (here) - this has to do with how the Sharepoint API sets up its default pagination. The first page of results is 200, which is why you're seeing a cap at that number. (Here's a thread about this in the Microsoft Community).
The module that Bridge has set up only uses the default Sharepoint API, so there isn't a way to set a different page number or increase the results per-page in the Bridge module.
I would suggest using the new API utility instead of the Sharepoint Get List module to be able to get all of your list data in one Array.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives