Skip to main content

Notifications

Power Automate - Using Connectors
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.

  • Pstork1 Profile Picture
    Pstork1 64,996 on at
    Re: SharePoint HTTP GET returning error SP Query Throttled Exception 502 Bad gateway

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

  • Daniel_Scott4 Profile Picture
    Daniel_Scott4 13 on at
    Re: SharePoint HTTP GET returning error SP Query Throttled Exception 502 Bad gateway

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

  • Verified answer
    Pstork1 Profile Picture
    Pstork1 64,996 on at
    Re: SharePoint HTTP GET returning error SP Query Throttled Exception 502 Bad gateway

    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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics