Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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