Answered

copy value from a non managed metadata column to a managed metadata column

(0) Share

Report

Posted on by Flowbginner

I have a SharePoint list with 30k+ items.

One column contains strings, this is a non managed metadata column. Goal is to copy these items to (the currently empty) managed metadata column.

How should this be accomplished?

Thanks for your feedback!

I have the same question (0)

All responses (4)

Answers (1)

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: copy value from a non managed metadata column to a managed metadata column

hi @Flowbginner maeby this could help you.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Re: copy value from a non managed metadata column to a managed metadata column

Hi @Flowbginner,

Could you give us more information about your desire, please?

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Flowbginner 38 on at

Like (0)

Report

Re: copy value from a non managed metadata column to a managed metadata column

We always used normal choice columns to manage a set values. This becomes unmanagable in a list of 30K+ items because when a value changes we manually need to update all those values in the list. Now we migrated these values into a managed metadata term store. My question is how can we easily update all the values from column A (choice column) to column B (managed metadata column).

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Re: copy value from a non managed metadata column to a managed metadata column

Hi @Flowbginner,

Update managed metadata column should get the value and GUID, format should be value|GUID, please refer to this post:

https://powerusers.microsoft.com/t5/General-Power-Automate/Update-SharePoint-Managed-Metadata-Column-using-string/m-p/367259

This is a blog about it:

https://joannecklein.com/2018/02/19/microsoft-flow-update-sharepoint-columns/

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No