question

BalanRamona1NokiaROTimisoara-9400 avatar image
0 Votes"
BalanRamona1NokiaROTimisoara-9400 asked EmilyDu-MSFT commented

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

sharepoint-workflow
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered EmilyDu-MSFT commented

@BalanRamona1NokiaROTimisoara-9400

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.




· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I already have the modern view so I shouldn't be limited and certainly I do not want to delete files already uploaded (except the ones with the workflow not triggered in order to upload them again) ...more files will be uploaded in the future if this bug will be solved...

0 Votes 0 ·
EmilyDu-MSFT avatar image EmilyDu-MSFT BalanRamona1NokiaROTimisoara-9400 ·

Sorry for misleading you. 20000 items for modern list view threshold limit is incorrect.

You could refer this article to know more about how to manage large lists and libraries.


0 Votes 0 ·