Forum Discussion
Solved
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"....
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
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 :)
