SharePoint Online List Examples [15 Real Examples]

In this SharePoint tutorial, we will discuss a few SharePoint Online list examples. These are the list examples that we have created using different types of datatypes to store various information.

SharePoint Online List Examples

Here are the examples of SharePoint lists that we have created on our SharePoint Online team site. All these lists, you can also create in a SharePoint on-premise environment like SharePoint server 2019 or SharePoint server subscription editions. Check out these 15 useful SharePoint lists.

After reading this tutorial, you will learn how to create a custom list in SharePoint Online as well as how we can add various columns of different data types to a SharePoint Online list.

Example-1: Clients list

This is a SharePoint list example where one of our clients in the USA wanted to show their clients list. The client wanted to store the following informations:

• Client ID
• Client Names
• Contact Information
• Client Addresses, etc.

For that, we have created a custom SharePoint list and created columns like the below:

Here are the column details:

• Title: The Title column will be created by default while creating a SharePoint list. We can rename the Title column to store the Client ID based on our requirements.
• Client Name: This single line of text type column in which we have saved the client’s name.
• Client Phone Number: This Number type column in which we have saved the client’s Phone Number. But if we choose datatype as a number, by default, it previews with a comma of Thousand Separator (1,000). To remove a thousand separators from the number, expand More options and deselect the toggle option ‘Use thousands Separator’ (Ex: 1000) as shown below:

• Client Website: This Hyperlink type column, in which we have saved the client’s Website URL. For Example: https://<CompanyDomainName>.com

• Client Address: This is a Location type column in which we have saved the client’s location. Also, it shows linked columns in the current view contains as we can choose additional information to show, such as Street Address, City, State, Country or Region, Postal Code, Coordinates, Name, etc

• Is Still Client Active: This Yes/No type column in which we have saved the information on the client, whether they are still active or not, so select Data type as Yes/No

• Client Rating: This Rating type column is not available in the see-all column type. To add Ratings to our list, the following steps are:
  • Go to List settings -> Select Rating Settings
  • That appears with the choice column as Yes/No -> Select Yes and Select Star Ratings experience, which you would like to enable for the list.

Here, we create the table containing information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display Name	Column Internal Name	Data Type	Default Value
Client ID	Title	A single line of Text	NA
Client Name	Clients	A single line of Text	NA
Client Phone Number	ClientPhoneNumber	Number	NA
Client Website	ClientWebsite	Hyperlink	NA
Client Address	ClientAddress	Location	NA
Is Still Client Active	IsStillClientActive	Yes/No	Yes
Client Rating	AverageRating	Rating (0-5)	0 or empty

This is an example of a SharePoint list where you can store this information.

Example-2: Products list

Here is another SharePoint Online list example, where one of our clients wanted to store information about their product details. They wanted to save information like:

• Product ID
• Product Name
• Product Description
• Is Product Available, etc.

The SharePoint list with a few records looks like below:

Here are the columns with the data types we created for the SharePoint list.

• Title: We renamed the default ‘Title‘ column to the Product ID.
• Product Name: This is a single line of text type column in which we have saved the Product’s name.
• Product Description: This is a Multiple lines of text type column storing the Product Description.
• Product Cost: This is a Currency type column in which we have saved the cost of the product as Product Cost in the currency format of the United States.

• Product Quantity: This is a Number type column in which we have saved the number of products as Product Quantity. But if we choose datatype as a number, by default it previews with a comma of Thousand Separator (1,000). To remove a thousand separators from the number, expand More options and deselect the toggle option ‘Use thousands Separator’ (Ex: 1000)
• Is Product Available: This Yes/No type column in which we have saved the information of the product, whether the product is available or not, so select Data type as Yes/No
• Product Rating: This Rating type column is not available in the see all column type, To add Ratings to our list, the following steps are:
  • Go to List settings -> Select Rating Settings
  • That appears with the choice column as Yes/No -> Select Yes and Select Star Ratings experience which you would like to enable for the list.

Here, we create the table containing information like SharePoint list Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display Name	Column Internal Name	Data Type	Default Value
Product ID	Title	A single line of Text	NA
Product Name	ProductName	A single line of Text	NA
Product Description	ProductDescription	Multiple lines of text	NA
Product Cost	ProductCost	Currency	NA
Product Quantity	ProductQuantity	Number	NA
Is Product Available	IsProductAvailable	Yes/No	Yes
Product Rating	AverageRating	Rating (0-5)	0 or empty

This is what the SharePoint Custom Products list looks like.

Example-3: Transaction Details list

If you have a requirement to store transaction details, then this SharePoint Online list example is for you. We have the same client from the USA and wanted to store a few transaction details.

They wanted to store information like

• Transaction ID
• Product ID
• Supplied Product
• Product Supplied Date
• Product Cost
• Product delivery person
• Paid or not, etc

According to the above columns, you can enter the items in the respective columns of the SharePoint list.

Here are the column details:

• Title: We renamed the default ‘Title‘ column to the Transaction ID.
• Product ID: This is a Lookup type column in which we have selected a list as a source from the Semiconductor Products column -> Select a Column from the list above (By default Title will be chosen) -> Expand More Options, to add additional columns from the source list looks like a Choice column, displaying multiple options for the user to choose from which Semiconductor Products column, Choose Product Name as shown below:

• Product ID: ProductName:- Here, we have created a Lookup type column by taking the columns (Product ID and ProductName) from the above-mentioned SharePoint lists. We can also rename this column to the Supplied Product based on our requirements.
• Product Supplied Date: This is the Date and time type column in which we have saved the date of the Product Supplied using Calendar.

• Product Cost: This is a Currency type column in which we have saved the cost of the product as Product Cost in the currency format of the United States.
• Client ID: This is a Lookup type column in which we have selected a list as a source from the Semiconductor Clients column -> Select a Column from the list above(By default Title will be chosen) -> Expand More Options, to add additional columns from the source list.

• Product Delivery Person: This is a Person type column in which we have added the person who delivers the product.

• Is Paid or Not: This is the Choice type column in which we have saved the information of the transaction that the client is paid, or kept balance, or else it is in Draft. We gave the choices as paid, Balance, and Draft. Where the user can select the choice as per their requirement.

• Digitally Paid: This Yes/No type column in which we have saved the information of the Transaction, whether the transaction is digitally paid or not, so select Data type as Yes/No.

Here, we create the table containing information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display Name	Column Internal Name	Data Type	Default Value
Transaction ID	Title	A single line of Text	NA
Product ID	ProductID	Lookup	NA
Supplied Product	SuppliedProduct	Lookup	NA
Product Supplied Date	ProductSuppliedDate	Date and Time	NA
Product Cost	ProductCost	Currency	NA
Client ID	ClientID	Lookup	NA
Product Delivery Person	ProductDeliveryPerson	Person or Group	NA
Is Paid Or Not	IsPaidOrNot	Choice	NA
Digitally Paid	DigitallyPaid	Yes/No	Yes

I hope you got some ideas from this SharePoint list example.

Example-4: Issue Tracker

This is a common requirement to store issue details in SharePoint. Here the organization want to store information like:

• Issue ID
• Issue
• Issue Description
• Issue Status
• Issue Assigned person
• Is still active or not, etc.

For this, we have created a custom SharePoint list and created columns like the below:

Here are the SharePoint list column details:

• Issue ID: We renamed the default ‘Title‘ column to the Issue ID.
• Issue: This is a single line of text type column in which we have saved the Issue of a Product Supplied.
• Issue Description: This is a Multiple lines of text type column in which we have saved the purpose of the Issue as an Issue Description.
• Issue Status: This is the Choice type column in which added choice options like In Progress, Completed, and Won’t Fix.
• Issue Assigned To: This is a Person type column in which we have added the person who can resolve this Issue of the Product.
• Issue Image: This is an Image type column in which we have stored the image of an Issue in the product by uploading it from the local system.

• Is Still Issue is Active: This Yes/No type column in which we have saved the information of an Issue, whether the Issue is still active or not, so select Data type as Yes/No.
• Issue Resolved Date: This is the Date and time type column in which we have saved the date of the Issue got Resolved using Calendar.

Here, we create the table containing information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display Name	Column Internal Name	Data Type	Default Value
Issue ID	Title	A single line of Text	NA
Issue	Issue	A single line of Text	NA
Issue Description	IssueDescription	Multiple lines of text	NA
Issue Status	IssueStatus	Choice	NA
Issue Assigned To	IssueAssignedTo	Person	NA
Issue Image	IssueImage	Image	NA
Is Still Issue is Active	IsStillIssueIsActive	Yes/No	Yes
Issue Resolved Date	IssueResolvedDate	Date and time	NA

I hope you got an idea of how to create an issue list from this SharePoint list example.

Example-5: Doctors List

Here is an example of a SharePoint list where one of our clients wanted to store doctor’s information in SharePoint.

They wanted to store informations like:

• Doctor ID
• Doctor Name
• Contact number
• Address
• Education, etc.

And here are the column details:

• Title: This is the Default Column in the List. Here, we rename this to Doctor ID, where the Data type is automatically taken as a Single line of text.
• Doctor Name: We have created a single line of text named ‘Doctor Name’ to store the name of the Doctors where the Maximum number of characters is up to 255.

• Country And Areacode: We have created a single-line text column as a data type named-‘Country and Areacode’ to store the country and Area code.

• Mobile Number: We have created the Number type column named- ‘Mobile Number’ but it is shown in the format as shown in the example : (25,000).To disable this use the thousands separator option in the Edit column.To remove a thousand separators from the number, expand More options, and deselect the toggle option ‘Use thousands Separator’ (Ex: 25000).
• Alternate Mobile Number: we have created a Number type column named –‘Alternate Mobile Number’ i.e, used to store information like Doctor Contact Numbers by deselecting the toggle option ‘Use thousands Separator’.

• Email Address: We have created this as a Single line of text named-‘Email Address’i.e, used to store the Doctor’s email address.

• Board of Certification: Here, we have created a choice column for the Board of Certification and we have inserted the choice options like The American Board of Internal Medicine, American Board of Orthopedic Surgery, American Board of Anesthesiology, American Board of General Medicine, American Board of Pathology, and American Board of Surgery.
• Along with this, we have a display choice that will be a Drop-Down menu ( To Allow multiple selections, click on more options and enable it)where we can use various choices from the choice list options.

• Education: We have created this as a Single line of text named-‘Education‘ to store the education details of Doctors.

• Address: Here, We have created the Location column named – ‘Address’ and selected linked columns in the Edit column for example, state, Country, or region, It will automatically create the columns of Address of State and Address of Country or Region in the List.

• Languages known: Here, we have created another choice column named-‘Languages known‘, and the chosen values are English, Spanish, and French. It allows displaying choices in Different ways like the Drop-Down menu or Radio buttons.
  • Along with this, there is another option of Allow Multiple selections(by enabling Allow multiple selections where the user can choose more than one option from the choice values).

• Specialty: We have created another Choice column named-‘speciality‘ where we can mention the specialization of Doctors and the choice values with a display option as a Drop-Down Menu like below.

• Experience: We have created a single-line text column named –‘Experience’ is used to store the experience of Doctors’ in year’s format.

• Rating Column: Here we have created a Rating column for the Doctors Review. The column is taken from the Rating settings (This option is not available in the Types of columns, we can reach the Rating settings with these steps Gear icon -> List settings -> Rating settings).
  • From the Rating settings, we can select the option of Star ratings or likes. Here, we have used the star mark option in it.

Below we have created the Table that will display the information on this list such as Column Display Name, Column Internal Name, Column Data Type, and Default value. The table format is given below:

Column Display Name	Column Internal Name	Column Data Type	Default value
Title-we have renamed this to Doctor ID	Title	Single line Text	NA
Doctor Name	DoctorName	Single line Text	NA
Country and Area code	Country and Area code	Single line Text	NA
Mobile Number	MobileNumber	Number	NA
Alternate Mobile Number	AlternateMobile Number	Number	NA
Email Address	EmailAddress	Single line Text	NA
Board Certification	BoardCertification	Choice	NA
Education	Education	Single line text	NA
Address	Address	Location	NA
Languages known	Languages known	Choice	NA
Speciality	Speciality	Choice	NA
Experience	Experience	Single line text	NA
Rating	Rating	NA	NA

This is the Overview of the SharePoint List example.

Example-6: Services List

One of our clients, based in the USA, wanted to store the Services they provide to the clients in their SharePoint site portal. They want to store information like:

• ServiceID
• Service Name
• Service Type
• Primary care
• Disease Type, etc.

For this, we have created a custom SharePoint list and created columns like the below:

• Service ID: We have renamed this column to Service ID as the client requires.
• Service Name: This is created as a Single line of text to store Service Name.
• Service Type: Here, we have created a choice column to store different types of Services. It allows displaying choices in different ways, like the Drop-Down menu or Radio buttons.
  • There is another option of “Allow Multiple selections” (by enabling Allow multiple selections where the user can choose more than one option from the choice values).
• Primary Care: We have created a single-line text column named -‘Primary Care‘ is used to store the Primary care taken for the particular Service type.
• Disease Type: Here, we have created this as a Single line of text named-‘Disease Type‘i.e, used to store the Type of Disease that is treated by the Hospital.
• Specialized Doctor: We have created a Lookup column named-‘Specialized Doctor‘ that is used to store the information related to Doctors who are specialized in a particular disease type.
• Here, in the look-up column, we can select the list source and list columns from the previously stored list.
  • We have selected a list source and list column regarding the requirement from the client i.e,(List source: Doctors, List column: Doctor Name).
  • It will create a Lookup column with Doctor names.

• Health Insurance: We have created a yes/No type column named -‘ Health Insurance’ is used to store the Health Insurance taken for the particular Service type.
  • By default, it will display a yes value in the edit column.

• Service Cost: We have created a Currency column named- ‘Service Cost‘ that allows all the currency formats, but as per our requirement, we have to use United States currency in the Service Cost.

Below we have created the Table that will display the information on this list such as Column Display Name, Column Internal Name, Column Data Type, and Default value. The table format is given below:

Column Display Name	Column Internal Name	Column Data Type	Default value
Title- we have renamed this to the Service ID	Title	Single line text	NA
Service Name	Service Name	Single line text	NA
Service Type	ServiceType	Choice	NA
Primary Care	Primary Care	Single line text	NA
Disease Type	Disease	Single line text	NA
Specialized Doctor	AssignedDoctor	Lookup	NA
Health Insurance	Health Insurance	yes/No	Yes
Service Cost	Service Cost	Currency	NA

I hope you get some idea from this list example in SharePoint.

Example-7: Careers List

The same client wanted to store career opportunities like Jobs for various roles in a SharePoint list.

They wanted to store information like Job ID, Job Role, Job Description, Experience level, Posted Date, Expiry Date, Job Location, etc. For this, we have created a custom SharePoint list and created columns like the below:

• Job ID: This is the ‘ Title ‘Default Column in the List. Here we rename this to Job ID.
• Job Role: This column we created to store Job Roles.
• Job Description: This a multiline text column to store Job Description. In the multiple lines of text, more than 255 characters can be used.
• Experience Level: This column can be a choice or single line of column to store the experience level.
• Posted Date: This we have created a column as posted date to track the job posting date. Here also, you can take the Created Date default column.
  • Here, in the Date and Time Type Column, we can also Select the Include Time option by clicking on the toggle selection.
  • Thus, we can select the Date from the calendar icon.
• Expiry Date: Here, we have created a Date and Time column named Expiry Date Where users can select the date from the date picker as per their requirements.

• Location: Here, We have created the Location column named – ‘Location‘ and selected linked columns in the Edit column for example state, Country, or region, It will automatically create the columns of Address of State and Address of Country or Region in the List.
• Job Type: We have created a Choice column named Job Type having choices like Regular, work from home, and Part-time.
• No Of Vacancies: We have created a Number column named No Of Vacancies. By default, the Number column comes with a thousand separators. As per requirement, we need to display the No of Vacancies without separators. So, here we have disabled the option “Use a thousand separators”.
• Annual CTC: We have created a Currency column named- ‘Annual CTC’ that allows all the currency formats but as per our requirement, we have to use United States currency in the Annual CTC.

Column Display Name	Column Internal Name	Column Data Type	Default Value
Title-we have renamed this to the Job ID	Title	Single line text	NA
Job Role	JobRole	Single line text	NA
Job Description	Job Description	Multiple lines of text	NA
Experience level	Experience level	Single line text	NA
Posted Date	Posted Date	Date and Time	NA
Expiry Date	Expiry Date	Date and Time	NA
Location	Location	Location	NA
No Of Vacancies	No Of Vacancies	Number	NA
Annual CTC	Annual CTC	Currency	NA

I hope now you understand this SharePoint list example.

Example-8: Patients List

From the same client, we got another requirement to store patient details in a SharePoint list. They wanted to store information like:

• Patient ID
• Patient Name
• Contact number
• Address
• Gender, etc.

For this we have created a custom SharePoint list and created columns like the below:

• Patient ID: This is the ‘ Title ‘Default Column in the List. Here we rename this to ‘Patient ID‘.
• Patient Name: This is created as a Single line of text named-‘Patient Name’to store the name of the Patient as per our requirements. In Single line text, the Maximum number of characters is up to 255.
• Gender: Here, We have created a Choice column named Gender having the following choices like Male, Female, etc.
• Patient Age: We have created a Number column named Patient Age. By default, the Number column comes with a thousand separators. As per requirement, we need to disable the Thousand separators option.
• Blood Group: Here, we have created a Choice column named Blood Group having the following choices such as O+, O-, A+, A-, B+, B-, AB+, and AB-, etc.
• Disease Type: This also in the same way, we have created a Choice column named Disease Type having the following choices Heart Disease, Eye Disease type, Injury and wound care, Endocrine disorder, Cancer, Respiratory, and Pediatric, etc.
• Country and Area Code: We have created a single-line text column as a data type named-‘Country and Areacode‘ to store the codes of country and Area.
• Mobile Number: We have created a Number column named Mobile Number. Here, also we disabled the option to display a thousand separators within the number.
• Email Address: we have created this as a Single line of text named-‘Email Address‘i.e, used to store the patient’s email addresses.
• Permanent Address: Here, we have created the Location column named – ‘ Permanent Address’ and selected linked columns in the Edit column for example state, Country, region, and City. It will automatically create the columns of Address of State and Address of Country or Region in the List.

Column Display Name	Column Internal Name	Column Data Type	Default Value
Title-we have renamed this to the Patient ID	Title	Single line text	NA
Patient Name	PatientName	Single line text	NA
Patient Age	PatientAge	Number	NA
Gender	Gender	Choice	NA
Blood Group	BloodGroup	Choice	NA
Disease Type	DiseaseType	Choice	NA
Country And Area Code	CountryAndArea Code	Single line text	NA
Mobile Number	MobileNumber	Number	NA
Email Address	EmailAddress	Single line text	NA
Permanent Address	PermanentAddress	Location	NA

This is another SharePoint Online list example.

Example-9: Furniture Types List

According to the requirements from the client, we wanted to store furniture types in a SharePoint Online list. They wanted to store information like Furniture name, price, category, color, etc. For this we have created a custom SharePoint list named Furniture Types and created columns like the below:

Here, we have created the different types of columns for the SharePoint custom list such as:

• Title: We rename this default Title column to Furniture ID as per our requirement.

• Furniture Name: This single line of text column will be used to store the furniture name.

• Features: We have created a multiple-line of text column to store the furniture’s features.

• Color: We have created a Choice column named Color having the choices Brown, Black, White, Yellow, Red, and Blue. Once we enable Allow multiple selections, the user can select multiple colors.

• Category: We have created a Choice column named Category having the choices Dining-Kitchen, Office, Outdoor, Living, Bedroom, and Children. Where the user can select the Category as per their requirement.

• Price: We have created a Currency column named Price that allows all the currency formats; but as per our requirement, we have used United States currency.

• Quantity: We have created a Number column named Quantity. By default, the Number column comes with a thousand separators. As per requirement, we need to display the product’s quantity without separators. So, here we have disabled the option”Use a thousand separators”.

• Locations: We have created a Choice column named Locations having the choices Florida, Indiana, and Georgia. We enabled the Allow multiple selections where the user can select multiple locations.

• Image: To provide, furniture images, we can create a column of Image datatype. So that when a user inserts an image while adding the furniture they can either provide an URL or can also upload it from their desktop.

• Style: We have created a Choice column named Style having the choices Colonial American Furniture, Contemporary Furniture, Country, and Farmhouse. From where the user can select the Style as per their requirement

Here, we have created the Table having column information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display Name	Column Internal Name	Data Type	Default Value
Title Column – We rename this column to Furniture ID	Title	Single Line Text	NA
Furniture Name	FurnitureName	Single Line Text	NA
Color	Color	Choice	NA
Features	Features	Multiple lines of text	NA
Price	Price	Currency	NA
Category	Category	Choice	NA
Quantity	Quantity	Number	NA
Style	Style	Choice	NA
Image	Image	Image	NA
Locations	Locations	Choice	NA

This is how we created a SharePoint custom list.

Example-10: Customer Details List

According to the requirements from the client, we wanted to store Customer Details in a SharePoint Online list. They wanted to store information like Customer ID, Customer Name, Gender, Mobile number, Permanent Address, etc. For this we have created a custom SharePoint list named Customer Details and created columns like the below:

Here, we have created the different types of columns for the SharePoint custom list such as:

• Customer ID: We rename this default Title column to Customer ID as per our requirement.
• Customer Name: This single line of text column will be used to store the customer name.
• Gender: We have created a Choice column named Gender having the choices Male, Female, and Others. Where the user can select the Gender as per their requirement.
• Country And Area Code: This single line of text column will be used to store the customer’s country and area code.
• Mobile Number: We have created a Number column named Mobile Number. By default, the Number column comes with a thousand separators. As per requirement, we need to display the Phone Number without separators. So, here we have disabled the option”Use a thousand separators”.
• Emergency Number: We have created a Number column named Emergency Number. Here, also we disabled the option to display a thousand separators within the number.
• Email: This single line of text column will be used to store the customer’s Email ID.
• Permanent Address: This Location type column in which we will save the Customer’s permanent address. Also, it shows linked columns in the current view contains as we can choose additional information to show as Street Address, City, State, Country or Region, Postal Code, Coordinates, Name, etc

Here, we have created the Table having column information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display Name	Column Internal Name	Data Type	Default Value
Title Column – We rename this column to a Customer ID	Title	Single Line Text	NA
Customer Name	CustomerName	Single Line Text	NA
Gender	Gender	Choice	NA
Country And Area Code	CountryAndAreaCode	Single Line Text	NA
Mobile Number	MobileNumber	Number	NA
Emergency Number	EmergencyNumber	Number	NA
Email	Email	Single Line Text	NA
Permanent Address	PermanentAddress	Location	NA

This is another SharePoint Online list example that we have created from a custom list.

Example-11: Order Forms List

According to the requirements from the client, we wanted to store Order Forms in a SharePoint Online list. They wanted to store information like Customer ID, Furniture ID, Order Date, Delivery Date, Order Quantity, Payment, Discount, etc. For this we have created a custom SharePoint list named Order Forms and created columns like the below:

Here, we have created the different types of columns for the SharePoint custom list such as:

• Customer ID: We rename this default Title column to Customer ID as per our requirement.
• Furniture ID: We have created a Lookup column named Furniture ID. It provides all the information about the Furniture. In the look-up column, we can select the list source and list columns from the previously stored list(Furniture Type).

• Order Date: We have created a Date and Time column named Order Date. Where users can select the date from the date picker as per their requirements.
• Delivery Date: We have created a Date and Time column named Delivery Date. Where users can select the date from the date picker as per their requirements.
• Order Quantity: We have created a Number column named Order Quantity. By default, the Number column comes with a thousand separators. As per requirement, we need to display the Order Quantity without separators. So, here we have disabled the option Use a thousand separators.
• Payment: We have created a Choice column named Payment having the choices Online, and Offline. Where the user can select the Payment as per their requirement.
• Discount: We have created a Number column named Discount. Here, we have selected a Preview as a percent(%) in the Number column. Where the user can select Discount as per their requirement.

• Quality: We have created a Choice column named Quality having the choices Good, Better, and Excellent. Where the user can select the Quality as per their requirement.
• Door Delivery: We created a Yes/No column named Door Delivery. Here, the user can select the option Yes/No as per their requirement.
• Rating: This Rating type column is not available in the all column type, to add Ratings to our list, the following steps are:
  • Go to List settings and select Rating Settings.
  • It will appear with the choice column as Yes/No. If we Select Yes and select Star rating/Likes. Then the Rating option appears in the list columns.

Here, we have created the Table having column information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display Name	Column Internal Name	Data Type	Default Value
Title Column – We rename this column to a Customer ID	Title	Single Line Text	NA
Furniture ID	FurnitureID	Lookup	NA
Order Date	Orderdate	Date and Time	NA
Delivery Date	Deliverydate	Date and Time	NA
Order Quantity	OrderQuantity	Number	NA
Payment	Payment	Choice	NA
Discount	Discount	Number	NA
Quality	Quality	Choice	NA
Door Delivery	DoorDelivery	Yes/No	Yes
Rating	AverageRating	Rating	NA

This is how we created the SharePoint custom list.

Example-12: Company Details List

According to the requirements from the client, we wanted to store Company Details in a SharePoint Online list. They wanted to store information like Company ID, Company Name, Opening Time, Closing Time, Contact Number, Email, etc. For this we have created a custom SharePoint list named Company Details and created columns like the below:

Here, we have created the different types of columns for the SharePoint custom list such as:

• Company ID: We rename this default Title column to Company ID as per our requirement.
• Company Name: This single line of text column will be used to store the Company name.
• Opening Time: We have created a Single line of text column named Opening Time. Here, we don’t use the Date and Time column. Once we are using the Date and Time column it will appear with the date also. So, we have used the Single line of text column for Opening Time.
• Closing Time: We have created a Single line of text column named Closing Time. Here, users can select the Closing Time as per their requirements.
• Contact Number: We have created a Number column named Contact Number. Here, also we disabled the option to display a thousand separators within the number.
• Email: This single line of text column will be used to store the Company Email ID.
• Video Library: We have created a Hyperlink or Picture column named Video Library. Here, users can provide a hyperlink for Company Details as per their requirements.
• Locations: We have created a Choice column named Locations having the choices Florida, Indiana, and Georgia. Where users can select the Location as per their requirements.
• Address: We have created a multiple-line of text column to store the Company address.
• Visitor ID: We have created a Number column named Visitor ID. Here, also we disabled the option to display a thousand separators within the number.

Here, we have created the Table having column information like Column Display Name, Column Internal Name, Data Type, and Default Value.

Column Display Name	Column Internal Name	Data Type	Default Value
Title Column – We rename this column to a Company ID	Title	Single Line Text	NA
Company Name	CompanyName	Single Line Text	NA
Opening Time	Openingtime	Single Line Text	NA
Closing Time	Closingtime	Single Line Text	NA
Contact Number	Contactnumber	Number	NA
Email	Email	Single Line Text	NA
Video Library	VideoLibrary	Hyperlink or Image	NA
Locations	Locations	Choice	NA
Address	Address	Multiple lines of text	NA
Visitor ID	Visitorid	Number	NA

This is how we created the SharePoint custom list.

Example-13: Employee Directory List 

As per the requirement of our client, we need to store all basic information about the members of the company, including their ID, Name, Job Title, Contact Information, etc. For this we have created an ‘Employee Directory’ custom SharePoint online list as shown below:

Let’s see the list of columns and their data types, that we have used in the above SharePoint list as shown below:

• Employee ID: Here, we have renamed the default ‘Title’ column to Employee ID.
• Employee Name: We have taken a ‘single line of text’ data type column to store the employees’ names.

• Employee Image: We have created the ‘image’ data type to store images of the employees by uploading them from the local system.

• Employee Email: Here, we have used a ‘Single lines of text’ data type column to provide the Employee’s Email.

• Employee Contact Number: We have created this column using the ‘Number’ data type and disabled the ‘Use thousands separator‘ toggle because if it is enabled then it shows a comma after every 3 digits (like this 123,567).

• Employee Location: Here, we have used the ‘location’ data type to create this column. We can select the linked columns from the current view such as Street Address, City, State, Postal Code, and so on. Suppose, we want to display the Country or Region and Postal Code then, for this, we have selected the linked columns from the list and click on Save.

• Employee Job Title: Here, we provide job titles to the employees and for that, we have used a ‘Single line of text.’

• Employee Department: Here we have created the ‘choice’ data type column that contains Sales, Marketing, Design, Trading & Conversion, and Brand & Content. Also, we enabled Allow multiple selections so that the user can select multiple departments.

Here we have created a table that contains the name of the column, the internal name of the column, what data type we have used, and what is the default value of the column.

Column Name	Internal Name	Data Type	Default Value
Employee ID	Title	Single line of text	NA
Employee Name	EmployeeName	Single line of text	NA
Employee Image	EmployeeImage	Image	NA
Employee Email	EmployeeEmail	Single line of text	NA
Employee Contact Number	EmployeeContactNumber	Number	NA
Employee Location	EmployeeLocation	Location	NA
Employee Job Title	EmployeeJobTitle	Single lines of text	NA
Employee Department	EmployeeDepartment	Choice	NA

This is how we have created our custom SharePoint list ‘Employee Directory’.

Example-14: Wallpapers List

As per the requirement of our client, we need to store all basic information about the wallpapers which are manufactured by the company, including their ID, Name, Color, Style, Collection, etc. For this we have created a ‘Wallpapers’ custom SharePoint online list and created columns as shown below:

Let’s see the list of columns and their data types, that we have used in the above SharePoint list as shown below:

• Wallpaper ID: Here, we have renamed the default ‘Title’ column to Wallpaper ID.
• Wallpaper Name: We have taken a ‘single line of text’ data type column to store the wallpapers’ names.
• Wallpaper Color: Here, we have created a ‘choice’ data type column that contains different types of colors for the wallpaper such as black, brown, yellow, green, etc.
• Wallpaper Collection: Here, we have taken a ‘choice’ data type column that contains different types of wallpaper such as ABRA I&II, Blush Label, Gray Malin, etc.
• Wallpaper Style: We have taken the ‘choice’ data type column with different types of wallpaper styles like Kid+Baby, Abstract, Animal, Organic, etc.
• Wallpaper Size: For this, we have taken the ‘choice’ data type column. This will provide different sizes of wallpapers like 2 ft * 10 ft Premium Paper, Sample-Peel & Stick, etc.
• Wallpaper Quantity Available: Here, we have taken the ‘Number’ data type column to have a record of the wallpaper in stock.
• Wallpaper Price: For this, we have created the ‘choice’ data type column because the price depends on the material and size of the wallpaper.
• Wallpaper Is Available: We have created the Yes/No data type column. It shows whether the item is available or not. The default value of this column is Yes if we didn’t select the option it will by default takes the option Yes.

Here we have created a table that contains the name of the column, the internal name of the column, what data type we used, and what is the default value of the column.

Column Name	Internal Name	Data Type	Default Value
Wallpaper ID	WallpaperID	Single line of text	NA
Wallpaper Name	WallpaperName	Single line of text	NA
Wallpaper Color	WallpaperColor	Choice	NA
Wallpaper Collection	WallpaperCollection	Choice	NA
Wallpaper Style	WallpaperStyle	Choice	NA
Wallpaper Size	WallpaperSize	Choice	NA
Wallpaper Quantity Available	WallpaperQuantityAvailable	Choice	NA
Wallpaper Price	WallpaperPrice	Choice	NA
Wallpaper Is Available	WallpaperIsAvailable	Yes/No	Yes

This is how we have created our custom SharePoint list.

Example-15: Wallmurals List

As per the requirement of our client, we need to store all basic information about Wallmurals which are manufactured by the company, including their ID, Name, Material, Size, etc. For this we have created a ‘Wallmurals’ custom SharePoint online list and created columns as shown below:

Let’s see the list of columns and their data types, that we have used in the above SharePoint list as shown below:

• Wallmural ID: Here, we have renamed the default ‘Title’ column to Wallmural ID.
• Wallmural Name: We have taken a ‘single line of text’ data type column to store the wall murals’ names.
• Wallmural Available in 2 Sizes: Here, we have created the ‘Multiple lines of text’ data type column to describe what are the 2 sizes of wall murals briefly as listed below:
  • 9 ft tall x 10 ft wide – consists of 5 strips of wallpaper, each measuring 2ft wide.
  • 9 ft tall x 6 ft wide – consists of 3 strips of wallpaper, each measuring 2ft wide.
• Wallmural Material: We have created the ‘choice‘ data type column for the material such as Peel & Stick or Premium Paper, so that, users can select as per their needs.
• Wallmural Size: For this, we have created the ‘choice’ data type column. This will provide different sizes of wall murals. (i.e 6 ft wide and 10 ft wide).
• Wallmural Quantity Available: Here, we have created the ‘Number’ data type column to have a record of the wall murals available in stock.
• Wallmural Price: For this, we have created the ‘choice’ data type column because the price depends on the material and size of the wall mural.
• Wallpaper Is Available: We have taken the Yes/No data type column. It shows whether the item is available or not. The default value of this column is Yes if we didn’t select the option it will by default takes the option Yes.

Column Name	Internal Name	Data Type	Default Value
Wallmural ID	WallmuralID	Single line of text	NA
Wallmural Name	WallmuralName	Single line of text	NA
Wallmural Available in 2 Sizes	WallmuralAvailablein2Sizes	Multiple lines of text	NA
Wallmural Material	WallmuralMaterial	Choice	NA
Wallmural Size	WallmuralSize	Choice	NA
Wallmural Quantity Available	WallmuralQuantityAvailable	Choice	NA
Wallmural Price	WallmuralPrice	Choice	NA
Wallpaper Is Available	WallpaperIsAvailable	Yes/No	Yes

This is how we have created our custom SharePoint list ‘Wall murals’.

Example-16: Floormats List

As per the requirement, we need to store all basic information about the floormats which are manufactured by the company, including their ID, Name, Price, Color, etc. For this we have created a ‘Floormats’ custom SharePoint online list and created columns as shown below:

Let’s see the list of columns and their data types, that we have used in the above SharePoint list as shown below:

• Floormat ID: Here we have renamed the default ‘Title’ column to Floormat ID.
• Floormat Name: We have taken a ‘single line of text’ data type column to store the wallpapers’ names.
• Floormat Size: For this, we have taken the ‘choice’ data type column. This will provide different sizes of Floormats such as 20in.*30in. , 3ft * 7ft, 4ft * 6ft, etc.
• Floormat Color: Here, we have taken a ‘choice’ data type column that contains different types of colors for the floormat such as BlueGreen, YellowGreen, Royal, Moon, etc.
• Floormat Price: For this, we have created the ‘choice’ data type column because the price of a floormat depends on the color, material, and size.
• Floormat Quantity Available: Here, we have created the ‘Number’ data type column to have a record of the floormats in stock.
• Floormat Is Available: We have taken the Yes/No data type column. It shows whether the item is available or not. The default value of this column is Yes which means if we didn’t select the option it will by default takes the option Yes.

Here we have created a table that contains the name of the column, the internal name of the column, what data type we used, and what is the default value of the column.

Column Name	Internal Name	Data Type	Default Value
Floormat ID	Title	Single line of text	NA
Floormat Name	FloormatName	Single line of text	NA
Floormat Size	FloormatSize	Choice	NA
Floormat Color	FloormatColor	Choice	NA
Floormat Price	FloormatPrice	Choice	NA
Floormat Quantity Available	FloormatQuantityAvailable	Choice	NA
Floormat Is Available	FloormatIsAvailable	Yes/No	Yes

This is how we have created our custom SharePoint list ‘Floormats’.

In this SharePoint online tutorial, I have explained 16 lists that we have created for various companies like Mitchell Black, Dutch Crafters, Mercy Hospitals, and RENA technologies based out in the United States of America. Below are examples of SharePoint Online lists.

1. Semiconductor Clients list
2. Semiconductor Products list
3. Semiconductor Transaction details list
4. Semiconductor Issue Tracker list
5. Doctors List
6. Careers List
7. Patients List
8. Services List
9. Furniture Types List
10. Customer Details List
11. Order Forms List
12. Company Details List
13. Employee Directory List
14. Wallpapers List
15. Wallmurals List
16. Floormats List

You may also like the following tutorials:

• Rename a SharePoint Online List
• Format a SharePoint Online List Column using JSON
• SharePoint list calendar view formatting
• How to sort columns in a SharePoint Online list?