Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: "An Item with the Same Key has already been added" with Sharepoint List Input Tool

Alteryx
Alteryx
Created

Environment Details


  • Alteryx Designer
    • All
  • Sharepoint List Input Tool

When reading in a Sharepoint List, the following error is seen:
An item with the same key has already been added

idea Skyscrapers

Cause


There are multiple columns with the same name in the View you are reading from.



Resolution


Correct the duplicate column names directly in Sharepoint. Alternatively, you can create a view that omits the duplicate columns.

Comments
5 - Atom

Hi sophiaF,

 

I am facing the same issue. I checked for duplicate columns in my view but all are unique. Do you have any other suggestions for this issue?

 

Thanks,

Gaurav