Why agreements need their own place rather than a folder
Contracts behave differently from the rest of a company’s documents, which is why they outgrow a shared drive first. They have counterparties, dates that matter, money attached, and a small number of people who are allowed to see them. A folder can hold them; it cannot tell you which ones renew in the next ninety days, who owns the relationship, or whether the version you opened is the one that got signed. That is the gap this build closes, on the Microsoft 365 licenses you already pay for rather than on a separate platform with its own seats and its own login.
This is a narrower engagement than our general SharePoint intranet and document management consulting, which designs the information architecture for a whole company’s content. Here there is one named system, one named owner in legal, finance or operations, and a scope that ends at a working contract repository with alerting, routing and access rules around it. It is also written for an ordinary company managing its own supplier and customer agreements. If your firm’s product is legal work — client matters, conflicts, ethical walls, retention tied to matter close — the structure is genuinely different and our SharePoint consultant for law firms engagement is the one to read instead.
The fields decide whether any of it works
Everything downstream — the alerts, the views, the reporting, the access rules — is only as good as the fields on each record. Get them agreed in a room in an afternoon and the rest is configuration. Skip that conversation and you get a library with a search box, which is the shared drive again with extra steps. In SharePoint these fields are columns on a content type, and Microsoft’s guidance on adding columns to a content type (opens in new tab) covers the mechanics, including making a column required so a record cannot be saved without it.
| Field |
What it lets you do |
Where the value usually has to come from |
| Counterparty |
Pull every agreement with one company into a single view before a renegotiation, a dispute or a credit decision |
A picklist tied to your customer and supplier names, so the same company is not filed three ways |
| Agreement type |
Separate the NDA from the master agreement from the order form, and apply different approval routes to each |
A short agreed list, set once; long lists are where classification quietly stops happening |
| Internal owner |
Give every alert a person to go to, and make an unowned agreement visible as a gap rather than a silence |
A people field, reviewed when someone leaves — the single most common cause of a missed deadline |
| Start and end dates |
Answer “what is live right now” without opening anything, and drive every date-based alert |
The document itself; in a back catalogue, often re-keyed by hand from the signature page |
| Renewal behavior |
Distinguish an agreement that renews itself from one that simply ends, which are opposite risks |
The termination clause — the field people most often assume they will remember |
| Notice period |
Work backwards from the end date to the real deadline, which is when notice must be served, not when the term expires |
The document; stored as a number of days so a flow can calculate with it |
| Status |
Keep drafts, in-review, out-for-signature and executed agreements distinguishable in one library |
Set by the workflow rather than typed, so it stays honest |
Two fields do most of the work and both are frequently missing: renewal behavior and notice period. An agreement that auto-renews on a sixty-day notice period has its real deadline two months before the date anyone has written in a calendar. Storing the notice period as a number rather than as a sentence in the document is what lets a flow do that arithmetic for you every morning.
The renewal you did not mean to sign
The expensive failure in contract management is rarely a lost document. It is a supplier agreement that rolled over for another year because nobody served notice in time, or a customer agreement that lapsed because nobody started the renewal conversation. Both are calendar failures, and both are what the alerting exists to prevent.
Mechanically it is a scheduled cloud flow: it runs on a recurrence you set in Power Automate (opens in new tab), reads the contract list, and selects the records whose notice deadline falls inside the warning window. The judgement is in the design, not the plumbing: how far ahead the first warning goes out, whether there is a second and a third, who is copied when the owner does not respond, and what the flow does when an agreement has no owner at all. We set those with you, and we write the escalation path down rather than relying on the first email being read.
One production note worth insisting on: the flow’s connections should be owned by a service account rather than by whoever built it, so the alerting survives that person leaving. It is a five-minute decision at build time and an outage nine months later if it is skipped.
Review, approval, and getting to a signature
Approval routing here is deliberately ordinary. Power Automate’s approval actions (opens in new tab) handle sequential and parallel sign-off, reminders and timeouts, and if you want to understand the mechanics before you buy anything, our guide to replacing email approvals with Power Automate walks through building one step by step. We are not re-teaching that here. What this engagement adds is the contract-shaped part: which agreement types need legal review at all, where a value threshold changes the route, what happens when a counterparty returns a marked-up copy, and how the decision is written back so the record shows who approved what and when. Where approvals across the business are the wider problem rather than contracts specifically, that is the remit of our Power Automate consulting engagement.
Signature is the handoff most builds get wrong by leaving it manual. Microsoft’s own eSignature service (opens in new tab) sends requests from a document in SharePoint, keeps an audit trail, and files the completed copy back — and it also integrates Adobe Acrobat Sign and Docusign, so a company already standardized on one of those keeps it. Be aware of two honest constraints: the Microsoft service is billed through a pay-as-you-go Azure subscription rather than included in a seat license, and an external signer needs guest access to the document, which means your external sharing settings have to permit it. Both are decisions to make during scoping, not surprises to discover in week three.
Who sees which agreements
This is the part that takes the longest to agree and the least time to build. Contracts are one of the few document sets where “everyone in the company” is the wrong answer and “three people in finance” is also the wrong answer. The workable pattern is usually a restricted library holding the full set, filtered views that give each team the agreements behind its own accounts, and a written list of the exceptions you decided to make deliberately.
What makes that maintainable is groups rather than individuals, which is also what keeps it reviewable a year later. Microsoft’s reference on permission levels in SharePoint (opens in new tab) sets out how inheritance flows from site to library to item and what each level actually grants — worth reading before anyone proposes per-item permissions, which are easy to create and miserable to audit at volume. If the wider estate already has years of broken inheritance and stale sharing links behind it, that is a separate and larger job: our SharePoint governance consulting services deal with the estate-wide version, and it is worth doing first if the contract library would otherwise inherit the mess.
Retention is the same conversation one step further on. Most companies want executed agreements kept for a defined period after expiry rather than forever or until someone tidies up, and Microsoft Purview retention policies and labels (opens in new tab) are what enforce that without anyone remembering to. We configure it where you have a rule; where you do not have one yet, we say so and leave it out rather than inventing a schedule on your behalf.
What your licenses already cover, and what does not
Most of this system runs on things you are already paying for. Microsoft documents a reference contract management solution built on Microsoft 365 (opens in new tab) whose SharePoint, Teams and Power Automate components are available with the Business and Enterprise plans companies typically hold. The two pieces that carry their own cost are the optional ones, and we would rather set that out plainly than let it surface after signature. Which of the automation stays inside your existing rights is worth checking against our note on Power Automate licensing for small business during scoping.
| Component |
How it is delivered |
Cost beyond the licenses you hold |
| Contract library, fields and views |
A SharePoint document library with a contract content type and per-team views |
None — part of the SharePoint entitlement in standard Microsoft 365 business and enterprise plans |
| Renewal and expiry alerting |
A scheduled Power Automate flow reading dates and notice periods, emailing the named owner |
None where the build stays on the standard connectors your plan includes |
| Review and approval routing |
Power Automate approval actions, sequential or parallel, writing the decision back to the record |
None on standard connectors; premium connectors or Dataverse-backed approvals are a licensing question we raise in scoping |
| Electronic signature |
Microsoft 365 eSignature from the document in SharePoint, or your existing Adobe Acrobat Sign or Docusign account |
Chargeable either way — Microsoft bills eSignature transactions through a pay-as-you-go Azure subscription; third-party providers bill their own way |
| Automatic field extraction from PDFs |
Document processing models that read values such as counterparty and dates out of the file |
Chargeable, and genuinely optional — billed pay-as-you-go, and worth it only at a volume most small companies do not reach |
| Reporting on the portfolio |
SharePoint views for day-to-day questions; a Power BI report where leadership wants the whole picture |
Views cost nothing; a published Power BI report needs the relevant Power BI licensing, which we flag before building one |
When a dedicated product is the better buy
There is a real line here and we would rather draw it than argue past it. A category of contract lifecycle products exists, several of them built on top of SharePoint, and for some companies they are the right purchase. Buying one is sensible when the requirements below describe you; building this is sensible when they do not.
| If this describes you |
The honest answer |
| You need clause-level drafting from an approved clause library, with redline comparison and fallback positions |
Buy a contract lifecycle product. That is a genuinely specialised capability and rebuilding it natively would cost more than licensing it |
| A legal team negotiates continuously, at volume, as its main job |
Buy. The workflow depth and the negotiation tooling will earn their keep quickly at that volume |
| You need obligation tracking against milestones and deliverables across a large portfolio |
Buy, or scope something considerably larger than this engagement with clear eyes about what it will take |
| You mainly need to find agreements, know when they renew, route them for approval and control who sees them |
Build it here. This is the common case, and it runs on licenses you already hold with no new vendor, no new login and no per-seat cost |
| You are not sure yet, and the current system is a shared drive |
Build this first. It is faster to stand up, and the field discipline it forces is exactly the requirements document you would need before buying anything |
Who this fits, and who it does not
The usual fit is a company of roughly 20 to 500 people already on Microsoft 365, managing somewhere between a few dozen and a few thousand of its own agreements, where one person in legal, finance or operations has inherited the job of knowing where things are. The trigger is almost always a specific event: an agreement that auto-renewed unnoticed, a due-diligence request that took a week to answer, an insurer or customer asking for something nobody could find, or a departure that took the only mental index of the contracts with it.
Two adjacent cases are worth naming so nobody buys the wrong build. If the documents that need controlling are your own quality procedures and work instructions rather than commercial agreements with other companies, the structure is different and our SharePoint ISO 9001 document control engagement is the one that fits. And if the records that need structure are about your own employees — personnel files, leave requests, self-service forms and who is allowed to open whose documents — the fields and the permission model are different again, which is what our SharePoint HR management system engagement builds. This page is about agreements you sign with someone else. It fits badly in two cases and we will say so at the consultation rather than after. If nobody will own the system, it will decay exactly like the folder it replaced, and the honest answer is to settle the ownership question first. And if the agreements themselves are still scattered across personal drives and email with no agreement about which copy is authoritative, that reconciliation is real work that has to happen either before or as an explicit part of the scope — it is never free, and a build that pretends otherwise is the one that stalls in week two.
Everything produced is yours from day one: the library, the fields, the flows and the documentation live in your own Microsoft 365 tenant, never in ours. The system is ordinary SharePoint and ordinary Power Automate, so any competent Microsoft partner — or your own team, after the walkthrough — can change it later without us. How the fixed fee is set and what is agreed before work starts is spelled out on our fixed-fee process page.