Trigger workflow error

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