Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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