Lists
Retrieves metadata about all SharePoint lists available on the site, including properties and settings. Useful for understanding the structure and usage of SharePoint lists.
View Specific Information
Lists can be used to list the tables in SharePoint. This will only return actual lists in SharePoint and not any special tables associated with the component.
The following columns can be used in the WHERE clause: Title and BaseTemplate.
Columns
| Name | Type | Description |
| ID [KEY] | String | A unique identifier for the SharePoint list. Useful for referencing lists in queries and workflows. |
| Title | String | The display name of the list. Can be used in the WHERE clause with wildcard (*) for filtering. |
| Description | String | A brief summary of the list’s purpose and contents. Helps users understand the list's function. |
| BaseTemplate | String | Indicates the template type used to create the list. Can be used in WHERE clause for filtering list types. |
| Version | Double | The current version number of the list. Useful for tracking updates and changes. |
| Url | String | The default URL of the list. Helps users navigate to the list directly. |
| EmailAlias | String | The email alias assigned to the list. Useful for enabling email-based list interactions. |
| ImageUrl | String | The URL of the image associated with the list. Helps visually identify lists. |
| ItemCount | Integer | The total number of items currently stored in the list. Useful for reporting and analytics. |
| Item_Deleted | Datetime | The date and time when the last item was deleted from the list. Helps track data modifications. |
| Item_Modified | Datetime | The date and time when the last item was modified in the list. Useful for monitoring recent activity. |
| SendToUrl | String | The URL where list items are sent when using Send To functionality. Useful for document routing. |
| Created | Datetime | The date and time when the list was originally created. Useful for tracking list history. |
| AllowDeletion | String | Indicates whether items in the list can be deleted. Helps manage data retention policies. |
| AllowMultiResponses | Boolean | Indicates whether multiple responses are allowed for surveys. Useful for feedback collection. |
| Direction | String | Specifies text reading order: 'LTR' for left-to-right, 'RTL' for right-to-left, or 'None' for no directionality. |
| EnableAssignedToEmail | Boolean | Indicates whether automatic email notifications are sent to assigned users. Applicable to issue tracking lists. |
| EnableAttachments | Boolean | Indicates whether attachments are allowed on list items. Not applicable to document libraries. |
| EnableModeration | Boolean | Indicates whether content approval is enabled for the list. Helps enforce content review policies. |
| EnableVersioning | Boolean | Indicates whether versioning is enabled for the list. Useful for tracking changes to list items. |
| Hidden | Boolean | Indicates whether the list is hidden from the Documents and Lists page, Quick Launch bar, and other navigation menus. |
| MultipleDataList | Boolean | Indicates whether a meeting workspace site contains data for multiple meeting instances within the site. |
| Ordered | Boolean | Indicates whether list items can be manually ordered on the Edit View page. Useful for prioritized lists. |
| Showuser | Boolean | Indicates whether user names are displayed in survey results. Helps identify respondents. |