Maximum number of rows fetched per request while populating a lookup in the SharePoint list control
| Registry value | rowlimitforlookups |
| Group Policy | Maximum number of rows fetched per request while populating a lookup in the SharePoint list control |
| German version | Die maximale Anzahl der pro Anforderung abgerufenen Zeilen beim Auffüllen eines Lookups im SharePoint-Listensteuerelement |
| Intune settings catalog | Maximum number of rows fetched per request while populating a lookup in the SharePoint list control (User) |
| Scope | User · HKCU |
| ADMX | office16.admx · L_MaximumNumberOfRows |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\list\settings | |
| rowlimitforlookups | 0 = 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 type | String |
| 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
- Maximum number of items to scan from today to determine the user's colleagues for recommendationmaximumitemstoscan
- Maximum number of days to scan from today to determine the user's colleagues for recommendationmaximumdaystoscan
- Maximum number of recipients in an Outlook item to scan to determine the user's colleagues for recommendationmaximumreceipientsperitem
- Enable Colleague Import Outlook Add-in to work with Microsoft SharePoint Serverenabled
- Minimum time before starting Colleague recommendation scanminimumidletime
- Minimum time to wait before rescanning the Outlook mailbox for new colleague recommendationsminimumstaletime
All policies in this category · All 945 policies of office16.admx