Skip to main content

spo list view add

Adds a new view to a SharePoint list

Usage​

m365 spo list view add [options]

Options​

-u, --webUrl <webUrl>

URL of the site where the list is located.

--listId [listId]

ID of the list to which the view should be added. Specify either listId, listTitle, or listUrl but not multiple.

--listTitle [listTitle]

Title of the list to which the view should be added. Specify either listId, listTitle, or listUrl but not multiple.

--listUrl [listUrl]

Relative URL of the list to which the view should be added. Specify either listId, listTitle, or listUrl but not multiple.

--title <title>

Title of the view to be created for the list.

--type [type]

Type of the view. Possible values are: list, calendar, gallery, kanban. Defaults to list.

--fields [fields]

Comma-separated list of case-sensitive internal names of the fields to add to the view. Optional when type is set to calendar.

--viewQuery [viewQuery]

XML representation of the list query for the underlying view.

--calendarStartDateField [calendarStartDateField]

Internal name of the field that contains the start date of the calendar event. Required when type is set to calendar.

--calendarEndDateField [calendarEndDateField]

Internal name of the field that contains the end date of the calendar event. Required when type is set to calendar.

--calendarTitleField [calendarTitleField]

Internal name of the field that contains the title of the calendar event. Required when type is set to calendar.

--calendarSubTitleField [calendarSubTitleField]

Internal name of the field that contains the subtitle of the calendar event.

--calendarDefaultLayout [calendarDefaultLayout]

Default layout of the calendar view. Possible values are: month, week, workWeek, day. Defaults to month.

--kanbanBucketField [kanbanBucketField]

Internal name of the field that contains the bucket for the Kanban board view. Required when type is set to kanban.

--personal

View will be created as personal view, if specified.

--default

View will be set as default view, if specified.

--paged

View supports paging, if specified (recommended to use this).

--rowLimit [rowLimit]

Sets the number of items to display for the view. Default value is 30.

-h, --help [help]

Output usage information. Optionally, specify which section of command's help you want to see. Allowed values are options, examples, remarks, permissions, response, full. Default is options.

--query [query]

JMESPath query string. See http://jmespath.org/ for more information and examples.

-o, --output [output]

Output type. json, text, csv, md, none. Default json.

--verbose

Runs command with verbose logging.

--debug

Runs command with debug logging.

Remarks​

tip

We recommend using the paged option. When specified, the view supports displaying more items page by page (default behavior). When not specified, the rowLimit is absolute, and there is no link to see more items.

Examples​

Add a list view called to a list with specific title.

m365 spo list view add --webUrl https://contoso.sharepoint.com/sites/Sales --listTitle "Customers" --title "All customers" --fields "LinkTitle,Country,Sector,Country,Address,Contact" --paged

Add a gallery view as default view to a list with a specific URL.

m365 spo list view add --webUrl https://contoso.sharepoint.com/sites/Sales --listUrl "/Lists/Customers" --title "All customers" --type gallery --fields "LinkTitle,Country,Sector,Country,Address,Contact" --paged --default

Add a view with defined filter and sorting.

m365 spo list view add --webUrl https://contoso.sharepoint.com/sites/Sales --listTitle "Customers" --title "Transport customers" --fields "LinkTitle,Country,Country,Address,Contact" --viewQuery "<OrderBy><FieldRef Name='LinkTitle' Ascending='TRUE' /></OrderBy><Where><Eq><FieldRef Name='Sector' /><Value Type='Text'>Transportation</Value></Eq></Where>" --paged

Add a gallery view as personal view.

m365 spo list view add --webUrl https://contoso.sharepoint.com/sites/Sales --listTitle "Customers" --title "All customers" --type gallery --fields "LinkTitle,Country,Sector,Country,Address,Contact" --paged --personal

Add a calendar view with month layout.

m365 spo list view add --webUrl https://contoso.sharepoint.com/sites/Sales --listTitle "Events" --title "All events" --type calendar --fields "EventType,InternalExternal" --calendarStartDateField EventStartDate --calendarEndDateField EventEndDate --calendarTitleField LinkTitle --paged

Add a calendar view with week layout and subtitle.

m365 spo list view add --webUrl https://contoso.sharepoint.com/sites/Sales --listTitle "Events" --title "All events" --type calendar --fields "EventType,InternalExternal" --calendarStartDateField EventStartDate --calendarEndDateField EventEndDate --calendarTitleField LinkTitle --calendarSubTitleField Location --calendarDefaultLayout week --paged

Add a Kanban board view.

m365 spo list view add --webUrl https://contoso.sharepoint.com/sites/Sales --listTitle "Tasks" --title "All tasks" --type kanban --fields "Title,AssignedTo" --kanbanBucketField Status --paged

Response​

{
  "Aggregations": null,
  "AggregationsStatus": null,
  "AssociatedContentTypeId": null,
  "BaseViewId": null,
  "CalendarViewStyles": null,
  "ColumnWidth": null,
  "ContentTypeId": {
    "StringValue": "0x"
  },
  "CustomFormatter": null,
  "CustomOrder": null,
  "DefaultView": false,
  "DefaultViewForContentType": false,
  "EditorModified": false,
  "Formats": null,
  "GridLayout": null,
  "Hidden": false,
  "HtmlSchemaXml": "<View Type=\"HTML\" Url=\"/Lists/Test/All events.aspx\" Personal=\"FALSE\" DisplayName=\"All events\" DefaultView=\"FALSE\" Name=\"{3CD2E934-F482-4D4A-A9B8-A13B49B3D226}\"><ViewFields><FieldRef Name=\"Title\" /></ViewFields><Query><OrderBy><FieldRef Name=\"Created\" Ascending=\"FALSE\" /></OrderBy><Where><Eq><FieldRef Name=\"TextFieldName\" /><Value Type=\"Text\">Field value</Value></Eq></Where></Query><RowLimit Paged=\"TRUE\">30</RowLimit></View>",
  "Id": "3cd2e934-f482-4d4a-a9b8-a13b49b3d226",
  "ImageUrl": null,
  "IncludeRootFolder": false,
  "ViewJoins": null,
  "JSLink": null,
  "ListViewXml": "<View Type=\"HTML\" Url=\"/Lists/Test/All events.aspx\" Personal=\"FALSE\" DisplayName=\"All events\" DefaultView=\"FALSE\" Name=\"{3CD2E934-F482-4D4A-A9B8-A13B49B3D226}\" ><Query><OrderBy><FieldRef Name=\"Created\" Ascending=\"FALSE\" /></OrderBy><Where><Eq><FieldRef Name=\"TextFieldName\" /><Value Type=\"Text\">Field value</Value></Eq></Where></Query><ViewFields><FieldRef Name=\"Title\" /></ViewFields><RowLimit Paged=\"TRUE\">30</RowLimit><Toolbar Type=\"None\"/></View>",
  "Method": null,
  "MobileDefaultView": false,
  "MobileView": false,
  "ModerationType": null,
  "NewDocumentTemplates": null,
  "OrderedView": false,
  "Paged": true,
  "PersonalView": false,
  "ViewProjectedFields": null,
  "ViewQuery": "<OrderBy><FieldRef Name=\"Created\" Ascending=\"FALSE\" /></OrderBy><Where><Eq><FieldRef Name=\"TextFieldName\" /><Value Type=\"Text\">Field value</Value></Eq></Where>",
  "ReadOnlyView": false,
  "RequiresClientIntegration": false,
  "RowLimit": 30,
  "Scope": 0,
  "ServerRelativePath": {
    "DecodedUrl": "/Lists/Test/All events.aspx"
  },
  "ServerRelativeUrl": "/Lists/Test/All events.aspx",
  "StyleId": null,
  "TabularView": true,
  "Threaded": false,
  "Title": "All events",
  "Toolbar": null,
  "ToolbarTemplateName": null,
  "ViewType": "HTML",
  "ViewData": null,
  "ViewType2": null,
  "VisualizationInfo": null
}