Get Object.Label of Managed Metadata

[LegendaryB]

Hey,

I feel like a guest who comes back every week. So sorry about it xD

When I use this approach (item is IListItem):

if (item.Properties.Values.TryGetValue(propertyName, out var value))
    document.Properties.Add(propertyName, value);

I get this value for a managed metadata property: 1;#Foo|b7044609-0f6a-4105-9721-76feec6416d4
But I'm interested in FieldValue.Label. Any way to get that?

[jansenbe]

@LegendaryB , when reading the list holding the items I assume you've also loaded the list fields as mentioned here https://pnp.github.io/pnpcore/using-the-sdk/listitems-intro.html#reading-list-items? If so then a managed metadata field should be represented by an IFieldTaxonomyValue or an IFieldValueCollection of IFieldTaxonomyValue for multi taxonomy fields. Which should give you the taxonomy label and id (https://pnp.github.io/pnpcore/api/PnP.Core.Model.SharePoint.IFieldTaxonomyValue.html).

Now you can also simply split the string yourselves (label = Foo, Id = b704...)...

[jansenbe]

These complex properties are loaded based upon the available information returned from the request + the availability of the list field information (which was not in your code). So add a QueryProperties to your list loading like shown below.

var lists = context.Web.Lists
                        .QueryProperties(
                            p => p.Title,
                            // Add other list fields you need
                            //..
                            p => p.Fields.QueryProperties(p => p.InternalName,
                                                                   p => p.FieldTypeKind,
                                                                   p => p.TypeAsString,
                                                                   p => p.Title))
                        .Where(
                            l => l.TemplateType == ListTemplateType.DocumentLibrary &&
                            l.Hidden == false &&
                            l.IsSystemList == false &&
                            l.IsSiteAssetsLibrary == false &&
                            l.IsCatalog == false);

await foreach (var list in lists.AsAsyncEnumerable())
{
    var itemsEnumerable = list.Items
         .QueryProperties(
             p => p.All,
             p => p.UniqueId,
             p => p.Properties,
             p => p.FileSystemObjectType,
             p => p.File)
         .AsAsyncEnumerable();

    await foreach (var item in itemsEnumerable)
    {
        

        // further processing...
    }
}

Since SharePoint, in case of a user, only returns the id of the user for the current site that's the only thing that get's loaded up. You can't automatically get more user data via adding additional QueryProperties, you'll need to load that separately if you need that.

@LegendaryB : just noticed that the Field property is null here, checking that...

[LegendaryB]

Thank you for checking. Looks the same on my side 👍

[jansenbe]

@LegendaryB : The fact that the field property is null is something we should fix, but it will not impact your scenario.

There's 2 ways to get SharePoint ListItem data, using the "regular" get approach you're using or using a CAML query (see #586 (comment)). Both have pro's and con's:

Option	Pro	Con
Regular approach	Can load Properties in one go	Most system list item properties are not returned
CAML query models	All properties returned, more detail for some properties (like user's)	Loading Properties will require a separate call per list item, so really expensive

As you only need custom added metadata and you need the file's Properties the regular approach seems to be the best for you, so the code shown in the previous reply.

[LegendaryB]

@jansenbe
Yeah I also guess that this would be the best solution for my scenario. But then I need to do manual splitting right? Because a user object is then something like: 1#Name
But should be okay I guess. Needs then a little bit more testing but yeah :D

[jansenbe]

Maybe also let's mark this one as answered :-)