Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • Troubleshooting
  • Odata Error Message Value: The attempted operation is prohibited because it exceeds the list view threshold.

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

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


Terms & Conditions