Unanswered

Numeric value in managed metadata field instead of text

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am looking to build this gallery on Power Apps for selecting people from a SharePoint directory. However, I am having trouble with showing the correct Function and Location information. As the image shows, it is presenting numeric values. These columns on the SharePoint are referenced to managed metadata.

The term store for location looks like this: (there are no numbers... just words corresponding to continents, regions, countries, etc).

On this example, the location field should say Asia instead of 1694.

Can someone tell me what this value represents and how can I fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Sarita Suryawanshi 74 on at

Like
a
(0)

Report
Copy link

Link copied!

The numeric values you are seeing in the Location field likely represent the unique identifiers (IDs) of the managed metadata terms stored in SharePoint, rather than the actual names of the terms themselves.
To display the actual names of the managed metadata terms (such as "Asia" instead of "1694"), you need to perform a lookup operation to retrieve the corresponding term names based on the IDs stored in your SharePoint list.

Without knowing the exact structure of your Power Apps app and the SharePoint data source, it's a bit challenging to provide specific code snippets. However, you can follow these general steps to achieve the desired outcome.
1. Retrieve Term Names from Managed Metadata
2. Replace Numeric IDs with Term Names
3. Display Term Names in the Gallery

If my response helped resolving your issue, kindly click on "Accept as Solution." This helps others easily locate the solution and also marks the question as resolved. If you found the information beneficial for other reasons, please give it a Thumbs Up. Thank you!

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Click the value in the location part of the form. It's probably set to ThisItem.Location.wssid or something, needs to be Thisitem.Location.Label instead. Kind of odd looking setup for a Metadata column, but if you share what your DataField is for that assuming it's a form, or what's in Default / Text might shed a little light.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is what I have as Data Field:

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

weird. What is your items in the gallery? Like if you look at the Filter, and see location etc. in the raw data, is it returning a record?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

On Items I have: Filter(DataSource,tbSearchInput.Text in Location.Label)
So if I put 1694 in my search bar, it will show me people with that location ID. But if I enter Asia, it shows me nothing.

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah but if you click on Filter and you see the drop down underneath where you can look at the records returned. What shows for Location in there? Almost seems like your Location field in the datasource isn't the right name for your managed metadata. Also need to check your datasource list settings there and see what it's showing. It should just be the name, I've never seen a random number show up for a metadata column for a label.

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Also if you haven't save the app and close it and reopen it, maybe it mapped the schema weird, and restarting will redo that. Worth a shot if you haven't done it yet. Have had weird issues like that happen before.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, already tried that.

If I enter directly on Items: Filter(DataSource,"Asia" in Location.Label), the dropdown beneath filter displays a "We didn't find any data" message. If I put Filter(DataSource,"1694" in Location.Label), then a couple of results show beneath.

The Location column on SharePoint is configured like this:

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

What if you just put the datasource in, remove the filter? Is it all numbers? The Filter should be more like Filter(Datasource, Location.Label = "Asia") or SearchByColumns(Datasource,"Location",tbSearchInput.Text) might be Location.Label but anyway, try without the Filter, just use the datasource raw and go from there, then worry about the search part. Curious if it changes the Label at all.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

The issue was with the SharePoint. A migration with the Term store from site to global might have messed with the SharePoint list references. Got fixed by assigning again the location tags directly on the SharePoint.

Thanks for the help!

Was this reply helpful? Yes No