Power Platform Community Forum Thread Details

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

Categories:

Building flows

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