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?
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.