Office Admin Explorer

Maximum number of rows fetched per request while populating a lookup in the SharePoint list control

Registry value
rowlimitforlookups
Group PolicyMaximum number of rows fetched per request while populating a lookup in the SharePoint list control
German versionDie maximale Anzahl der pro Anforderung abgerufenen Zeilen beim Auffüllen eines Lookups im SharePoint-Listensteuerelement
Intune settings catalogMaximum number of rows fetched per request while populating a lookup in the SharePoint list control (User)
ScopeUser · HKCU
ADMXoffice16.admx · L_MaximumNumberOfRows
Open in the interactive explorer+ Add to my collection

Group Policy path

User Configuration\Policies\Administrative Templates\Microsoft Office 2016\Server Settings\SharePoint Server
Benutzerkonfiguration\Richtlinien\Administrative Vorlagen\Microsoft Office 2016\Servereinstellungen\SharePoint Server

Registry

ValueData
HKCU\Software\policies\microsoft\office\16.0\list\settings
rowlimitforlookups0 = Default · 1 = 1 · 100 = 100 · 450 = 450 · 5000 = 5000

Not configured = the value does not exist – the application default applies and users may change the setting.

PowerShell

Check the current value (read-only)

# --- Settings ---
$root = 'HKCU:'   # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'

$key = "$root\Software\policies\microsoft\office\16.0\list\settings"
foreach ($name in @('rowlimitforlookups')) {
    try   { '{0} = {1}' -f $name, (Get-ItemPropertyValue -Path $key -Name $name -ErrorAction Stop) }
    catch { '{0}: not configured' -f $name }
}

Admin rights needed: HKCU\Software\Policies is read-only for standard users. An elevated session writes to the admin's own HKCU – to set it for another signed-in user, change $root to Registry::HKEY_USERS\<SID>.

Enable

# --- Settings ---
$root = 'HKCU:'   # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'

try {
    $key = "$root\Software\policies\microsoft\office\16.0\list\settings"
    if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
    New-ItemProperty -Path $key -Name 'rowlimitforlookups' -PropertyType DWord -Value 0 -Force -ErrorAction Stop | Out-Null   # options: 0 = Default, 1 = 1, 100 = 100, 450 = 450, 5000 = 5000
    'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }
Reset to Not configured
# --- Settings ---
$root = 'HKCU:'   # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'

$key = "$root\Software\policies\microsoft\office\16.0\list\settings"
Remove-ItemProperty -Path $key -Name 'rowlimitforlookups' -ErrorAction SilentlyContinue
'Policy values removed (Not configured).'

Intune (settings catalog)

Maximum number of rows fetched per request while populating a lookup in the SharePoint list control (User)

Settings catalog → Add settings → search for the name above.

Intune Settings Catalog Viewer ↗

Alternative: custom profile (OMA-URI)
OMA-URI
./User/Vendor/MSFT/Policy/Config/office16v2~Policy~L_MicrosoftOfficeSystem~L_ServerSettings~L_SharePointServer/L_MaximumNumberOfRows
Data typeString
Value<enabled/> · <disabled/>

This policy has options: add one <data id="…" value="…"/> per element after <enabled/>. The element IDs are in the ADMX file.

Cloud Policy

Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Maximum number of rows fetched per request while populating a lookup in the SharePoint list control. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.

Microsoft explanation

The maximum number of rows fetched per request while populating a lookup in the SharePoint list control. Based on a standalone server's recommended hardware configuration a good default would be about 5000. The limit helps improve the performance of the SharePoint list control and is a defense in depth measure to prevent loading the server.

Same category: Microsoft Office 2016 › Server Settings › SharePoint Server

All policies in this category · All 945 policies of office16.admx