Forum Discussion
Power Automate 'Send an HTTP request to SharePoint" only returning 300 rows of data
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
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!
Paul_Mather -- Thanks for following-up! Your post has me 90% of the way there, but I'm hung up on this:
Given this schema
{"type": "object","properties": {"value": {"type": "array","items": {"type": "object","properties": {"ProjectId": {"type": "string"},"ProjectName": {"type": "string"},"ProjectWorkspaceInternalUrl": {"type": "string"}},"required": ["ProjectId","ProjectName","ProjectWorkspaceInternalUrl"]}},"odata.nextLink": {"type": "string"}}}In the Do-Until loop, the first page returns an odata.nextlink valueso the subsequent actions complete.
But the for the 2nd loop, the final page returns no data at all -- not even a null value, so the parse operation fails:
And of course, subsequent actions also fail -- including the condition that checks for a Null odata.nextlink value.
Your thoughts?
