Error with Sharepoint output tool.

APAlteryx

I have a sharepoint output tool, that writes to a list using the upsert feature.   I have a UID column which is created which is not the sharepoint ID column.    IT was working before, but now i am getting this error.  Any idea what this means?

Error: SharePoint Output (60): API response: {'lang': 'en-US', 'value': 'A list item with ID {0} already exists.'}

Dean4U

Hi @APAlteryx,

Thanks for reaching out to us. It appears that the SP outpoint tool is attempting to insert a new item using an ID that already exists in the SharePoint list, rather than updating the existing item.

Please go to the “Upsert Options” in the SharePoint Output tool and verify that Upsert is enabled and the Match Field is set to your custom UID field and not the internal SharePoint ID field. Ensure there are no duplicates in your input data. If your input contains duplicate values for UID, even valid upsert logic will fail. Use a Unique tool or the Summarize to confirm you’re sending only one row per UID.

Additionally, please confirm that the UID exists in the SharePoint List.SharePoint can only update an existing record if it finds a match. If a UID doesn’t exist in the list, Alteryx will attempt to insert it, which may cause a conflict if the ID was manually set or mapped.

Please send us a screenshot of the config panel for the SPO tool, in case the above suggestions do not help.

Take care.