Is it possibly to copy/migrate values into a managed metadata column? Everything I'm reading either pertains to SharePoint OnPrem, or copying/migrating taxonomy (groups and sets) - neither of which apply.

I have a choice column that contains values. We've since begun to use the Term Store. Now that I've created a managed metadata column pointing to the appropriate term set, how can I move existing values from the previous column to this new managed metadata column?

This won't be a one-time-only task. We have numerous opportunities to begin using the Term Store, if I can copy existing values to the new columns.

Thank you!

  • Did you ever figure out a solution? I'm considering doing the same but when I try and copy across a Single or Multi selection from a Choice column to a Managed Metadata column in Grid view in a Document Library, I get error: The data returned from the tagging UI was not formatted correctly. Also, just for reference, I notice when I export these document libraries from SharePoint online - Choice column outputs values like Option01;#Option02 whereas Managed Metadata column outputs values like 47;#Option01;#48;#Option02. I have not yet figured out what the numbers represent. Commented Jun 12, 2021 at 8:45
  • For reference, seems there are existing answers here and here - but i don't have PowerShell access where I am. Commented Jun 12, 2021 at 8:49


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.