Sharepoint List Input | Alteryx 11.7 Views not populating

I am connecting to a company SharePoint site that utilize single sign on. I'm not receiving any errors when connecting to the SharePoint and all of the lists populate within the tool. I am an admin of the site and I also gave myself full control, design, and edit rights to the individual lists that I am having problems. with.

For some reason I have two lists that will not populated any view names. This causes an error when trying to connect to the list. All other lists populate views just fine. These two lists are the primary lists on the site that are utilized. I went in and removed all but the primary views in thinking that it might be having too many views. I also archived the majority of the data on the list to ensure that there wasn't too many records for the list to populate. I have included a screenshot below of the error that I am receiving. Does anyone have any thoughts on what might be causing the view information not to populate?

Sharepoint List Input Error.jpg

Input

Connectors

Sharepoint

Accepted answers

justin_grosz

Had this issue at a current client and we are seeing some lists populate with views and others that do not. For the lists that do not populate with views, I have hard coded the XML and it appears to be working. Here is what I did depending on your familiarity with XML code.

1. Go to your configuration and make sure there is the XML logo on the left (</>). If you do not see that go to Options > User Settings > Edit User Settings > Advanced > Check Display XML in Properties Window.

2. Click </> and hit edit in the top right

3. Your username, password and lists should be populated already but there is nothing for view

4. Insert this line of code <View>ViewName</View> (ViewName is the View you are looking for)

5. Sample to make sure it works <RowLimit>10</RowLimit>

6. Run

Hope that helps,

Justin Grosz

Sr.Advanced Analytics Consultant

Cleartelligence

All comments

TMOCliff

I have an identical issue in a SharePoint 2016 / Office 365 environment. Some (most) lists on our site populate views without issue in the SharePoint List Input Tool. A handful of my lists, and of course the list that I actually need to connect to, do not display views in the drop-down. Instead, the drop-down is blank and no views are offered for selection.

I raised an issue with Alteryx Support, and I'll loop back here when and if they help me find a resolution.

fwalton

TMOCliff,
Also experiencing the same symptoms. Almost all lists populate, but the particular list we're seeking data from as a source will not populate the View dropdown. Nothing apparently unusual about the SP list, it is accessible, has multiple views, all of which are functional in the browser. Will let support focus on one ticket resolution and attempt resolution based on that.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703