Skip to main content

Notifications

Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by 38

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!

  • Verified answer
    v-litu-msft Profile Picture
    v-litu-msft on at
    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.

  • Flowbginner Profile Picture
    Flowbginner 38 on at
    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).

  • v-litu-msft Profile Picture
    v-litu-msft on at
    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.

  • ChristianAbata Profile Picture
    ChristianAbata 8,947 on at
    Re: copy value from a non managed metadata column to a managed metadata column

    hi @Flowbginner maeby this could help you.Check for empty or null value ODATA filter Get items 4.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard