A small business can track its equipment with QR code labels and a Power Apps app on Microsoft 365. Each asset gets a label, staff scan it with their phone to check it out, return it or report a fault, and a SharePoint list keeps the register of what you own, who has it and when it is due for service.
The usual alternative is a spreadsheet that was accurate the day it was made. Six months later it lists laptops that left with former staff and misses the tools bought last quarter.
What should an asset register hold?
One row per asset, with the details you would need to find it, replace it or insure it. Then a separate list of movements, so you have the history of who had what and when.
| List | One row per | Holds |
|---|---|---|
| Assets | Item you own | Asset number, type, serial, purchase date, location, current holder, status |
| Movements | Check-out, return or move | Asset, person, date, from and to location, condition |
| Faults | Reported problem | Asset, description, photo, who reported it |
Keeping movements separate is what turns a list into a history. You can see every person who has used a piece of equipment, not just the last one.
How do QR codes work with Power Apps?
Power Apps has a barcode reader that scans QR codes with the phone camera. You print a label for each asset carrying its asset number. When someone scans it, the app opens that asset's record and offers the actions that make sense: check out, return, move, or report a fault.
Labels can be printed from the list itself in batches. Use durable labels for tools and equipment that get handled roughly.
What can staff do from the scan?
| Action | What happens |
|---|---|
| Check out | Records who took it, when, and when it is due back |
| Return | Clears the holder and asks about condition |
| Move | Updates the location, for items that stay in the business |
| Report a fault | Opens a fault with a photo and notifies whoever looks after it |
What reminders are worth automating?
Three. Items not returned by their due date, service or calibration dates coming up, and warranties about to expire. A scheduled Power Automate flow checks the list each morning and emails the right person. When an employee leaves, a report of everything still checked out to them is worth its weight on the last day.
What licences does this need?
On SharePoint lists with standard connectors, Microsoft classes the app as Standard, so staff can use it under most Microsoft 365 business plans. Microsoft explains the rule on its page about app license designation (checked November 2026).
Frequently asked questions
Can we use existing barcodes instead of QR codes? Often yes. The barcode reader handles common barcode types as well as QR codes, so existing labels may work if each one is unique.
What about expensive equipment that must not leave a site? Mark it as fixed. The app then only allows moves and fault reports for it, not check-outs.
Can it track vehicles? It can track vehicles as assets: who has the keys, mileage at handover, service dates and faults. It does not do live GPS tracking. That needs a telematics product.
We already have a spreadsheet. Do we start over? No. The spreadsheet is imported into the list once, labels are printed from it, and the list becomes the register from then on.
Getting it set up
This uses the same pattern as the equipment register in Clinic Equipment Checks and Maintenance, adapted for whatever you own. If you want to talk through what you need to track, book a 30-minute call.
Last updated
- Power Apps
- SharePoint
- Small Business
