
A clinic can track staff licences and certificates in a SharePoint list on Microsoft 365, with a Power Automate flow that checks expiry dates every morning and reminds the staff member, then their manager, before anything lapses. The spreadsheet of dates stays the same idea. What changes is that nobody has to remember to open it.
Most practices already know which certificates matter: professional registration, CPR and basic life support, infection control, radiation safety where it applies. The problem is rarely knowing what to track. It is noticing in time.
What should a certification tracker hold?
One list of certificate types, and one list of the certificates each person holds. Keep them separate, so that when a new requirement appears you add one row instead of a new column for every member of staff.
| List | One row per | Holds |
|---|---|---|
| Certificate types | Requirement | Name, which roles need it, how often it renews |
| Staff certificates | Certificate held | Person, type, issue date, expiry date, copy of the certificate |
The copy of the certificate goes in as an attachment, so when an inspector asks, the evidence is next to the date rather than in someone's inbox.
How do the reminders work?
A scheduled flow runs each morning and looks for certificates expiring within the window you choose. It emails the staff member first. If the date gets closer and nothing has changed, it emails their manager too. When the person uploads the renewed certificate and updates the date, the reminders stop on their own.
Agree the timings with the practice manager before building. Sixty days for professional registration and thirty days for shorter courses is a common starting point, but it depends on how long renewals take where you are.
The manager lookup uses Get manager (V2) from the Office 365 Users connector, so reminders follow your Microsoft 365 org chart. If that chart is out of date, fix it first, or the reminders go to the wrong person.
What does the practice manager see?
A single view of who is expiring soon, who has already lapsed, and which roles are missing a required certificate entirely. That last one matters. A gap in a spreadsheet looks like an empty cell. A rule that says "every nurse needs this" turns the gap into a line on the report.
A weekly email summary works well for most managers. Daily is usually too much.
Who can see what?
Staff should see and update their own certificates. Managers see their team. Only the practice manager or HR sees everyone. In a SharePoint list, this is done through a Power App that filters what each person sees, with the list permissions set so staff cannot browse everyone's records directly. If you need strict separation between sites or departments, Dataverse handles that more cleanly than item-level permissions. The choice is explained in Dataverse vs SharePoint Lists.
What licences does this need?
A SharePoint list with the Outlook, Office 365 Users and Teams connectors uses standard connectors only, so Microsoft classes the app as Standard and it runs under most Microsoft 365 business plans. Microsoft sets this out on its page about app license designation (checked November 2026).
Frequently asked questions
Can it remind people by Teams instead of email? Yes. The flow can post a Teams message to the person, or both. Many clinics use email for the first reminder and Teams for the urgent one.
What about locum or agency staff without a Microsoft 365 account? They can be tracked in the same list. Reminders go to their email address and to the manager who books them, since they cannot sign in to the app.
Can it block someone from being rostered if a certificate has lapsed? It can flag them in a report or in your own rota app if that also runs on Microsoft 365. Blocking a separate rostering system depends on whether that system can be connected, which is worth checking first.
We already have the dates in Excel. Do we start again? No. The spreadsheet can be imported into the list once, and then the list becomes the record from that day on.
Getting it set up for your practice
I've built this kind of reminder system for clinics, alongside equipment checks and incident reporting. The clinics and healthcare practices page shows how the pieces fit together. If you want to talk through what your practice tracks today, book a 30-minute call.
Last updated
- Power Automate
- SharePoint
- Healthcare
