Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

SharePoint List Output - Issue copying Managed Metadata columns

febinjs6
5 - Atom

We have a scenario to copy data from excel to SharePoint, which we are able to do successfully, except in case if we have a managed metadata column in SharePoint List. Do we need to keep a specific format for managed metadata column value in excel sheet while copying to SharePoint or Is there any way in Alteryx where we can  query sharepoint for the actual format ?

 

For example:- Lookup Columns we will have format like "LookupID;#LookupValue"

 

Currently whenever am trying to copy a Managed Metadata Column am getting below error message?

 

Capture.PNG

2 REPLIES 2
HossC
Alteryx Alumni (Retired)

Hello @febinjs6,

 

We are aware of this issue with managed metadata columns in SharePoint, and as of this post, the SharePoint List tools are unable to process managed metadata columns.

Hoss Carroll
Customer Support Engineer
Alteryx
febinjs6
5 - Atom

Thankyou @HossC

Labels