Forum Discussion
Power Automate 'Send an HTTP request to SharePoint" only returning 300 rows of data
My PWA site has over 900 projects, but the following action only returns exactly 300 items. This feels like a returned rows limit of some sort, but I still get only 300, even when I use "&?top=1000".
Any ideas?
Hello humphriesk ,
I wrote this blog post a few years back, I hope it helps (and still works!) https://pwmather.wordpress.com/2020/09/20/handling-pagination-in-powerautomate-sharepoint-http-flow-action-for-projectonline-flows-office365-automation-workflows-powerplatform-poweraddicts-nocode-lesscodemorepower-msproject/
Paul
8 Replies
Hello humphriesk ,
I wrote this blog post a few years back, I hope it helps (and still works!) https://pwmather.wordpress.com/2020/09/20/handling-pagination-in-powerautomate-sharepoint-http-flow-action-for-projectonline-flows-office365-automation-workflows-powerplatform-poweraddicts-nocode-lesscodemorepower-msproject/
Paul
- Thanks for the swift reply! I'll review your blog post, but it looks like exactly what I am looking for!
- cross-posted to Power Automate forum
