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

[SophiaF]

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

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.

[gaurav726]

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

[jhinks]

My colleague found the following solution.

Go to the list in SharePoint > Add column > Show or hide columns > hide the following columns.

ID

Modified by

Modified

Created By

Created

Version

Content Type