SharePoint Online List Examples [15 Real Examples]

In this SharePoint tutorial, you will learn practical SharePoint Online list examples that you can directly use in real projects. These examples are based on real client requirements and use different column types, lookup columns, ratings, and more.

SharePoint List Examples

Below are examples of SharePoint Online lists.

Example-1: Client list

A US-based client wanted to maintain a structured list of their customers, including key details such as contact information, addresses, and status.

Business requirement

Store information like:

• Client ID
• Client Name
• Contact Information
• Client Address
• Whether the client is still active
• Rating for the client relationship

Here is what the SharePoint list looks like:

Here are the column details:

• ​Client ID (Title) – Default Title column renamed to store a unique Client ID (Single line of text).
• Client Name – Single line of text for the client’s name.
• Client Phone Number – Number column for contact numbers. Disable Use thousands separator in More options.
• Client Website – Hyperlink column to store website URL.
• Client Address – Location column with linked fields such as Street, City, State, Country/Region, and Postal Code.
• Is Still Client Active – Yes/No column to track active/inactive clients.
• Client Rating – Rating column (0–5 stars) configured from List settings → Rating settings.

Here is a screenshot of the Client Phone Number column that we created using the number data type. By default, it uses a comma as the 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 column stores the client’s location. Also, it shows linked columns in the current view contain additional information to show, such as Street Address, City, State, Country or Region, Postal Code, Coordinates, Name, etc

• Is Still Client Active: This is a 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.

Schema overview:

This list is ideal as a master client database that other lists (like Orders or Transactions) can reference via lookup columns.

Check out Add Attachments Column in SharePoint List

Example-2: Product list

Here is another SharePoint Online list example. This list stores product catalog information used in orders, transactions, and reporting:

Business requirement

• Product ID
• Product Name
• Product Description
• Cost, Quantity
• Availability and rating

​Recommended columns

• Product ID (Title) – Default Title column renamed to Product ID.
• Product Name – Single line of text.
• Product Description – Multiple lines of text for detailed descriptions.
• ​Product Cost – Currency column (e.g., US currency).
• Product Quantity – Number column; disable thousands separator.
• Is Product Available – Yes/No column.
• Product Rating – Rating column added from Rating settings

The SharePoint list with a few records looks like this:

This list can act as the master product catalog for orders and transaction lists.

Check out SharePoint list conditional formatting based on a date

Example-3: Transaction Details list

This list links clients and products together to track individual transactions.

Business Requirement:

Capture:

• Transaction ID
• Product information
• Supplied date and cost
• Client details
• Delivery person
• Payment status and digital payment flag

Recommended columns

• Transaction ID (Title) – Default Title column renamed.
• Product ID – Lookup column to the Products list (source: Product ID).
• Supplied Product (Product ID: ProductName) – Lookup column pulling Product Name from Products list.
• Product Supplied Date – Date and Time column.
• Product Cost – Currency column.
• Client ID – Lookup column referencing the Clients list.
• Product Delivery Person – Person or Group column.
• Is Paid Or Not – Choice column with values like Paid, Balance, Draft.
• Digitally Paid – Yes/No column

Schema overview

This is how the SharePoint list looks:

Read Create Shortcuts in SharePoint Document Library

Example-4: Issue Tracker

A classic requirement is to track issues or defects against products, services, or projects.

Business requirement

Track:

• Issue ID
• Issue title and description
• Status and assignee
• Screenshot or image
• Active flag and resolved date

Schema overview:

This list can easily be extended with priority, category, or SLA fields as your process matures.

Check out SharePoint Online List Lookup Column

Example-5: Doctors List

For a healthcare client, this SharePoint list stores detailed information about doctors.

Business requirement

Store:

• Doctor ID
• Name and contact details
• Education and certifications
• Address and languages
• Specialty, experience, and rating

Schema overview:

This list works well as a master doctor directory used by appointment, services, and patient lists.

Check out SharePoint Online list view

Example-6: Services List

This list stores the services a hospital or clinic provides and links them to specialized doctors.

Business requirement

Track:

• Service ID and name
• Service type
• Primary care and disease type
• Specialized doctor
• Health insurance and cost

Schema overview:

This structure makes it easy to filter services by disease type or insurance availability.

Read SharePoint Online List Permissions

Example-7: Careers (Jobs) List

This SharePoint list manages job openings and career opportunities.

Business requirement

Store:

• Job ID and role
• Description
• Experience level
• Posted and expiry dates
• Location, job type, vacancies, and CTC

Schema overview:

This list can be surfaced in a careers page or connected to an application form using Power Apps.

Check out SharePoint List Calendar View Formatting

Example-8: Patients List

A patient registry for storing basic demographic and contact information.

Business requirement

Track:

• Patient ID and name
• Age and gender
• Blood group and disease type
• Contact info and permanent address

Schema overview:

This list can be joined with appointments or admissions lists via lookup columns.

Check out Format a SharePoint Online List Column using JSON

Example-9: Furniture Types List

For a retail/manufacturing client, this SharePoint list stores furniture catalog details.

Business requirement

Track:

• Furniture ID and name
• Features and category
• Color, price, quantity
• Locations, style, and image

Schema overview:

This list can feed both internal dashboards and public product catalogs.

Check out SharePoint Online Site Date Format

Example-10: Customer Details List

This SharePoint Online list keeps core customer information that can be reused across orders and support lists.

Business requirement

Store:

• Customer ID and name
• Gender and contact numbers
• Email and permanent address

Schema overview:

Use this SharePoint list as a central customer master to reduce duplication across sites.

Check out SharePoint User Information List

Example-11: Order Forms List

This SharePoint list records customer orders for furniture.

Business requirement

Track:

• Customer and furniture references
• Order and delivery dates
• Quantity, payment type, discount, quality, delivery, rating

Schema overview:

This list gives a complete view of each order, including customer satisfaction through the rating column.

Check out Validate Phone Number Column in SharePoint

Example-12: Company Details List

This list stores key information about company locations or branches.

Business requirement

Store:

• Company ID and name
• Opening and closing times
• Contact information and media links
• Location, address, and visitor tracking

Schema overview:

This SharePoint list is useful for intranet directories or location-based navigation.

Check out Gantt Chart View in SharePoint Online Modern List Using JSON

Example-13: Employee Directory List

A centralized employee directory list to store employee details and make people easy to search.

Business requirement

Store:

• Employee ID and name
• Photo
• Email and contact number
• Location, job title, and department(s)

Schema overview

This SharePoint list works very well with modern list formatting or custom people cards.

Read How To Reset Id In SharePoint List

Example-14: Wallpaper List

This list stores wallpaper products with attributes like color, collection, style, size, quantity, and availability.

Business requirement

Track:

• Wallpaper ID and name
• Color, collection, style
• Size, quantity, price, and availability

Schema overview:

This SharePoint list can be reused by order and inventory workflows.

Check out Create and Manage Task List in SharePoint

Example-15: Wallmurals List

This list is similar to wallpapers but focuses on wall murals with predefined sizes and materials.

Business requirement

Track:

• Wallmural ID and name
• Description of available sizes
• Material, size, quantity, price
• Availability status

Recommended columns

• Wallmural ID (Title) – Title renamed.
• Wallmural Name – Single line of text.
• Wallmural Available in 2 Sizes – Multiple lines of text describing the two standard sizes (e.g., 9 ft × 10 ft, 9 ft × 6 ft).
• Wallmural Material – Choice (Peel & Stick, Premium Paper).
• Wallmural Size – Choice (6 ft wide, 10 ft wide, etc.).
• Wallmural Quantity Available – Number or Choice tracking inventory.
• Wallmural Price – Choice column based on size/material combinations.
• Wallpaper Is Available – Yes/No column; default Yes.

Schema overview:

This SharePoint list enables detailed catalog management for wall mural products.

Example-16: Floormats List

This list manages floor mat products with details such as size, color, price, stock, and availability.

Business requirement

Track:

• Floormat ID and name
• Size and color
• Price, quantity, and availability

Recommended columns

• Floormat ID (Title) – Title renamed.
• Floormat Name – Single line of text.
• Floormat Size – Choice (20 in × 30 in, 3 ft × 7 ft, 4 ft × 6 ft, etc.).
• Floormat Color – Choice (BlueGreen, YellowGreen, Royal, Moon, etc.).
• Floormat Price – Choice column (price options by size/material).
• Floormat Quantity Available – Choice or Number for stock.
• Floormat Is Available – Yes/No column; default Yes.

Schema overview:

This SharePoint list is useful for managing store inventory and feeding e-commerce or internal ordering applications.

Conclusion

These SharePoint Online list examples show how to design lists that match real business requirements while using the right mix of column types like Choice, Lookup, Person, Location, Currency, and Rating. Use these schemas as templates and then extend them with list formatting, views, Power Apps forms, and Power Automate flows to build complete business solutions.

You may also like the following tutorials:

• SharePoint Document Library Examples
• SharePoint List vs Library
• SharePoint List Conditional Formatting

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.