topic Re: Sharepoint Output Tool - Choice Columns in Alteryx Designer Desktop Discussions

Sharepoint Output Tool - Choice Columns

Alexander_Wang — Fri, 07 May 2021 17:44:07 GMT

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.

Re: Sharepoint Output Tool - Choice Columns

Sethmb — Fri, 21 May 2021 17:07:30 GMT

Hello Alexander,

When you say site wide choice column, is this column coming from another list or part of sharepoint and combined into the list you are updating through a view? I am able to modify and upload and download choice columns. Is there a certain error or anything that is being returned?

Thanks,

Seth | Alteryx Sr. CSE

Re: Sharepoint Output Tool - Choice Columns

Alexander_Wang — Mon, 24 May 2021 20:33:24 GMT

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.

Re: Sharepoint Output Tool - Choice Columns

kgen — Sun, 18 Aug 2024 04:16:07 GMT

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.

Re: Sharepoint Output Tool - Choice Columns

kmchundi — Fri, 23 Jan 2026 20:22:04 GMT

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