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?
Solved! Go to Solution.
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.
Thankyou @HossC