cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Bad Gateway Error (502) - it exceeds the list view threshold??

With flow i scheduled 27 rest api call.

The URI is

 

_api/web/lists/getbytitle('listname')/items?$filter=ColumnName eq 'FilterValue'&$top=5000

 

Only 1 of 27 http requests gave me this error:

 

{
  "error": {
    "code": 502,
    "source": "flow-apim-europe-001-francecentral-01.azure-apim.net",
    "clientRequestId": "f6397a9d-aa13-4dfc-b048-3cda740a5260",
    "message": "BadGateway",
    "innerError": {
      "status": 502,
      "message": "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.\r\nclientRequestId: f6397a9d-aa13-4dfc-b048-3cda740a5260\r\nserviceRequestId: a221619f-80d0-a000-64a9-05482da35f5f",
      "source": "https://*****.sharepoint.com/sites/****/en/WM/GA/******/_api/web/lists/getbytitle('ListName')/items?$filter=SupplierName%20eq%20'FilterValue'&$top=5000",
      "errors": [
        "-2147024860",
        "Microsoft.SharePoint.SPQueryThrottledException"
      ]
    }
  }
}

 

 
2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Bad Gateway Error (502) - it exceeds the list view threshold??

Hello,

 

This error indicates that get items action is timing out due to large number of items retrieved in a minute and throttling.

 

I can see that you are limiting the columns and record count. Please try doing the same using the get items settings "Limit columns by view" and top count.

 

Screen1.png

 

This error can also occur when you have over 20,000 items in the SharePoint list; and for that error, a possible fix is to index all columns used in list view filters,  you can index up to 20 columns or you can also try indexing only the first column in each list view.

 

Please follow the steps in the following link and let me know if this solves the situation: https://support.office.com/en-us/article/add-an-index-to-a-sharepoint-column-f3f00554-b7dc-44d1-a2ed...

 

Hope this helps !

 

 

Highlighted
Frequent Visitor

Re: Bad Gateway Error (502) - it exceeds the list view threshold??

Hi, thanks for your help.

I followed all of your steps.

Unfortunately it still not works.

I did the index of all columns and even reindexed the list

The issue involves only that specific supplier (name)

Pretty sure it's not an "issue for large number of items":

 

 Count of Items in the List
Supplier1487
Supplier10634
Supplier11580
Supplier1239
Supplier13395
Supplier14544
Supplier15272
Supplier16444
Supplier17330
Supplier1840
Supplier19117
Supplier2450
Supplier20307
Supplier3414
Supplier4 -ERROR128
Supplier51
Supplier632
Supplier7786
Supplier8245
Supplier9181
TOTAL6426

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,595)