SharePoint Input List Error

Question

Has anyone received this error. I'm trying to link my SharePoint list to Alteryx. Everything within the tool looks like it is set up properly but I am receiving this error when I try to run.

Screenshot 2025-10-28 101405.png

aatalai · Answer

@gabbyparks97 can you please upload a screenshot of your config too?

Mathangopal · Answer

Why You’re Seeing This Error

* Alteryx is trying to read data from your SharePoint list.
* The data contains characters or formatting that are not compatible with the default UTF-8 encoding Alteryx expects.
* This often happens if the SharePoint list has special characters, non-English text, or was created/edited in a system using a different encoding (e.g., Latin-1, Windows-1252).

How to Fix the Issue 1. Check Alteryx Input Tool Settings

* Encoding Option:* If you are using the SharePoint Input tool or a connector, look for an option to specify the file or data encoding.
* Try changing the encoding from UTF-8 to another (e.g., Latin-1 or Windows-1252) if available.

2. Clean or Export the Data

* Export the SharePoint list to Excel or CSV.
* Open the exported file in Excel and save it as a new CSV, ensuring it is encoded in UTF-8:* In Excel:* Go to File > Save As
* Choose CSV UTF-8 (Comma delimited) (.csv)

* Use this new file as your input in Alteryx.

3. Use a Data Preparation Step in Alteryx

* If you must use the direct SharePoint connection, add a Data Cleansing tool in Alteryx to remove or replace problematic characters.
* Alternatively, use a Python or R tool in Alteryx to read the data with a different encoding.

4. Check for Special Characters

* Review your SharePoint list for any unusual or non-standard characters (e.g., emojis, accented letters).
* Remove or replace these characters if possible.