This blog post will explain what a SharePoint Online list is, how it differs from a SharePoint library, how to create a simple SharePoint list, how to create a custom SharePoint list, how to make any changes to a SharePoint list, how to delete any SharePoint list, how to restore the data that has been deleted from a SharePoint list, and so on.
In Microsoft’s SharePoint 2016, lists are added.
SharePoint lists offer a user-friendly interface similar to Excel spreadsheets for managing, updating, and effectively displaying data.
Understanding how to use them is crucial if you’re still learning about SharePoint. Let’s dig deeper into them now.
What is a List in SharePoint Online?
A SharePoint list is a collection of information or items. Rows and columns are used to store data. Tables in Microsoft Excel spreadsheets are very similar to this. Items can be referred to as metadata, fields, or properties, while the rows in the list are referred to as the list.
For creating various types of lists in SharePoint, a wide range of templates are available, including:
There is also the option of creating a customized list from scratch if you need a different template.
SharePoint Lists vs SharePoint Libraries
Now we will see the differences between SharePoint lists and SharePoint document libraries. There are some criteria on which we will discuss the difference-
Check-In and Check-Out Feature
In a SharePoint List, we can simply click “Edit” to change an item without first checking it out. The item can be modified directly. Check-in and check-out functionality are not available in SharePoint lists. Instead, we cannot change any items in the SharePoint Library. SharePoint Libraries support check-in and check-out functionality. The options for check-in and check-out will appear when we select any document from the library. It is regarded as one of the most significant distinctions between SharePoint lists and libraries.
In a SharePoint List, if we need to attach documents with the item so we can add it in the attachments field. We can attach as many documents as we want. There is no maximum limit for it and to adding documents is not mandatory in SharePoint lists. While in the SharePoint library, we cannot create an item without uploading any document. In the library, we save the document itself as an item and then we can add the metadata related to that document for further information.
In SharePoint Lists, when we add documents as attachments, these List attachments are not indexed by SharePoint. Accordingly, they will not be visible in search results. While, in a document Library, if we search for a keyword, we can see the document shown in the search results because the document is crawled.
In SharePoint Lists, we can only contain major versions also called published versions. When we go into List Settings and then we click on Versioning, it allows us to specify whether we want to version or not. But here, we can only enable major versioning. However, when we go into Library Settings and then we click on Versioning, we can enable both major (Published) and minor (Draft) versioning. Moreover, we can specify the number of versions to retain for minor as well as major versioning.
Now first we will see how to create a simple Microsoft list-
Creating a Custom SharePoint List
Now we will see how to create a custom SharePoint list on SharePoint Site.
Creating custom fields or metadata
Now we will see how to add custom metadata to our list-
We’ll now look at how to add additional metadata to our list:
When you first visit a SharePoint site, you may notice a Settings button in the top right corner of the header bar. Clicking this button will open a panel with various options, from which you must select Site contents. A page displaying all of your lists and libraries will appear after clicking. The list where you want to add custom metadata must then be selected. A panel with various options, including the list setting option, will appear once the list has been reopened. To access the settings panel, click the settings icon in the header bar. The Create a column option will be available on a new page. To add metadata columns to your list, select that.
Changing The Name and Description of a SharePoint List
Following the preceding action, navigate to the list settings, where you will find the List name, description, and navigation option. After clicking on that, a page will appear where you can change the Name and Description of the list. There is also one option for attaching the link of the SharePoint list to the navigation, which you can also choose based on your needs.
SharePoint List’s Other Settings
For the other settings of the SharePoint list, you will have to follow the previous step also for going into List Setting. When you click on the List Setting you will appear a page with a General Setting option where all the general settings are available to access.
For example, Versioning in SharePoint is one of the major features. It allows you for tracking the activity of any item (event, task, document, etc.). When you turn on the versioning you can make collaborative tasks like document review, co-authoring, and List updates more straightforward with your colleagues and co-ordinates.
NOTE: SharePoint users must have the Manage Lists permission to enable versioning.
You can choose to allow users to read or edit certain items, enable attachments, launch forms in dialogue, and other advanced settings on this list. You can also choose whether to allow the management of content types.
Using audience targeting settings, you can filter list contents based on a user’s context. To specific audiences, promote content. Office 365 and Azure Active Directory groups can be included in an audience.
To use contemporary web parts like News, Highlighted content, and others, choose Enable audience targeting.
For use with older web parts like the Content Query web part, choose Enable Classic Audience Targeting.
Returning to your list after making changes will reveal that it has been updated.
Now we will see how to delete a SharePoint List-
First, you will have to select the list you want to delete then click on the settings option and choose the list settings options.
A page will appear in which you have to find the Delete this list option and click on it for deleting the particular list.
If you delete any item from a SharePoint list so they aren’t deleted permanently you can also restore that item.
The items which have already deleted are moved to the SharePoint site recycle bin for the specific period (usually 91 days) before they are permanently deleted.
To restore a deleted list item from the recycle bin of SharePoint. Open the SharePoint site from which the items were deleted. Click Recycle Bin from the Quick Launch bar navigation on the bottom left of the screen. If the Recycle Bin option is not present on the Quick Launch bar, click Settings and select Site contents. You will find the recycle bin in the top right portion of the Site Contents page. You will now see the Recycle bin and be able to restore it as usual.
Now after clicking on the Recycle bin option you can see the Recycle bin page and select the items or files you want to restore.
After choosing the desired files, click Restore.
The restored items will now be restored to the location you deleted them from.
Due to the combination of rights, forms, targeting, and data validation control sets, you can manage data integrity more effectively with a SharePoint list than with a Microsoft Excel spreadsheet. Every item in the SharePoint list has a version history and an edit history.
Rather than relying solely on an Excel spreadsheet, we can easily connect a SharePoint list with the other Microsoft 365 products. For instance, integrating a SharePoint list with Power BI to feed custom reporting or flows created in Power Automate based on data entered into the list is very straightforward. An intranet can easily display SharePoint List data.
In this blog, we learned what SharePoint Lists are, how they differ from libraries, the types of Lists, how to create a custom List, and how to add items. Microsoft 365’s SharePoint Lists are a fantastic feature for managing and sharing vast data.
Hopefully, you’ll feel more at ease creating and managing SharePoint Lists and use them more frequently. Please get in touch with us at [email protected] or you can schedule a complimentary consulting session on SharePoint Consulting if you require any additional assistance in comprehending SharePoint List and any additional information regarding SharePoint Lists.
