Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Share Point Input List Error

anandakrishnan
7 - Meteor

When we are trying to connect SharePoint list for some list this error is coming. 

1. Error: SharePoint List Input (1): Error encountered: The attempted operation is prohibited because it exceeds the list view threshold.

2. Error: SharePoint List Input (1): Error encountered: The property or field has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.

2 REPLIES 2
gautiergodard
13 - Pulsar

Hi @anandakrishnan 

The first error seems to be related to the size of the view, if your list has different views associated to it, try pulling for a different one. If you are pulling from the default All Items view, perhaps you can try to create a new view with less fields to see if this resolves the error. As an alternative, I would also recommend trying the data pull with different SharePoint versions from the tool dropdown as this can affect which fields get pulled down.

 

For the second error, please ensure the list you're trying to pull is saved on SharePoint and no one is in the list settings making changes to any of the fields. 

anandakrishnan
7 - Meteor

Hi @gautiergodard, 

 

Thanks for responding. 

We had tried with all items view also still the same error comes, but for some list it does not have any issues.

Secondly, the SharePoint list is a Realtime one which gets updated on a day to day basis so the list is modified regularly. 

Can suggest any other possible ways to resolve the issues.

Labels