I am trying to use an sharepoint list as input of my workflow, the list is new and until now it has 148 row and 28 columns, but alteryx get quite slowly when I do any change and today it shows an error like SharePoint List Input (31) Error encountered: An item with the same key has already been added... no matter what I do, I can't access to the data, the more weird thing is the the list don't have any duplicate data, an if it will had, I don't understand why is a stopper to download the information.... I left a picture with the error and an excel with the data.
Any help will be welcome, thank you
But we are trying to find a subtitute for the sharepoint list, because we feel that is unstable, often show a error like: error encountered: Object reference not set an instance...
Do you know how to fix this issue?, thank you.
Which version of Designer are you using?
I saw this error happening with a couple of Sharepoint installations, when Null values are referenced.
What I did was:
- Review the list, looking for null values and change them (Empty or 0s).
- Make sure the workflow that writes to the list, checks and replaces the nulls.
Please, let us know if this help
PS: Have you tried to change the version of Sharepoint in the config tool? (they have different methods to connect, maybe pointing to another version may help too).
The alteryx designer version is 11.7 x64, in fact, I just only use the sharepoint input tool and it returns 2 columns with nulls values by default, the columns are named as version and type of contents, but I don't know how to excluden these columns in the sharepoint input tool, it doesn't have like select option to choose the fields to be download
Had the same issue today. Managed to "fix" it by playing with the data model of the list. I am not sure exactly "how" I fixed it.
I often use InfoPath to edit my form, so might have come from there. I had to re-publish the form and delete a column that was seen as duplicate.
I am not giving the solution, but maybe some ideas