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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Inconsistent Managed M...
Power Apps
Answered

Inconsistent Managed Metadata values in flow

(0) ShareShare
ReportReport
Posted on by 37

Hello,

 

I've created a flow that looks at a managed metadata column (can have multiple values) for a file in a library and does work based on whether the managed metadata contains certain values. I am using "Get Item" to see values for a file in a library.

 

You can see my terms in the attachment below. The terms are structured by a few companies, departments, content, etc. The highest level of the term is the company. The column is set to display the FULL PATH for each term, and works properly in the library. 

 

So here's the issue. My flow loops through each selected term in the column for a file. IF these terms have the same first node selected, the full path displays in the column information IN FLOW for each term value. However, if these terms have differing first nodes (companies in my case), only the final term in the path is shown. I have set the output to variables and sent to my email so I can see it. I'll share it below. These are two different cases, one where the first term matches for both, and one where the first term is different.

 

I believe the full path should be shown regardless - and that is actually pretty crucial for me and how I am trying to use this flow.

 

Here's the managed metadata values I'm getting:

 

Case 1:  Working correctly

Value1: Company A:Marketing Communications:Section 98 - Cross-Referenced Documents
Value2: Company A:Accounting:Section 60 - Semi-Annual

 

Case 2: Displaying only the last value of the term, not full path.

Value1: Section 00 - High Level Maps
Value2: Section 00 - Farrowing Overview

 

What case 2's full path should actually be is

Value 1: Company A:Quality Management:Section 00 - High Level Maps

Value 2: Company C:Farrowing:Section 00 - Farrowing Overview

 

I've masked our companies because that seems responsible...

 

If you'd like more information please let me know.

 

 
capture.png
Categories:
I have the same question (0)
  • jkibler Profile Picture
    37 on at

    Hmm, my initial thought of it having to do with whether the first node in managed metadata matched was false. I am unsure what causes the inconsistencies. I'm trying to figure it out, but regardless the issue still remains. Sometimes the full path shows, and sometimes it doesn't.

  • jkibler Profile Picture
    37 on at

    Taking my case that worked in the initial post, I added a third term to it and the full paths no longer showed for any of the three terms. I removed that third term and the full paths showed for the two terms left.

     

    Next, I switched the second term to a different term (with a shorter path because I suspected character length being a culprit). However, the full paths no longer showed.

     

    So, I take this case, switch it back to the original terms that displayed the full paths correctly. However, now the full paths don't display for the terms.

     

    I have no idea what is causing this. Something about how the column understands its multiple managed metadata values must have changed, even though the terms are now the same (and in the same order).

     

     

     

     

  • jkibler Profile Picture
    37 on at

    And just so I am clear (sorry if this has been unclear, read full post to understand what's going on), these full paths display JUST FINE in the document library in SharePoint.

     

    I am losing the full paths value in Flow for the Get Item function. I have tried multiple functions in flow as well, they're all reading the properties the same.

  • Verified answer
    jkibler Profile Picture
    37 on at

    I've finally found a solution that works for me here: https://powerusers.microsoft.com/t5/Using-Flows/Get-metadata-full-hierarchical-path-in-a-flow/m-p/187813/highlight/false#M4917

     

    You can use Get Item on the Taxonomy List by setting the URL to your site and the List to TaxonomyHiddenList, then send the WSSID for the term as the ID.

     

    Once you get this you can look at the Path property on the item to get the full path of the Term.

     

    It'd still be nice to see the inconsistency fixed, but I'm happy I have a solution and can actually use the flow I'm trying to implement.

     

    Cheers!

  • alrezac Profile Picture
    Microsoft Employee on at

    Hi,

     

    It looks like you were able to solve your issue from another communities post that you found here: https://powerusers.microsoft.com/t5/Using-Flows/Get-metadata-full-hierarchical-path-in-a-flow/m-p/187813/highlight/false#M4917

     

    You can find more information on list managed matadata here if you would like to learn more: https://docs.microsoft.com/en-us/sharepoint/managed-metadata

     

    Regards,

     

    Alex

     

    -------

     

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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard