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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get more than 5000 ite...
Power Automate
Answered

Get more than 5000 items in Power Automate

(0) ShareShare
ReportReport
Posted on by 254

Hello,

I am using action "Send HTTP request to SP list" to get more than 5000 items:HTTP request 3.png

I define that max can be extracted 10 000 items. My datasource contains 6000 items.

But I always get an error: 

 

{
 "error": {
 "code": 502,
 "source": "flow-apim-msmanaged-na-centralus-01.azure-apim.net",
 "clientRequestId": "aa094910-ee95-4a8f-be8d-58b71abab7d7",
 "message": "BadGateway",
 "innerError": {
 "status": 502,
 "message": "{\"odata.error\":{\"code\":\"-2147024860, Microsoft.SharePoint.SPQueryThrottledException\",\"message\":{\"lang\":\"en-US\",\"value\":\"The attempted operation is prohibited because it exceeds the list view threshold.\"}}}\r\nclientRequestId: aa094910-ee95-4a8f-be8d-58b71abab7d7\r\nserviceRequestId: bd0201a1-f0d3-4000-cecd-9c3c9c5625d0",
 "source": "...............",
 "errors": []
 }
 }
}

 

How can I solve it?

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,551 Super User 2026 Season 1 on at

    use the standard "Get items" action, click the three dots, enable paging, set the page limit to 1000

  • v-qiaqi@microsoft.com Profile Picture
    on at

    Hi @Aleksandra1,

    Could you please try to modify yoru uri as:

    /_api/web/lists/getbytitle('myList')/items&$top=10000
  • Verified answer
    Aleksandra1 Profile Picture
    254 on at

    Unfortunately, it will not work. I discovered that REST API of SP list can return max 5000 item per one request. The solution is to iterate trough each item by using Apply to each. To go to next items in iteration use "odata nextlink" from request 🙂

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 248 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 207 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 101 Super User 2026 Season 1

Last 30 days Overall leaderboard