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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint HTTP GET re...
Power Automate
Answered

SharePoint HTTP GET returning error SP Query Throttled Exception 502 Bad gateway

(0) ShareShare
ReportReport
Posted on by 13

I have a flow that ran fine until I got over 13k in my list. Now When I try to run a new flow I get this error.

BadGateWay "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: 14f03ddd-6147-49d6-8368-7acef1968b62\r\nserviceRequestId: a6fb6aa0-d0e1-d000-83f4-15a742955b6a",
                "errors": []
 
Here are the screen Shots from my flow.
Daniel_Scott4_0-1664796879152.png

 

Daniel_Scott4_1-1664796932479.png

 

Daniel_Scott4_2-1664796956317.png

The filter should return a with zero results because I don't have any on in the list for the filtered Facility.

@Pstork1  I met you at the Dallas 365 EduCon and you said if we have an issue we can't solve to tag you and mention it and you would take a look.

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    69,383 Most Valuable Professional on at

    The problem is that when doing an HTTP REST call you are subject to the normal limits of SharePoint.  There is nothing you can really do here other than put everything into a different data source. I would have expected it to start throwing this error when your list got bigger than 5,000

  • Daniel_Scott4 Profile Picture
    13 on at

    Makes perfect sense except I thought it would still work because I am using a filter to reduce the view under 5,000. 

  • Pstork1 Profile Picture
    69,383 Most Valuable Professional on at

    I don't think delegation will get you around the 5,000 record limit when using an HTTP REST call.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard