In this SharePoint tutorial, We will discuss what is SharePoint list. Also, We will cover these below topics as:
- What is List in SharePoint
- Out Of Box List Templates
- SharePoint List Limitations
- Create a list in SharePoint Online (Announcement List)
- Create a Custom List in SharePoint Online
- Add columns in the list
- Insert/Update/Delete Items
- Edit name of a SharePoint list
- How many columns can you have in a SharePoint list
- How to hide a column in SharePoint
- How to Hide multiple columns in SharePoint
- How to delete a column from SharePoint list
SharePoint Tutorial Contents
- What is SharePoint List
- Out Of Box List Templates
- SharePoint List Limitations
- Create a list in SharePoint Online (Announcement List)
- Create a Custom List in SharePoint Online
- Add columns to SharePoint list
- Insert/Update/Delete Items
- Edit name of SharePoint list
- How many columns can you have in a SharePoint list
- How to hide a column in SharePoint List
- How to Hide multiple columns in SharePoint List
- How to delete a column from SharePoint list
- Microsoft SharePoint list provides flexible ways to store and organize information so that your team members as well as the other site users can use securely and effectively.
- Microsoft SharePoint list has the following basic elements that are as follows:
- Items: List items is like a record in table in the database.
- For example a single employee details.
- Fields: List fields are used as columns in a table.
- For example Name, email address, phone numbers, etc.
- Views: List views are created to display the data
- Items: List items is like a record in table in the database.
You can also watch a video on SharePoint list.
Out Of Box List Templates
Microsoft SharePoint provides various types of lists that are as follows:
- Announcements List: The announcement list that is used to share the news and status and also provide the reminders.
- Contacts List: Contacts list is used to manage contact information.
- Links: Links list is used to post hyperlinks to the webpages.
- Discussion boards: Discussion boards list is used as an online discussion forum.
- Calendar: Calendar list is used to save the team events, meetings, etc.
- Tasks: Tasks list is used to track information about the company project.
- Promoted Links: Promoted Links list is used to set images to the links and can organize them.
- Project tasks: Project tasks list is used to store the task information.
- Issue tracking: The issue tracking list is used to track the issue of any project.
- Survey: Survey list is used to collect the feedback of the users.
- Custom: The custom list is used to create its own list schema.
- External lists: External list is stored outside the SharePoint but you can use this to read and write within the SharePoint.
- Custom list in Datasheet View: Custom list in Datasheet View list is used to create a blank list similar to custom list but it displays the list by default in the datasheet.
- Status list: The status list is the special form of a SharePoint list and it gives the result without the need for any calculations.
- Circulations: Circulations list is used to send the information to the employees in the organization about the policies of the company.
- Microsoft IME Dictionary list: Microsoft IME Dictionary list is used to store the different types of character values in the SharePoint.
- PerformancePoint Content List: PerformancePoint Content List is used to storing the dashboard information.
- Languages and Translators: Languages and Translators list is used with the translation management workflow in a translation library.
- KPI List: KPI List is used to measuring the key performance indicator to evaluate the progress of the goals.
- Import Spreadsheet: Import Spreadsheet is used to create a list with existing spreadsheets.
- In the SharePoint list, you can store only up to 30 million items, and when a list view shows more than 5000 items then that is the list view threshold error.
- The maximum value of list row size can be only up to 8000 bytes per row.
- The maximum number of security scopes in a list should not exceed 50,000.
- By default, when a list is deleted the threshold is 100,000.
Here, I am going to explain how to create an Announcement list in SharePoint.
- Open your SharePoint Online site and Click on the Settings icon at the right-hand side of the page.
- Select Add an app to create an Announcement list.
- Select Announcement list app from the apps you can add option.
- Then in the next dialog box provide a Name for your list and click on Create to add the custom list.
- Once you click on the Create button, it will redirect to the Site Contents page where you can see the list. Click on the List name to open the list.
Add Item to the SharePoint Announcement List
Now, the list has been created, we will see how to add an item the SharePoint list.
- Click on New to add item.
In the New item window, provide the details to announce the message.
- Title: Provide the name to your list item.
- Body: Click on the Pen icon to type the information about the announcement.
- Expires: Click on the Calendar icon to set the expiry date of the message.
Click on Save.
Here, you can see the Announcement list item is created in the list.
In the above steps, we saw how to create a list using a list template in SharePoint. Now, I am going to explain how to create a custom list in SharePoint.
I will show you two ways to create a list in SharePoint Online modern site.
1st Approach
- Open the SharePoint site in which you want to add a list.
- In the SharePoint Site, Click on New >> List.
- From the Create list window, To create a list company for the employees provides the below details:
- Name: Provide the name to the list.
- Description: Give a description of the list.
- Show in site navigation: Select the checkbox to show the created list in the left navigation otherwise you have to go to Settings >> Site contents.
- Click on Create.
- In the left navigation, you can see the created list if you select the Show in site navigation option.
- If you are not selected the Show in site navigation at the time of list creation.
- Click on Settings >> Site contents to open your created list.
Here, you can see created list in the SharePoint site.
2nd Approach
Also, you can create a list from the SharePoint Site Settings option.
- Click on the Settings icon at the right-hand side of the page.
- Select Add an app to create a Custom list.
- Select Custom list app from the apps you can add option.
- Once, Adding Custom List window will open.
- In Name, type a new name as you want it to appear in headings and links throughout the site.
Click on Create to add the custom list.
I have created another list as Company and I will show you how to add columns into the list.
- Open the SharePoint list where you want to add columns. Click on Add column to add columns in the list.
- Select a type of column (data type) that you want to create.
In the Create a column window, provide the below details to create a column.
- Name: Give the column name.
- Description: Give a description about the column.
- Type: Select the column type from the drop-down menu.
Click on Save.
In Company list, you can add different types of columns to store the employees details that are as follows:
- First Name: This column name is Title that you can rename as first name and column type is Single-line of text by default.
- Last Name: Select column type Single-line of text for the last name of the employee.
- Address: Select column type Multiple-lines of text to give the address of the employee.
- Location: Select column type Location to give the employee location (city, state, etc).
- Available: Select a column type Available in which you have to click on the radio button(Yes/No) to select employees is available or not.
- Managers: Select a column type Managers to choose the manager under which the employee assigned.
Here, In the below screenshot you can see the columns added in the SharePoint list.
- Also, you can also create a column from list setting page. Open the list then click on Settings >> List settings.
- In the settings page, click on Create Column.
- Under Create column window, provide the column name and select the type of column.
- You can also set the Additional Column Settings options according to your need.
Click on OK.
Here, you can see the added column in the below screenshot.
Insert/Update/Delete Items
Steps to Add items in the created list:
- Click on New to add items in list.
In New item window, provide the below details to add items in the list:
- First Name: Type the employee’s first name.
- Last Name: Type the employee’s last name.
- Address: Type the address of the employee.
- Location: Give the location of the employee.
- Available: Select Yes/No from the radio button employee is available or not.
- Managers: choose the manager from the drop-down list.
Click on Save to save the items in the list.
Here, you can see the added items in the below screenshot.
Steps to Delete items from the created list:
- Select an item that you want to delete from the created list.
- Click on three-dots.
- Select Delete to delete the item from the list.
Steps to Update items in the created list:
- Select an item from the created list.
- Click on three-dots.
- Select Edit to update an item in the list.
- From the edit window, update the items in the list.
- Click on Save to save the changes.
Here, you can see the updated items in the below screenshot.
- Open a SharePoint list that you want to edit.
- Go to Settings >> List Settings.
- In List settings, select List name, description and navigation.
- Now, click on Name option then edit the name of your SharePoint site.
Here, In the below, the screenshot edited name will appear but the internal name will be the same as you have given at the time of list creation.
In SharePoint list you can add up to 48 calculated columns (8 per row * 6 row maximum = 48).
Column Type | Maximum Columns | Size per column(bytes) |
Single line of text | 255 | 30 |
Multiple lines of text | 350 | 22 |
Choice (menu to choose from) | 255 | 30 |
Number (1, 1.0, 100) | 550 | 14 |
Choice (multiple selections) | 350 | 22 |
Currency ($, ¥, €) | 550 | 14 |
Date and Time | 550 | 14 |
Lookup (information already on this site) | 750 | 10 |
Yes/No (checkbox) | 1000 | 7 |
Person or Group | 750 | 10 |
Hyperlink or Picture | 127 | 60 |
Calculated (calculation based on other columns) | 255 | 30 |
GUID | 350 | 22 |
Integer | 750 | 10 |
Managed Metadata | 190 | 60 bytes for the first, 40 bytes for each subsequent |
- Go to the SharePoint list in which you want to hide the column.
- Select the arrow from any column and then select Column settings >> Hide this column.
- Go to the SharePoint list in which you want to hide the column.
- Select the arrow from any column and then select Column settings >>Show/hide columns.
- In Edit view columns window, you can select which column you want to hide and which you want to show in your SharePoint list.
- Click on Apply.
- Go to the SharePoint list in which you want to delete the column.
- Select the arrow from any column and then select Column settings >>Edit.
- In Edit column window, click on Delete to delete the selected column.
- Also, you can delete the column from settings option Settings>> List settings.
- Go to Columns and then select a column that you want to delete.
- Once, Edit column will open.
- Click on Delete to delete the column.
You may like following SharePoint Online tutorials:
- Show SharePoint List Data using jQuery Datatable
- Bind SharePoint list items to dropdownlist and cascading dropdown using JavaScript and jQuery
- Display SharePoint list data in HTML table using JavaScript
- How to get SharePoint list items using Rest API in Microsoft Power Automate
- Bind SharePoint list templates to dropdown list using JavaScript
- How to get all SharePoint list items using Rest API + Display using DataTables Plug-in
- Get SharePoint List Name and GUID using PowerShell and CSOM
In this Office 365 tutorial, We discussed SharePoint lists. Also, We covered these below topics as:
- What is List in SharePoint
- Out Of Box SharePoint List Templates
- SharePoint List Limitations
- Create a list in SharePoint Online (Announcement List)
- Create a Custom List in SharePoint Online
- Add columns in the list
- Insert/Update/Delete Items
- Edit name of a SharePoint list
- How many columns can you have in a SharePoint list
- How to hide a column in SharePoint List
- How to Hide multiple columns in SharePoint List
- How to delete a column from SharePoint list
Bhawana Rathore is a Microsoft MVP (3 times in Office Apps & Services) and a passionate SharePoint Consultant, having around 10 years of IT experience in the industry, as well as in .Net technologies. She likes to share her technical expertise in EnjoySharePoint.com and SPGuides.com