📄 Case Study · Flex Contract DB

From email chaos to a centralized contract management system inside Microsoft 365

How a mid-sized distribution company replaced scattered contract files, missed renewals, and manual approval chains with Flex Contract DB — a custom SharePoint app built on SPFx, Power Automate and Power BI, living entirely inside Microsoft 365.

240+ Active contracts managed
€0 Additional software licenses
7 days Implementation time
Faster approval process
Industry Distribution & Logistics
Company size 180 employees
Platform Microsoft 365 · SharePoint · Teams
Solution Flex Contract DB

The Challenge

Before implementing Flex Contract DB, the company managed all contracts through a combination of shared network drives, email threads, and personal folders. There was no unified system — every department handled contracts differently, and the legal and finance teams had no real-time visibility into contract status, expiry dates, or approval history.

"We had contracts expiring without anyone knowing. Renewals were missed, vendors called us before we called them — it was embarrassing and costly."

— Operations Manager

The company was already using Microsoft 365, including SharePoint and Teams, but had no structured way to use these tools for contract lifecycle management. They explored third-party contract management SaaS tools but found them expensive, difficult to integrate, and requiring users to leave their familiar Microsoft environment.

Why Flex Contract DB?

After evaluating several options, the team chose Flex Contract DB because it runs entirely inside their existing Microsoft 365 environment — no new software, no additional licenses, no migration headaches. The app is built on SharePoint Framework (SPFx), which means all data stays in your own tenant. Users work in SharePoint and Teams where they already spend their day.

Flex Contract DB — Dashboard AI Enabled
Contract Dashboard
243Active contracts
17Expiring in 30 days
€4.2MTotal value
Vendor Framework Agreement — LogiPro d.o.o.
Expires 14 Jun 2025 · Procurement
Renewal pending
Software License — ERP System
Expires 30 Sep 2025 · IT Department
In approval
Office Lease — Belgrade HQ
Expires 01 Jan 2026 · Facilities
Active

How Flex Contract DB Works

Flex Contract DB is a custom SharePoint app built on the SharePoint Framework (SPFx). All data and configuration lists are stored in your own SharePoint tenant — no data ever leaves your Microsoft 365 environment. Power Automate handles all automation and notifications, while Power BI provides embedded live reporting without any additional licensing.

Implementation follows a structured process: site collection creation, SPFx package deployment, PnP script setup for lists, and user permission assignment by department or country — typically completed in 7 business days including training.

🔍

All Contracts, Always at Hand

Search by vendor, date, status or value in seconds. Attach, download and share documents directly from the contract record. Full change history tracked automatically.

🔔

Never Miss a Renewal

Automatic alerts at 30, 60 or 90 days before expiry. One-click renewal confirmation from email — no login required. Periodic review reminders keep owners accountable year-round.

📊

Real-Time Visibility

Live Power BI dashboard showing active contracts, upcoming renewals and financial obligations. Vendor performance scorecards. Export to Excel at any time for finance or legal reporting.

🔒

Access Control by Department

Permission management per country or department — people see only what they need. SharePoint groups used for role-based access, configurable without IT support.

📋

Custom Input Forms

Structured contract intake forms with custom fields, multiple attachments, and configurable email templates. Every submission creates a clean, searchable record.

Power Automate Integration

All workflows run via Microsoft Flow — integrates with your existing systems. Contract expiry alerts, renewal confirmations, and owner review reminders are fully automated.

The Results

Six months after go-live, the impact was clear across all departments.

0 Missed contract renewals since implementation
Faster contract approval cycle (from 9 to 3 days avg.)
100% Contracts in one place — full visibility for legal & finance
€0 Extra software costs — runs on existing M365 licenses
7 days From kickoff to go-live, including user training
98% User adoption rate within the first month
"We went live in a week. Our team didn't need to learn any new software — everything is in Teams and SharePoint where they already work. The renewal alerts alone saved us from at least two very expensive mistakes."

— Legal & Compliance Lead

See it in action

Home Page
Overview Home Page
Search
Search Search Contracts
Quick Preview
Preview Quick Preview
Reports
Reporting Report Page
Vendor Score
Analytics Vendor Score

Ready to see Flex Contract DB in action?

Book a free 30-minute live demo and see how your team can have contract management running inside Microsoft 365 within a week.

📅 Book a free demo

Explore other Flex 365 modules