Get more than 5000 items in Power Automate

(0) Share

Report

Posted on by Aleksandra1

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:

General topics

I have the same question (0)

All responses (3)

Answers (1)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Aleksandra1,

Could you please try to modify yoru uri as:

/_api/web/lists/getbytitle('myList')/items&$top=10000

Was this reply helpful? Yes No
Verified answer

Aleksandra1 254 on at

Like (0)

Report

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 🙂

Was this reply helpful? Yes No