Sharepoint Output Tool - Choice Columns

Question

Is there currently any workaround for uploading data into a sharepoint list that utilizes site wide choice columns? I believe elsewhere, it was noted that Alteryx has issues with updating lists that include said choice columns. Additionally, changing these choice columns to another metadata type would not be a solution I can use currently.

kmchundi · Answer

Can you pl. share details if this issue had been fixed.

I have a workflow updating values in the SharePoint using SharePoint output tool. When I am trying to update the SP field of Choice Type I am getting this error

Error: SharePoint Output (59): API response: {'lang': 'en-US', 'value': "An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected."}

Any suggestions?

Thanks

Krishna

Alteryx_workflowError_Screenshot.jpg

kgen · Answer

Hey Alexander,

I saw this post. Could you provide details of your workflow that updates a list with choice columns? Though my workflow runs successfully, my sharepoint doesn’t appear as expected and choice columns will show as blank as if no one selected one of the options.

Alexander_Wang · Answer

Hi Seth,

By site-wide choice column, I mean a choice column created at the site level. You can also create choice columns at the list level, but through my testing, writing into lists utilizing the "list level" choice columns isn't an issue. The error message I get if I try to write directly into the list is as screenshotted below. Additionally downloading from sharepoint is not an issue either and my only issue occurs with writing back into sharepoint. I've also made sure the upload matches the lists columns and metadata.