Specifies whether the provider includes display value columns for lookup fields in query results when using the REST schema.

Syntax

Connect-SharePoint -IncludeLookupDisplayValueColumns SwitchParameter

Data Type

bool

Default Value

false

Remarks

In the REST schema, lookup columns by default return only the record identifiers that reference data from other lists. For example:

MultiLookUpColumn=1, 2

When IncludeLookupDisplayValueColumns is set to true, the cmdlet includes an additional column for each lookup field with a _DisplayValue suffix. This column shows the human-readable values associated with each lookup ID. For example:

MultiLookUpColumn = 1, 2  
MultiLookUpColumn_DisplayValue = United States, United Kingdom

This property is useful for making query results more readable and eliminating the need to perform manual lookups to resolve IDs to display values.

Performance Considerations

Including display value columns increases server processing time and resource usage, as additional data must be retrieved for each lookup field. This can slow query execution and impact performance, especially when working with large lists or multiple lookup columns. Leaving this property disabled reduces query overhead.