Introduction
This article is the 33rd part of my SharePoint series. Here are my previous articles.
- Learn SharePoint In Series - Part One - Introduction
- Learn SharePoint In Series - Part Two - Web Application
- Learn SharePoint In Series - Part Three - Site Collections
- Learn SharePoint In Series - Part Four - Subsites
- Learn SharePoint In Series – Part Five – SharePoint Lists
- Learn SharePoint In Series - Part Six - Power Of Versioning
- Learn SharePoint In Series - Part Seven - Lists Advanced Settings
- Learn SharePoint In Series - Part Eight - Validation Settings in List Settings
- Learn SharePoint In Series - Part Nine - Audience Targeting
- Learn SharePoint In Series - Part Ten - Rating Settings
- Learn SharePoint In Series - Part Eleven - Form Settings in List Settings
- Learn SharePoint In Series - Part Twelve- Save list as a template in List Setting
- Learn SharePoint In Series - Part Thirteen- Permission Settings in List Settings
- Learn SharePoint In Series - Part Fourteen- Enterprise Metadata and Keywords
- Learn SharePoint In Series - Part Fifteen - Retention Policy Under Information Management
- Learn SharePoint In Series - Part Sixteen - RSS Settings in List Setting
- Learn SharePoint In Series - Part Seventeen - List Columns in SharePoint
- Learn SharePoint In Series - Part Eighteen - Multiple Lines Of Text Column Type in SharePoint
- Learn SharePoint In Series - Part Nineteen - Number and Choice Column Type in SharePoint
- Learn SharePoint In Series - Part Twenty - Currency and Yes No Column types in SharePoint
- Learn SharePoint In Series - Part Twenty One - Person or Group Column types in SharePoint
- Learn SharePoint In Series - Part Twenty-Two - Date and Time Column types in SharePoint
- Learn SharePoint In Series – Part Twenty-Three – Look Up Column Type in SharePoint
- Learn SharePoint In Series - Part Twenty Four - Hyperlink or Picture Column Types in SharePoint
- Learn SharePoint In Series -Part Twenty-Five - Calculated Column in SharePoint
- Learn SharePoint In Series - Part Twenty-Six - Task Outcomes and External Data Column Type in SharePoint
- Learn SharePoint In Series - Part Twenty-Seven - Introduction to Managed Metadata Column Types
- Learn SharePoint In Series - Part Twenty-Eight - Introduction to Site Columns
- Learn SharePoint In Series - Part Twenty Nine - Editing and Deleting Site Columns
- Learn SharePoint In Series - Part Thirty - Column Reordering in SharePoint
- Learn SharePoint In Series - Part Thirty-One - Indexing in SharePoint Lists and Libraries
- Learn SharePoint In Series - Part Thirty Two - Introduction to SharePoint Views
In the previous article, I have given a brief introduction to SharePoint list views. We have seen what views are and what is the use of the SharePoint list views. In this article, I will be explaining how to create the SharePoint List Views in a list and how to configure them. In this article, I am going to cover the following topics.
- Scenario
- Creation of SharePoint View
- Summary
Scenario
Consider a scenario where you have the following Shopping List. Please refer to the image below that contains several records.
Now, your requirement is to create a view in which you don’t want to include “Notes” columns and the item should be displayed in the descending order of item last modified. So let’s understand how to create a view for this scenario.
Creation of SharePoint List View
In order to create the view please follow the below steps.
Step 1
Open the list in which you want to create a view, then open the list setting page by clicking on the Setting icon and then clicking on List Settings.
Step 2
Scroll down and navigate to the Views section of the list settings page. Once you navigate to the Views section, you will find an option to Create View.
Step 3
Click on the link and you will be navigated to View Type. Here are all the possible Views to be created with the current list.
Step 4
In this article, we will be creating a Standard View, I will be explaining other view types in upcoming articles. From the View Type click on Standard View or also you can select any existing view type to create a new view as shown in the below figure.
Step 5
When we click on Standard View, Create View page will be opened. Here you have to configure your required view. Let’s understand each property and its use here.
Name
Name property is used to give a meaningful name to your new view. You can always give any name to the view. Along with the name you will have a checkbox “Make this the default view” if you want this view to be the default view that user must see when they open the list, then please check this checkbox. Otherwise leave it unchecked.
Audience
Audience property is used to define the audience of the view. There are 2 values here, one is “Create a Personal View” and other is “Create a Public View”. If you want to create a view that only you can see then select “Create a Personal View” and if you want to create a view for every user then select “Create a Public View”. By default “Create a Public View” is selected.
Columns
This property will allow configuring the columns and columns order that you want to display into your views. Just select the checkbox before the name of the columns under “Display” that you want to select. Here we do not need the Notes columns, then deselect the checkbox before the Notes column name.
Now from the option “Position from Left”, you can select the order of the columns that should be displayed in the views. When you will select the order of any columns then the order of other columns will be automatically adjusted.
Sort
This option allows us to configure the sorting order of the list item. Here we have to display the item on Modified Date in descending order. So select the Modified columns into the drop-down and then click on “Sort items in descending order” radio button. Here you can configure level 2 sorting.
Filter
If you do not want to display all the records and you are interested in viewing the items that are created today, then you can configure such a condition here. In this case, I have checked the radio button of ‘Show items only when the following is true” and I have selected the column “Created” and the condition is “is equal to” and the value is ‘[Today]”. Here you can configure multiple conditions in the views.
Tabular View
When you open any list you have the checkbox with each and every item. If you do not want to display the individual checkbox with the item then just uncheck this checkbox and you will then observe that the individual checkbox will disappear.
Group By
This section will be used to configure the grouping on the list items. Here you can group by the items based on the given columns. For example, if you want to group the list item by Title then, in that case, select the column “Title” and select the sort order.
From here you can also configure how many groups should be displayed into the page or the default behavior should be Collapsed or Expanded. Let’s selected Expanded.
Totals
This will allow the user to configure to display the Sum, Count, Average etc of the selected visible columns. For this example, I have selected the Sum of Price and Sum of Quantity columns.
Style
This option will allow the user to configure the look and feel of the tabular data. You can select any view and check the view on the page. Here we are selecting Default display.
Folders
Sometimes we have folders inside the list and every folder has the items. Now sometime user wants to display all the items from the folders to the single view. If you want to display all the items without folders then you can select “Show all items without folders” or else leave the default selection that is “Show items inside folders”.
Item Limit
As the name depicts, this setting is used to set the item limit to be displayed on the list view page. By default, the value is 30, but you can change it according to your needs. Along with the free textbox you have the following 2 options.
“Display items in batches of the specified size” and “Limit the total number of items returned to the specified amount”. If you want to fetch all items at a time and then allow the user to fetch the next items using Next button then select “Display items in batched of the specified size”. This approach will take a little longer while loading the data for the first time, as it will load all the data for the first time and then pagination will be managed. While if you want to fetch the fixed amount at a time then, in that case, you can select “Limit the total number of items returned to the specified amount” option. This option will be a little bit faster as this will not fetch all the items for the first time, it will fetch the items on demand and then display it to the views.
Mobile
As the name suggests this setting will be used to configure whether this view should be available with the mobile view or not.
Once you are done with the configurations, just click on the OK button and your view will be created.
Following will be the view created.
Here you can see that the item is grouped by Title columns, and we have only 2 items. Because we have selected items to be displayed that are created today, the third item is not displayed. The name of the view is “New View”.
We have also selected the options to display the sum of the Price and Quantity columns. But the modern layout does not support that sum option. So let’s switch to the “Classic View” and then you will see the following layout.
Here you can see the sum of the Price and Quantity columns with grouped columns.
Summary
So in this article, we have seen how I have created a simple view. There will be N number of scenarios where you can configure your view. If you have any query then just let me know in the comment section also, if you want to configure your views for a specific requirement then also let me know into the comment section and I will guide you to create your scenario-based view.
The same concept belongs to SharePoint libraries also. In the next article, I will be explaining how to edit the views and how to select the views to be displayed as default or how to switch between the views.