We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Alteryx Publish to SharePoint list- Hexadecimal Error

aehrenwo
11 - Bolide

I have a workflow that was working properly until last week. 

 

The long story short is that is determines new rows to add to a SharePoint list. As of last week it started triggering this error.

 

Error: SharePoint List Output (3): Error while adding records: '', hexadecimal value 0x1A, is an invalid character.

 

When I looked at the 11 rows it was trying to add today and I added each one individually it worked fine. 

 

I am looking at the source data and there is no arrow character that I can see. 

 

Is there an easy way to remove that type of character from any of the fields at once? 

 

It tried using a multi-field formula like this but it didn't seem to work. 

 

REGEX_Replace([_CurrentField_],'_0x1a_', '')

 

 

1 REPLY 1
BrandonB
Alteryx
Alteryx

Just a thought, but could you try the UrlEncode() function on your strings before they are written out? This encodes a UTF-16 String as a web-legal URL which makes me think it might actually help with this issue as well. 

Labels
Top Solution Authors