web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / send an http request t...
Power Automate
Unanswered

send an http request to sharepoin - get more than 300 items

(0) ShareShare
ReportReport
Posted on by

Hello
I created a flow using the connector "send an http request to Sharepoint" to get all the tasks for a project, and then use "apply to each" to create a new record in the common data service. The project in question, has about 2000 tasks. The problem is that the connector "send an http request to Sharepoint" is only getting 300 tasks (items). Any way I can increase the amount of items that this connector pulls?

Note: As the file is not in a list, it is not possible to use the "Get items" connector

Anotação 2020-03-23 163458.pngpic.png

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,979 Most Valuable Professional on at

    Hi @Anonymous ,

     

    You have couple of options.

     

    Option 1:

    You can get the items using /_api/web/lists/getbytitle('infolist')/items?$top=3000

     

    Option 2:

    You can use the same http call and using a Do until loop when not(empty(body('your get api name'))). Steps are:

    1. Call your http step

    2. Declare a boolean flag nomorerecords to false

    3. Add a do until loop check the flag (nomorerecords) is true

    4. handle your result sets

    5. Call your http step again

    6. set the flag using this expression not(empty(body('your get api name')))

    7. loop back to step 3

     

    Option 3:

    Finally using the premium HTTP connector you can set the paging by setting the pagination on and set the threshold. Believe the maximum is 5000.

     

    image.png

     

    image.png

  • paulwmather Profile Picture
    2 on at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard