
A small business can manage inventory on Microsoft 365 with a Power Apps app where staff count stock on a phone, scanning barcodes or picking items from a list, and a SharePoint list that holds each item's quantity per site. Power Automate sends a reorder alert when an item drops below its minimum level, and the manager sees every location's stock on one screen.
Most small businesses count stock on a printed sheet, type it into a spreadsheet later, and find out they are short when someone opens an empty box.
What should a small inventory app cover?
| Part | What it does |
|---|---|
| Item list | Name, unit, barcode, minimum level, supplier |
| Stock per site | How many of each item each branch or store room holds |
| Stock count | Staff count on a phone and the app records the difference |
| Movements | Stock in, stock out, transfers between sites, write-offs |
| Reorder alert | A message when an item falls below its minimum |
| History | Who changed what, and when |
Start with the item list and the count. Movements and transfers can come in the second version, once people are counting reliably.
How does a stock count work on a phone?
The person counting opens the app, picks their site and area, such as the dry store or the cold room, and goes shelf by shelf. They scan an item's barcode with the phone camera, or tap it in the list, and enter the quantity. Power Apps has a barcode reader control for this, which reads common barcodes and QR codes.
When the count is submitted, the app compares it with the expected quantity and flags big differences for the manager to check. That one step catches most of the waste and theft questions owners actually ask.
How do reorder alerts work?
A Power Automate flow checks quantities after each count or movement. When an item drops below its minimum, it sends the person who orders a message in Teams or by email, with the item, site, current quantity and usual supplier. It can also create a draft purchase request, which can go through the approval described in Supply and Purchase Requests Between Restaurant Branches.
Can it handle several branches?
Yes. Each record carries the site, so one item list serves every branch, and each manager sees only their own site if you want it that way. Transfers between branches are recorded as one movement out and one in, so stock never disappears between locations.
When is this the wrong tool?
If your point of sale or accounting software already tracks stock well, use that, and keep Power Apps for the parts it doesn't cover, such as counts in the store room. An app like this suits consumables, kitchen stock, spare parts and equipment. It is not a replacement for an e-commerce inventory system that has to sync with an online shop.
What licences does it need?
On SharePoint lists with standard connectors, the app is a Standard app and runs under most Microsoft 365 business plans, as set out on Microsoft's page about app license designation (checked November 2026). A large catalogue with many sites, or a link to accounting software through a premium connector, may push you to Dataverse. How Much Does a Power App Cost? covers what that changes.
Frequently asked questions
Do I need special barcode scanners? No. A phone camera is enough for most small businesses. Dedicated scanners help when one person scans hundreds of items a day.
What if our items have no barcodes? Print your own QR labels for shelves or items, in batches from the item list, the same way as in Asset Tracking for Small Businesses with QR Codes and Power Apps.
Can we count stock without signal in a cold room or basement? It can be built to work offline in the Power Apps mobile app, with some conditions on how the data is stored. They are covered in How to Build an Inspection App in Power Apps.
Can it track expiry dates? Yes. Recording a batch and expiry date on stock in lets a scheduled flow warn you before items expire.
Getting it set up
The restaurants and hospitality page shows how stock counts fit with daily checklists and supply requests. If you want to talk through how stock is counted in your business today, book a 30-minute call.
Last updated
- Power Apps
- Power Automate
- Small Business
