cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cfnwfwmd
Helper I
Helper I

Bad Gateway error when using Flow

I have a flow that moves newly created files on OneDrive/Sharepoint to an FTP.  It's run smoothly for days but failed today with the following error 

 

{
"error": {
"code": 502,
"source": "flow-apim-msmanaged-na-centralus-01.azure-apim.net",
"clientRequestId": "2675e2de-8acb-4b23-b97d-8dd7770993a9",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "The attempted operation is prohibited because it exceeds the list view threshold.\r\nclientRequestId: 2675e2de-8acb-4b23-b97d-8dd7770993a9\r\nserviceRequestId: c855a89f-3008-b000-d6d9-a97053d8193e",
"source": "#####################################/GetFolderByServerRelativePath(decodedUrl=@p)/Files?$filter=TimeCreated%20ge%20datetime'2021-02-05T07:48:29Z'&$orderby=TimeCreated,Name&@p='%2fsites%2f####################################################################'",
"errors": [
"-2147024860",
"Microsoft.SharePoint.SPQueryThrottledException"
]
}
}
}


BadGateway, 502, Microsoft.SharePoint.SPQueryThrottledException

 

cfnwfwmd_1-1612547754407.png

 

 

cfnwfwmd_0-1612547562301.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Kcronic1
Community Support
Community Support

Hello @cfnwfwmd,

 

In reviewing your post. The error you are receiving sounds like you have exceeded the List/Library View threshold and have been blocked. This is because there is a view threshold of 5000 items in a view.

 

With the information provided my suggestion would be to evaluate the limits here: SharePoint limits - Service Descriptions | Microsoft Docs, and determine if you need to remove some of the items in the library, and/or determine if you want to setup indexing to assist with the views.

 

Here are a couple of links that may help with creating indexes and managing large lists/libraries:

Add an index to a list or library column - SharePoint (microsoft.com)

Manage large lists and libraries - SharePoint (microsoft.com)

 

Hopefully, this helps! 😊

 

Regards,

Kristie

Community Support Team

 

If this post helps, then please click on the "Accept it as the solution" to help the other members find it more quickly.

If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: Get Help + Support - Power Platform | Microsoft Docs

View solution in original post

2 REPLIES 2
Kcronic1
Community Support
Community Support

Hello @cfnwfwmd,

 

In reviewing your post. The error you are receiving sounds like you have exceeded the List/Library View threshold and have been blocked. This is because there is a view threshold of 5000 items in a view.

 

With the information provided my suggestion would be to evaluate the limits here: SharePoint limits - Service Descriptions | Microsoft Docs, and determine if you need to remove some of the items in the library, and/or determine if you want to setup indexing to assist with the views.

 

Here are a couple of links that may help with creating indexes and managing large lists/libraries:

Add an index to a list or library column - SharePoint (microsoft.com)

Manage large lists and libraries - SharePoint (microsoft.com)

 

Hopefully, this helps! 😊

 

Regards,

Kristie

Community Support Team

 

If this post helps, then please click on the "Accept it as the solution" to help the other members find it more quickly.

If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: Get Help + Support - Power Platform | Microsoft Docs

View solution in original post

Thank you! 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (931)