Maximum number of rows fetched per request while populating a lookup in the SharePoint list control: registry value rowlimitforlookupsUserHKCU\software\policies\microsoft\office\16.0\list\settings

Policy ID: L_MaximumNumberOfRows
Scope: User Configuration
Supported on: At least Windows Server 2008 R2 or Windows 7
Source: Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
Category: Microsoft Office 2016 › Server Settings › SharePoint Server

Registry

rowlimitforlookups

REG_DWORDUser

HKCU\software\policies\microsoft\office\16.0\list\settings Current key

Enabled value: Depends on the option value
Element: -

Options
Item	Stored value
Default	0
1	1
100	100
450	450
5000	5000

Apply with .reg · CMD · PowerShell

.reg

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\list\settings]

; Options (use only one)
; Default
"rowlimitforlookups"=dword:00000000
; 1
"rowlimitforlookups"=dword:00000001
; 100
"rowlimitforlookups"=dword:00000064
; 450
"rowlimitforlookups"=dword:000001c2
; 5000
"rowlimitforlookups"=dword:00001388

CMD

:: Options (use only one)

:: Default
reg add "HKCU\software\policies\microsoft\office\16.0\list\settings" /v "rowlimitforlookups" /t REG_DWORD /d 0 /f
:: 1
reg add "HKCU\software\policies\microsoft\office\16.0\list\settings" /v "rowlimitforlookups" /t REG_DWORD /d 1 /f
:: 100
reg add "HKCU\software\policies\microsoft\office\16.0\list\settings" /v "rowlimitforlookups" /t REG_DWORD /d 100 /f
:: 450
reg add "HKCU\software\policies\microsoft\office\16.0\list\settings" /v "rowlimitforlookups" /t REG_DWORD /d 450 /f
:: 5000
reg add "HKCU\software\policies\microsoft\office\16.0\list\settings" /v "rowlimitforlookups" /t REG_DWORD /d 5000 /f

PowerShell

# Common: create the key
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\list\settings' -Force | Out-Null

# Options (use only one)
# Default
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\list\settings' -Name 'rowlimitforlookups' -PropertyType DWord -Value 0 -Force | Out-Null
# 1
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\list\settings' -Name 'rowlimitforlookups' -PropertyType DWord -Value 1 -Force | Out-Null
# 100
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\list\settings' -Name 'rowlimitforlookups' -PropertyType DWord -Value 100 -Force | Out-Null
# 450
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\list\settings' -Name 'rowlimitforlookups' -PropertyType DWord -Value 450 -Force | Out-Null
# 5000
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\list\settings' -Name 'rowlimitforlookups' -PropertyType DWord -Value 5000 -Force | Out-Null