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: Semiconductor Clients list
We have created this list for RENA technologies, a company based out in the United States of America.
Based on the business scenario, the client wanted to store the Semiconductor clients list in SharePoint Online. They wanted to store information like Client ID, Client Names, Contact Information, Client Addresses, etc. For that we have created a custom SharePoint list and created columns like the below:

According to the above columns, you can enter the items in the respective columns of the SharePoint list.
Now we are Describing each one of the Column lists:
- Title: By default, the Title column will be created while creating the list. Based on our requirement, we can rename the Title column. So we rename this column to the Client ID.
- 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 -> https://www.amperescientific.com

- Client Address: This 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 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 which contains information like Column Display Name, Column Internal Name, Data Type, and its 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 what the SharePoint Custom Semiconductor Clients list looks like.
Example-2: Semiconductor Products list
We have created this list for RENA Technologies, a company based out in the United States of America.
Based on the business scenario, the client wanted to store the Semiconductor products list in SharePoint Online. They wanted to store information like Product ID, Product Name, Product Description, and whether it is available or not, etc. For that we have created a custom SharePoint list and created columns like the below:

According to the above columns, you can enter the items in the respective columns of the SharePoint list.
Now we are Describing each one of the Column lists:
- Title: Here, 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 Multiple lines of text type column in which we have saved the purpose of the product as a 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 which contains information like Column Display Name, Column Internal Name, Data Type, and its 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 Semiconductor Products list looks like.
Example-3: Semiconductor Transaction Details list
Similarly, we have created this list for RENA technologies, a company based out in the United States of America.
Based on the business scenario, the client wanted to store the Semiconductor Transaction Details in the SharePoint Online list. They wanted to store information like Transaction ID, Product ID, Supplied Product, Product Supplied Date, Product Cost, the product delivery person, and whether it is paid or not, etc
As per the above examples of the SharePoint list, (i.e, Semiconductor Clients list and Semiconductor Products list), now we are going to create a SharePoint list based on Semiconductor Transaction Details. Where an individual company (Client) purchases a product. Where we retrieve information from one list to another by linking with the Semiconductor Clients list and the Semiconductor Products list.
We will create Semiconductor Transaction Details by using the Lookup column. For that we have created a custom SharePoint list and created columns like the below:

According to the above columns, you can enter the items in the respective columns of the SharePoint list.
Now we are Describing each one of the Column lists:
- Title: Here, 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. Based on our requirement, we can also rename this column to the Supplied Product.
- 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 which contains information like Column Display Name, Column Internal Name, Data Type, and its 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 |
This is what the SharePoint Custom Semiconductor Transaction Details list looks like.
Example-4: Semiconductor Issue Tracker
Here, we have also created this list for RENA technologies, a company based out in the United States of America.
Based on the business scenario, the client wanted to store the Semiconductor Issue Tracker Details in the SharePoint Online list. They wanted to store information like Issue ID, Issue, Issue Description, Issue Status, the Issue Assigned person, and whether it is still active or not, etc. For that we have created a custom SharePoint list and created columns like the below:

According to the above columns, you can enter the items in the respective columns of the SharePoint list.
Now we are Describing each one of the Column lists:
- Issue ID: Here, 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 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 we have saved the information of the Issue Status, that the issue is In Progress, Completed, or won’t Fix. We gave the choices as In Progress, Completed, and won’t Fix. Where the user can select the choice as per their requirement.
- 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 them 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 which contains information like Column Display Name, Column Internal Name, Data Type, and its 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 |
This is what the SharePoint Custom Semiconductor Issue Tracker list looks like.
Example-5: Doctors List
We have created this list for Mercy Hospitals, a company based out in the United States of America.
According to the requirements from the client, we wanted to create Doctor related information in a SharePoint Online list. They wanted to store information like Doctor ID, Doctor Name, Contact number, Address, Education, etc. For this we have created a custom SharePoint list and created columns like the below:
- 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 are Internal medicine, ENT, Cardiology, Neurology, Oncology, Nephrology, Anesthesia, and Optometry with a display option as a Drop-Down Menu.

- 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 Gearicon-List settings-Rating settings).
- From the Rating settings, where 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 List and List Columns of the Mercy Hospitals site.

This is what the Doctor’s list of a Mercy Hospitals site looks like after creating the List.
Example-6: Services List
We have created this list for Mercy Hospitals, a company based out in the United States of America.
According to the requirements from the client, we wanted to create Services provided in the hospital and related information in a SharePoint Online list. They wanted 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 named-‘ServiceName‘ to store the information of services provided at the hospital.
- Service Type: Here, we have created a choice column named-‘Service Type‘, and the chosen values are Test, Treatment, and Service line, Medication, Self-care Practices, Chemotherapy, and Surgery. 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).
- 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 |
This is the Overview of the List (Services) and List Columns of the Mercy Hospitals site.
Example-7: Careers List
We have created this list for Mercy Hospitals, a company based out in the United States of America.
According to the requirements from the client, we wanted to create Career opportunities provided in the hospital and related information in a SharePoint Online 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 Doctor ID where the Data type is automatically taken as a Single line of text.
- Job Role: This is created as a Single line of text named-‘Job Role’ to store the information of JobsRole at the hospital.
- Job Description: This is created as multiple lines of text named- ‘Job Description ‘to store the information of Job Description Related to the particular Job Role at the hospital. In the multiple lines of text, more than 255 characters are used.
- Experience Level: We have created a single-line text column named –‘Experience level‘ which is used to store the experience required for the job role’ in the year’s format.
- Posted Date: We have created a Date and Time column named -‘Posted Date’ Where users can select the date from the date picker as per their requirements.
- 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 the following choices like Regular, work from home, and Part-time Where users can select their choices as per their requirements.
- 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 |
This is how we created the SharePoint Custom List in the Mercy Hospitals site i.e,(Careers).
Example-8: Patients List
We have created this list for Mercy Hospitals, a company based out in the United States of America.
According to the requirements from the client, we wanted to create a patient list provided in the hospital and related information in a SharePoint Online 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 ‘PatientID‘where the Data type is automatically taken as a Single line of text as per our requirement.
- 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, and Transgender Where users can select their choices as per their requirements.
- 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-, where users can select their choices as per their requirements.
- 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, where users can select their choices as per their requirements.
- 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 how we created the SharePoint Custom List in the Mercy Hospitals site i.e, (Patients list).
Example-9: Furniture Types List
We have created this list for Dutch Crafters, a company based out in the United States of America.
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 the SharePoint custom list(Furniture Types).
Example-10: Customer Details List
We have created this list for Dutch Crafters, a company based out in the United States of America.
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 |
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
We have created this list for Dutch Crafters, a company based out in the United States of America.
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(Order Forms).
Example-12: Company Details List
We have created this list for Dutch Crafters, a company based out in the United States of America.
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 |
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(Company Details)
Example-13: Employee Directory List
We have created this list for the “Mitchell Black” Custom Made Modern Wall & Floor Decor textile manufacturing company located in the United States of America.
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
We have created this list for the “Mitchell Black” Custom Made Modern Wall & Floor Decor textile manufacturing company located in the United States of America.
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 ‘Wallpapers’.
Example-15: Wallmurals List
We have created this list for the “Mitchell Black” Custom Made Modern Wall & Floor Decor textile manufacturing company located in the United States of America.
As per the requirement of our client, we need to store all basic information about the wall murals 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
We have created this list for the “Mitchell Black” Custom Made Modern Wall & Floor Decor textile manufacturing company located in the United States of America.
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.
- Semiconductor Clients list
- Semiconductor Products list
- Semiconductor Transaction details list
- Semiconductor Issue Tracker list
- Doctors List
- Careers List
- Patients List
- Services List
- Furniture Types List
- Customer Details List
- Order Forms List
- Company Details List
- Employee Directory List
- Wallpapers List
- Wallmurals List
- Floormats List
Bijay Kumar Sahoo is a highly accomplished professional with over 15 years of experience in the field of SharePoint and related technologies. He has been recognized as a Microsoft MVP (Most Valuable Professional) more than 9 times, starting from April 2014, for his exceptional contributions to the SharePoint community. Bijay is also a prolific author, having written two books on SharePoint – “Microsoft Power Platform – A Deep Dive” and “SharePoint Online Modern Experience Practical Guide“. His deep insights into SharePoint are also shared on his popular YouTube channel EnjoySharePoint where he teaches SharePoint to a global audience (From various countries like the United States of America, Canada, the United Kingdom, Australia, New Zealand, etc). Read more…