Skip to main content
Question

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

  • May 29, 2024
  • 1 reply
  • 82 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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 29, 2024

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