Modifies properties or settings of a SharePoint list. Helps in dynamically adjusting list configurations.

Stored Procedure-Specific Information

The UpdateList stored procedure modifies the properties of an existing SharePoint list. You can update various list settings such as the title, description, and configuration options.

To update basic list properties, enter:

EXEC UpdateList List = 'Test List', Title = 'Updated List Title', Description = 'Updated description';

To update multiple list settings, enter:

EXEC UpdateList List = 'Test List', Description = 'Updated description', Direction = 'None', EnableAssignedToEmail = 'true', EnableAttachments = 'true', EnableModeration = 'true', EnableVersioning = 'false', Hidden = 'false', Ordered = 'true', Title = 'New List Title';

Input

Name	Type	Required	Description
List	String	True	The name or globally unique identifier (GUID) of the SharePoint list to be updated.
AllowMultiResponses	String	False	Set to 'true' to allow multiple responses to a survey list.
Description	String	False	A text description of the list, providing additional context or purpose.
Direction	String	False	Defines the text reading order for the list interface: 'LTR' for left-to-right, 'RTL' for right-to-left, or 'None' for no specific direction. The allowed values are LTR, RTL, None.
EnableAssignedToEmail	String	False	Set to 'true' to enable assigned-to email notifications for issue tracking lists.
EnableAttachments	String	False	Set to 'true' to allow items in the list to have attachments. This setting does not apply to document libraries.
EnableModeration	String	False	Set to 'true' to enable content approval for items in the list, requiring administrator review before they become visible.
EnableVersioning	String	False	Set to 'true' to enable version tracking for list items, allowing for historical changes and rollbacks.
Hidden	String	False	Set to 'true' to hide the list from user interfaces such as the Documents and Lists page, Quick Launch, and site content settings.
MultipleDataList	String	False	Set to 'true' to indicate that the list in a Meeting Workspace site contains data for multiple meeting instances.
Ordered	String	False	Set to 'true' to allow users to manually reorder items within the list using the Edit View page.
ShowUser	String	False	Set to 'true' to display user names in survey responses instead of keeping them anonymous.
Title	String	False	The display name of the list, which appears in SharePoint user interfaces.

Result Set Columns

Name	Type	Description
Success	Boolean	Indicates whether the operation was successful. Returns 'true' if the update was applied successfully, otherwise 'false'.