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