Determines whether the display values for lookup columns should be included. This property applies only to the REST schema.

Syntax

Connect-SharePoint -IncludeLookupDisplayValueColumns SwitchParameter

Data Type

bool

Default Value

false

Remarks

For the REST schema, the driver will by default push the record identifiers from which a list lookup column retrieves the data from. For example:

MultiLookUpColumn=1, 2

When this property is enabled (true), an additional column (name is suffixed with _DisplayValue) for each lookup column will be listed during metadata retrieval, from which the actual data of the looked-up column can be queried. For example:

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

Note that enabling this connection property will likely result in worse performance, because the server will need more time and resources to retrieve the values of the look up columns.