Free Trial

Alteryx Designer Desktop Discussions

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

SharePoint Output Tool v2.2.0 - Writing Data to List Column of Numeric Data Type

jdwaterman91
5 - Atom

Hello,

I am attempting to write data to an existing SharePoint list using the "Append" function in v2.2.0 of the SharePoint Output tool.  

Below is an error I receive when one of my SharePoint list columns is selected as a "Numeric" data type.  I have tried setting my data type in Alteryx to "Double", "Fixed Decimal", and "V_W String" and receive the same error every time:  "data type 'np.float64' not understood".  

I do not receive this error if I change the data type on the SharePoint list column to "Currency" or "Single line of text".  

My primary question here is how do you write to a numeric SharePoint list column utilizing v2.2.0 of the SharePoint Output tool?

 

jdwaterman91_0-1679944664328.png

 

1 REPLY 1
FrederikE
13 - Pulsar

Hey @jdwaterman91,

 

Sadly v.2.2 of the Sharepoint Input seems to be full of bugs.I'd recommend to change the version of the tool. 

For me 2.1 worked fine - 2.3 and 2.4 are ofc hopefully better aswell. 

Labels
Top Solution Authors