Create a SharePoint List for Asset Tracking: Practical Checklist for SharePoint Owners

Asset tracking in SharePoint helps you manage hardware, software, and equipment from a single location. Many SharePoint owners start with a blank list and struggle to structure fields that match their real-world inventory. This article covers the essential columns, views, and settings you need to build a practical asset tracking list. You will learn how to set up custom fields, apply conditional formatting, and create views that surface the most important information.

Understanding the Asset Tracking List Feature

A SharePoint list is a structured container that stores rows of data, similar to an Excel table but with built-in permissions, version history, and integration with Power Automate. For asset tracking, the list replaces a physical logbook or a spreadsheet that multiple people edit at the same time. The key advantage is that each asset gets a permanent record with a unique ID, and you can control who edits which fields.

Before you begin, confirm that you have at least Edit or Full Control permissions on the site where the list will live. You need the SharePoint site owners group or higher to create a new list. If your organization uses a site template that restricts list creation, contact your tenant administrator to adjust the site permissions.

Steps to Create and Configure the Asset Tracking List

This process uses the modern SharePoint list experience available in all SharePoint Online plans and SharePoint Server Subscription Edition.

1. Create a blank list
   Navigate to the SharePoint site where you want the asset list. Select New > List > Blank list. Name it Asset Tracking and set the description to Track hardware, software, and equipment inventory. Choose whether to show this list in the site navigation. Select Create.
2. Add the Title column description
   By default, every list has a Title column. Rename it to Asset Name by selecting the column header > Column settings > Rename. Type Asset Name and press Enter. This column holds the friendly name of each item, such as Dell Latitude 5420 or Office 365 License.
3. Add a single line of text column for Asset Tag
   Select + Add column > Single line of text. Name it Asset Tag. Set the maximum number of characters to 50. Enable Require that this column contains information to make it mandatory. This column stores a unique identifier like IT-2025-001.
4. Add a single line of text column for Serial Number
   Add another single line of text column named Serial Number. Set it to required. Use column validation to ensure uniqueness: select Column settings > Column validation. In the formula box enter =NOT(ISBLANK([Serial Number])) and set the user message to Serial number must not be blank. For true uniqueness, use Power Automate to check for duplicates on item creation.
5. Add a Choice column for Category
   Select + Add column > Choice. Name it Category. Enter these options: Laptop, Desktop, Monitor, Peripheral, Software License, Furniture, Network Equipment, Other. Set Default value to Other. Enable Display choices using > Drop-down menu.
6. Add a Location column
   Add a single line of text column named Location. This holds the physical or virtual location, such as Building A, Room 204 or Cloud – Azure. Make it required.
7. Add a Status column
   Add a Choice column named Status. Options: In Service, Checked Out, Under Repair, Retired, Lost. Set default to In Service. This column drives conditional formatting later.
8. Add a Person or Group column for Assigned User
   Add a Person or Group column named Assigned To. Set it to allow multiple selections: No. This column links the asset to a specific employee. You can filter views by this column to see who has what.
9. Add a Currency column for Purchase Cost
   Add a Currency column named Purchase Cost. Set the currency symbol to your local currency. This column helps with budget reporting. You can total this column in a view.
10. Add a Date and Time column for Purchase Date
    Add a Date and Time column named Purchase Date. Set the format to Date only. This column tracks warranty and depreciation schedules.

Create a View for Active Assets

1. Open the view switcher
   At the top of the list, select All Items (current view) > Create new view. Name it Active Assets. Set the view type to List.
2. Apply a filter
   In the view settings, scroll to Filter. Select Show items only when the following is true. Choose column Status, operator is not equal to, and value Retired. Add another condition: And > Status is not equal to Lost.
3. Choose columns to display
   In Columns, remove columns you do not need in this view: Attachments, ID, Modified, Created. Keep: Asset Name, Asset Tag, Serial Number, Category, Location, Status, Assigned To, Purchase Cost, Purchase Date.
4. Sort by Asset Name
   Set Sort to Asset Name ascending. Select OK to save the view.

Add Conditional Formatting to Highlight Issues

1. Open JSON formatting for the Status column
   In the list, select the Status column header > Column settings > Format this column. The JSON formatting pane opens.
2. Paste the JSON code
   Clear the default code and paste this:
   {
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"background-color": "=if(@currentField == 'Checked Out', '#fff3cd', if(@currentField == 'Under Repair', '#f8d7da', if(@currentField == 'Lost', '#dc3545', '')))",
"color": "=if(@currentField == 'Lost', 'white', 'black')",
"padding": "4px 8px",
"border-radius": "4px"
}
}
   This highlights Checked Out in yellow, Under Repair in light red, and Lost in dark red with white text.
3. Apply and test
   Select Save. Add a test item with Status set to Under Repair and confirm the cell background changes to red.

Common Mistakes and Limitations to Avoid

Duplicate Asset Tags Appear in the List

SharePoint list column validation cannot enforce uniqueness across all rows. To prevent duplicates, use a Power Automate flow that triggers on item creation and checks the list for an existing Asset Tag value. If a match is found, the flow can reject the item or send a notification. Alternatively, use the Asset Tag column as the List ID by setting it to auto-increment via a workflow, but this requires custom development.

Users Cannot Find Assets by Location

If you store location as free text, users may type Bldg A, Building A, or A for the same place. Use a Choice column for Location instead, or create a separate Locations list and use a Lookup column. This ensures consistent filtering and reporting.

Checkout Status Does Not Sync with Assigned User

The Status column and the Assigned To column are independent. If someone marks an item as Checked Out but does not assign a user, the asset appears checked out with no owner. Use column validation or a Power Automate flow to require Assigned To when Status is Checked Out. For example, set a column validation formula on the list: =IF([Status]="Checked Out", NOT(ISBLANK([Assigned To])), TRUE).

Item	Spreadsheet	SharePoint List
Data entry	Anyone can edit any cell	Permissions control who edits each row or column
Version history	Not available unless saved manually	Automatic version tracking for every edit
Unique IDs	No built-in unique identifier	List ID column auto-increments and is permanent
Mobile access	Requires app or file sync	SharePoint mobile app shows list views natively
Automation	Limited to macros and VBA	Power Automate can send emails, create tasks, update records

You now have a working asset tracking list with mandatory fields, a filtered view for active items, and conditional formatting that draws attention to assets needing action. Next, set up a Power Automate flow that emails the assigned user when an asset status changes to Under Repair. For advanced reporting, export the list to Power BI and create a dashboard showing asset distribution by category and location.