Managed Metadata Column, Term Label Returns Some ID Instead of Actual String Value

Murphybp2 

I have had a similar issue, when i am running Power Automate, Flow using the SharePoint, Get List Item, to return metadata value, labels.

the output returns the metadata ID, not the label that was requested.

This does not works on some lists and other are fine, they return the label.

After testing, lists that have been created using the 'From existing list' option,

create lists with Content Types, that are local to the list, (there parent is the Item)

Where as the lists that are working as expected, have been created manually with the Site Column and the Content Type being set up first, in the site, then added to a new list. This give you a parent Content Type in the site content type list

Note: Doing this manually or using PowerShell to the the list up both create list that does not have the metadata issues with Power Automate flows.

To resolve this I have rebuilt my problematic lists setting up the Content Type first manually (or with PowerShell) adding them to my new list and migrated the data.

Note: I create list like this ordinarily, but i notices this when you let the users lose with list creation, and they turn in to a 'Critical System' that needs some automation applied.

anyway, hope this helps.