Trigger workflow error

Question

Hello,

I have created a workflow that has to copy in a SP list the information contained in the title of each Excel file that is uploaded in that list.

This list is replacing a tool which will no longer be used so the files used in the past years had to be uploaded also: 6257 Excel files.

The issue is that for the last 1370 files uploaded on the list the workflows weren’t triggered and now if I upload a new file the same result no flow is triggered.

Bellow you may find the error, but I don’t think that is the correct reason “"The attempted operation is prohibited because it exceeds the list view threshold" because I have the “new experience” and there’s a limit of 20000 items if I’m not mistaken.

I think that there are others limitations involved. How do I repair this bug?

"statusCode": 502,

"headers": {

"Pragma": "no-cache",

"x-ms-request-id": "52eecb9f-40ce-2000-f97a-2bb18ed778b9",

"Strict-Transport-Security": "max-age=31536000; includeSubDomains",

"X-Content-Type-Options": "nosniff",

"X-Frame-Options": "DENY",

"Cache-Control": "no-store, no-cache",

"Set-Cookie": "ARRAffinity=7007353e6908e52d8a882a0d248752a54a5a3b25dfdde97fabc8ecca38b8d51c;Path=/;HttpOnly;Secure;Domain=sharepointonline-ne.azconn-ne.p.azurewebsites.net,ARRAffinitySameSite=7007353e6908e52d8a882a0d248752a54a5a3b25dfdde97fabc8ecca38b8d51c;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-ne.azconn-ne.p.azurewebsites.net",

"Timing-Allow-Origin": "*",

"x-ms-apihub-cached-response": "true",

"Date": "Thu, 27 May 2021 07:27:11 GMT",

"Content-Length": "895",

"Content-Type": "application/json",

"Expires": "-1"

},

"body": {

"error": {

"code": 502,

"source": "flow-apim-europe-001-westeurope-01.azure-apim.net",

"clientRequestId": "88db0cbc-0d3d-4061-88c8-34c03d64f266",

"message": "BadGateway",

"innerError": {

"status": 502,

"message": "The attempted operation is prohibited because it exceeds the list view threshold.\r\nclientRequestId: 88db0cbc-0d3d-4061-88c8-34c03d64f266\r\nserviceRequestId: 52eecb9f-40ce-2000-f97a-2bb18ed778b9",

"source": "https://nokia.sharepoint.com/sites/iondeploymentdelivery/eur...'",

"errors": [

"-2147024860",

"Microsoft.SharePoint.SPQueryThrottledException"

]

}

}

}

}

see less

Answer 1

@Balan, Ramona 1. (Nokia - RO/Timisoara)

You may be confused with the list view threshold limit. It’s set as 5000 items for classic view and 20000 items for modern view. The list view threshold limit is not a hard limit, you can have more items than that but certain operations and tools may stop working.

You could delete some files that have completed the workflow to ensure the workflow is running successfully.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.