Fail connecting to a SharePoint List - no Views to select!

[rebelvin]

I am trying to use a SharePoint List as an input, using the SP List Input Tool, and can do this on other SharePoint Lists, but I have one List which fails to show any Views for me to select.

Someone else in the same environment has no trouble connecting, as Views show up for them, and they just pick one.

I have the same permission on the list as that person.

Any ideas? Alteryx Designer 2019.2, SP 2016.

I tried the below solution, but it did not work:

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

[Latez]

I'm having the same issue!

[john_watkins]

Permissions sound good.  Are you using the exact same SP list base URL?  Are you selecting Run to populate the list?  Crazy questions, but I've done all three 🙂

[uvanhout]

For some reason this XML edit is not working for me. I am able to get views to populate for 4 other SharePoint lists but am having problems getting any views to show for one specific one. When I add in the View name in the XML code I still get "No View Found". Is there anything else in the XML code that I need to adjust ("701" is the title of the view I'm trying to find)?

<ListName>XXCapital Plan</ListName>
<ListId>3e0520eb-fa0b-4dca-9a73-601c915eb8fa</ListId>
<SearchViewsArray>
</SearchViewsArray>
<SearchKeyListsView>
</SearchKeyListsView>
<IsOnEnterSearchViews>false</IsOnEnterSearchViews>
<ViewName>701</ViewName>
<ViewId>
</ViewId>
<Secrets />
<UpdateRun>false</UpdateRun>
</Configuration>

It is as if the list is not being recognized. Any pointers would be greatly appreciated!