cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TestApp
Frequent Visitor

Power Automate Managed Metadata Column Label Returns Numbers Instead of Value

Hi.

I have a power automate workflow to get few column values of a document from a Library. And I have 3 managed metadata columns with values in Term Store. 

All I need is the the Label of those 3 term store columns. 

But when I run the flow, I only get the one column's label value. The other 2 columns are returning WssId in the Label field. Not the Actual Label. 

Here's the result from that Flow. 

TestApp_0-1629180941198.png

First two columns returns some WssId in the Label field instead of actual Label value. 

But the third columns returns the correct value. And this one column allows multiple values. (I assume it doesn't have anything to do with the issue with previous columns.)

 

Is this a bug or a new feature? I'm facing this for quite few months and couldn't find any solutions. 

But when I use a PowerShell script to get the column values I can able to get the actual Label values. 

 

I can't even find any alternative for this in the power automate workflow. 

 

4 REPLIES 4
NGUYENTHIHA
Frequent Visitor

Hi,

 

Any solutions for this,

 

I am also facing an issue with show label of managed metadata column in canvas app.

It shows number instead of label (even I don't know what is that number coming from).

 

Many thanks!

 

 

quetzal
Advocate I
Advocate I

Experiencing this also. It was actually pulling the text value fine initially, but has suddenly started pulling the numeric value instead despite it literally having the same expression in the field. I step back through the prior flow runs and see in the the raw input is the same in the two different flows but is somehow no longer pulling the term name but the number instead. 

z3019494
Helper I
Helper I

Same deal here but strangely, it's working fine on a standalone SharePoint site containing the Term Store, but the labels on a Team Site is not producing the intended result (e.g. the Label being identical to the WssId, is being pulled)

 

Site where it works (standalone SharePoint site)

z3019494_0-1648805152319.png

z3019494_1-1648805159465.png

 

z3019494_5-1648805289718.pngz3019494_6-1648805324934.png

 

 

Site where it doesnt (SharePoint site which is part of a Team)

 

z3019494_2-1648805199738.pngz3019494_3-1648805213316.png

z3019494_4-1648805241451.pngz3019494_7-1648805339319.png

 

z3019494
Helper I
Helper I

Urgh. Got it working by

  1. Deleting the columns
  2. Recreating the columns and linking to the term store again.

I suspect the reason why it was failing is that the list was created based on another list.

z3019494_0-1648807131287.png

 

Moral of the story:

If you're going to create a new list based on another list with Managed Metadata, delete the MM columns and re-link!

 

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Top Solution Authors
Users online (2,565)