web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : VYmwqX8x5+JEEKzt6jyyS1
Power Automate - Building Flows
Answered

SharePoint Update Item Action : Managed Metadata Columns only returning single term

Like (0) ShareShare
ReportReport
Posted on 6 Jan 2020 14:07:40 by 63

Hi,

 

I have a flow that is used to collect attachments from a list and copy them to a document library along with all the relevant column data values. There are two managed metadata columns that I need to update the values for, but am only seemingly able to pass the last value to each column - How do I configure to update ALL managed metadata terms from one to another?

 

Tags.png

  • AsheerHasan Profile Picture
    93 on 14 Jul 2022 at 06:39:56
    Re: SharePoint Update Item Action : Managed Metadata Columns only returning single term

    Hi,

     

    I have followed all the steps bus still it's storing the last selected managed meta data values in the library. Please assist.

  • Mello Profile Picture
    2 on 24 Mar 2021 at 18:30:37
    Re: SharePoint Update Item Action : Managed Metadata Columns only returning single term

    When I update the list item I get the following error: "The data returned from the tagging UI was not formatted correctly"

    I assume that's because the value in my array needs to include the term GUID.
    So instead of sending: [ { "Value": "Equipment" } ]
    I need to send: [ { "Value": "Equipment|172509b8-b3d5-434f-8121-5262d382a56f" } ]

    How do I get the GUID for the term?

    Using the "TaxonomyHiddenList" is not an option because not all terms will be used before being assigned.

     

  • MP4249 Profile Picture
    63 on 08 Jan 2020 at 10:15:09
    Re: SharePoint Update Item Action : Managed Metadata Columns only returning single term

    Hi,

     

    Thanks I got this working by using a variable as advised.

    However there is no need for the Append variable action as simply storing the value in a variable works fine.

     

    Thanks

  • Verified answer
    v-bacao-msft Profile Picture
    on 08 Jan 2020 at 09:05:43
    Re: SharePoint Update Item Action : Managed Metadata Columns only returning single term

     

    Hi @MP4249 ,

     

    This problem occurs because you set the field to allow multiple selections.

     

    You can refer to the following method to update the two fields, for example, to update the Tags field. You can follow a similar method for the other field.

    • Initialize the array variable to store the Tags value contained in the item, traverse the Tags and append the value to the variable in the specified format.
    • Finally, update the file property with variables. The point is to append the value of the managed metadata field in the item to a variable to use.

    Image reference:

    257.PNG258.PNG

     

    Best Regards,

  • MP4249 Profile Picture
    63 on 07 Jan 2020 at 09:45:43
    Re: SharePoint Update Item Action : Managed Metadata Columns only returning single term

    @v-bacao-msft 

     

    Hi,

     

    The problem is that it only returns a single metadata term - not all that are present in the list.

    The 'Create File' related actions are within an 'Apply to each' action and works as expected for all other file properties:

     

    1.png

     

    However, when I try to add the Managed Metadata column values, it further automatically wraps each output in a further 'Apply to each' action which I believe is causing the problem:

     

    2.png

    Hope this provides enough information for you to help advise how this should this be configured.

     

    Many thanks,

    Mike

  • v-bacao-msft Profile Picture
    on 07 Jan 2020 at 02:29:27
    Re: SharePoint Update Item Action : Managed Metadata Columns only returning single term

     

    Hi @MP4249 ,

     

    I'm afraid I don't quite understand what your problem is. Could you provide more details?

     

    If you fill in Value, then it should be updated correctly.

     

    Best Regards,

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete