Skip to main content
Question

Odata Error Message Value: The attempted operation is prohibited because it exceeds the list view threshold.

  • 29 May 2024
  • 1 reply
  • 32 views

Hi everyone,

 

I am trying to do the following automation for inbound deals with these main steps:

Trigger: New email in a certain mailbox

Actions:

  1. Identify the deal name
  2. Find whether this deal already exists as a folder in Sharepoint
  3. If not, create the folder
  4. Save the attachment(s) of the email into that folder

I am having issues with step 2, I assume because there are too many folders there already.

Is there a workaround to this problem?

This is the output I get:

Odata Error Message Value: The attempted operation is prohibited because it exceeds the list view threshold.
Pls see below:
 
ACTION:

TEST OUTPUT:

 

 Thank you for your help!

Barbara

1 reply

Userlevel 7
Badge +14

Hi @Barbara_barbara 

By default, the list view threshold is set to 5,000 items for regular users and 20,000 items for administrators.

You may have to explore using the SharePoint API to do more advanced querying to work around the encountered error.

https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service?tabs=csom

 

 

Reply