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
9 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
Thanks Paul_Mather​ your post helped a lot, I had to change the trimming of the next url as it was hard coded to 46 chars, but once I got that sorted out, it's all working, I can get back all 700+ projects now :)
