Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors