The Business Situation

Alderwick Process Equipment is a fictional 85-person distributor and service provider used for this representative case study. Its sales and procurement teams collectively initiate about 90 contracts per month, including nondisclosure agreements, customer master service agreements, statements of work, supplier agreements, data processing agreements, and amendments.

The contract process involves a legal coordinator, two legal reviewers, 12 sales employees, four procurement employees, the Sales Director, the Procurement Manager, an authorized company signatory, and occasional executive approval for higher-value commitments.

Contracts previously arrived in a shared legal inbox. Some messages contained a Word document and a short request such as “please review.” Others included several attachments, unclear versions, incomplete counterparty information, or no target date. Legal staff had to determine who owned the commercial decision, whether company paper had been used, and whether the agreement involved personal data, exclusivity, automatic renewal, unusual liability terms, or a high financial commitment.

The business already used Microsoft 365 and SharePoint for general collaboration. It selected Microsoft Forms for structured intake, SharePoint for contract matter records and files, Power Automate for routing and control, Microsoft 365 Outlook for notifications, and DocuSign for electronic signature.

Note: This case study is provided as a representative example of the types of AI integration and digital transformation solutions Intelligex designs and delivers. Actual engagements are tailored to each client’s goals, constraints, existing systems, timeline, and available resources, so the approach, tools, and outcomes may vary.

The objective was not to automate legal judgment. The objective was to automate intake, assignment, reminders, evidence capture, signature coordination, and archiving while leaving contract interpretation, negotiation, approval, and signing authority with designated people.

The Existing Process

The original contract process followed these steps:

  1. A salesperson or buyer emailed a document to the legal inbox.
  2. The legal coordinator read the email, opened the attachment, and requested missing business information.
  3. The coordinator created a row in a spreadsheet containing the counterparty, requester, contract type, and approximate status.
  4. The attachment was saved to a shared folder, often using the original filename.
  5. A legal reviewer was assigned through a forwarded email or a note in the spreadsheet.
  6. The reviewer exchanged redlines with the requester or counterparty by email.
  7. The requester sought commercial approval separately, usually through email.
  8. After the document was considered final, someone uploaded it to DocuSign or sent it to another employee who had DocuSign access.
  9. The legal coordinator checked periodically to determine whether the envelope had been completed.
  10. The executed PDF was downloaded and saved to a contract folder.
  11. The spreadsheet was updated if the coordinator remembered to do so.

Process weaknesses

  • Requests arrived without required fields.
  • Ownership depended on email context.
  • Filenames did not identify the matter or version.
  • Approvals were distributed across email chains.
  • The spreadsheet and document folders could disagree.
  • Executed copies were not always stored consistently.
  • Reminder activity depended on one coordinator.

Business effects

  • Legal staff spent time gathering information rather than reviewing terms.
  • Urgent requests could not be distinguished reliably from incomplete requests.
  • Employees could accidentally review an outdated version.
  • There was no dependable record of who approved what and when.
  • Sales and procurement lacked reliable status reporting.
  • Absence of the legal coordinator disrupted the process.
  • Renewal and obligation reporting was limited by incomplete metadata.

The process also created governance concerns. Email attachments could be copied into unrelated folders, shared links could remain active longer than necessary, and Power Automate run history did not yet exist as an operational record. The business needed a controlled matter record that connected the request, documents, decisions, signature envelope, and executed agreement.

What the New System Needed to Do

The project team defined the business and technical requirements before configuring any tools.

Contract workflow requirements
Area Requirement Control
Intake Capture the agreement type, counterparty, purpose, value, deadline, template status, risk questions, owner, and source document. Required fields, controlled choices, internal authentication, and file validation.
Record creation Create one contract matter for each valid submission. Unique submission key and generated matter ID.
Ownership Assign a legal reviewer, business owner, approver, and signatory. Routing rules with coordinator override.
Review Route legal and commercial review while preserving document versions. SharePoint version history and recorded approval responses.
Approvals Apply additional approval to higher-value or exceptional commitments. Deterministic thresholds and sequential approval rules.
Signature Create a DocuSign envelope only from an approved final document. Precondition checks and human verification of recipients and signature fields.
Archiving Save the completed agreement and certificate in a restricted archive. Envelope ID matching, naming rules, metadata, and completion checks.
Notifications Notify owners about assignments, required changes, approvals, deadlines, and failures. Power Automate email actions with reminder counters.
Reporting Show volume, status, overdue work, owner workload, and automation failures. Indexed SharePoint views and calculated reporting fields.
Exceptions Preserve partially completed records and support manual recovery. Automation failure list, retry count, error message, and recovery procedure.
Governance Restrict contract access and retain approval evidence. Role-based access, no anonymous links, event logging, and retention rules.
AI Optionally identify and summarize clauses for lawyer review. Structured extraction, source citations, confidence checks, and mandatory human confirmation.

A manual override was required at every consequential stage. The legal coordinator could reassign reviewers, a lawyer could return a document for changes, an approver could reject a commitment, and a signature administrator could stop an envelope before sending it.

Implementation Approaches Considered

Implementation options considered
Approach Connected tools Effort Customization Main limitation
Improve email and spreadsheet controls Outlook, Excel, shared folders Low Low Weak validation, ownership, audit evidence, and duplicate control.
Microsoft productivity suite plus DocuSign Forms, SharePoint, Power Automate, Outlook, DocuSign Moderate Moderate to high Requires disciplined configuration and ongoing flow ownership.
No-code contract database No-code database, automation platform, DocuSign Moderate High Adds another data platform and separate access-governance requirements.
Dedicated contract lifecycle management platform CLM platform, identity provider, CRM, procurement, signature High High Higher implementation effort than the current volume justified.
Custom application Web application, database, APIs, signature service Very high Very high Requires software development, hosting, security, and support capability.

Improving the existing process

Adding an email template and more spreadsheet columns would have reduced some omissions. It would not have enforced intake requirements, connected approval evidence to the correct document, or reliably detected repeated automation events.

Using Microsoft 365 with DocuSign

This approach retained tools already familiar to employees and kept the matter record and documents in SharePoint. Power Automate could connect the intake, approvals, reminders, signature preparation, and archive without introducing a separate business database.

Using a no-code database

A no-code database could provide a more application-like interface and flexible relationships. It was less suitable because contract documents and permissions were already governed through Microsoft 365, and another data repository would have expanded the privacy and administration scope.

Purchasing dedicated contract software

A contract lifecycle management platform would offer stronger clause libraries, obligation management, portals, and legal-specific reporting. At 90 matters per month, the business chose to establish a controlled workflow first and reassess dedicated software when its requirements became more complex.

Building a custom application

A custom application offered the greatest control but created unnecessary hosting, authentication, security testing, release management, and support responsibilities for the representative scenario.

The Selected Solution

Alderwick Process Equipment selected a Microsoft 365-based contract matter workflow connected to DocuSign. Microsoft Forms became the required intake channel. SharePoint became the system of record and document workspace. Power Automate coordinated records, approvals, reminders, signature preparation, status synchronization, and archiving.

Selected tools and responsibilities
Tool Responsibility Why it was retained or selected
Microsoft Forms Internal contract request form and initial file upload. Provides authenticated, structured intake without a custom interface.
SharePoint Contract matter list, approval records, event log, working documents, and executed archive. Supports version history, metadata, permissions, views, and Microsoft 365 governance.
Power Automate Validation, record creation, routing, approvals, reminders, exception handling, DocuSign coordination, and status updates. Connects the selected Microsoft tools and DocuSign through managed connections.
Microsoft 365 Outlook Assignment, reminder, escalation, completion, and failure notifications. Uses existing employee identities and shared legal mailbox.
DocuSign Envelope preparation, electronic signature, completion status, and completion certificate. Separates signature evidence from the contract workflow while returning an envelope identifier.
SharePoint views Operational reporting for queues, deadlines, owners, outcomes, and failures. A separate business intelligence platform was not required for the initial volume.
Optional approved AI service Clause extraction and review assistance. Added only after the rule-based workflow was stable and privacy controls were approved.

The system removed spreadsheet entry, manual folder creation, repeated status emails, manual reminder tracking, and routine archive naming. It did not remove legal review, commercial approval, signature authority, negotiation, or confirmation that the correct final document had been sent.

Counterparty paper required human signature-package preparation because signature fields could appear in different locations. Fixed company templates could later support more automated field placement, but the initial implementation required a signature administrator to inspect every envelope before sending it.

System Architecture and Data Flow

  • Intake: Microsoft Forms used by authenticated employees.
  • System of record: SharePoint Contract Matters list with related Approvals, Event Log, Routing Rules, Delegations, and Automation Failures lists.
  • Automation layer: Power Automate cloud flows with managed connection references.
  • Document storage: SharePoint Contract Workspaces and Executed Contracts libraries.
  • Notifications: Microsoft 365 Outlook using a monitored legal mailbox.
  • Reporting: Indexed SharePoint list views and scheduled summary emails.
  • AI layer: Optional tenant-approved document extraction and generative AI actions with human review.
  1. Submission: An authenticated employee submits Microsoft Forms data and one contract file. The Forms trigger returns the response identifier. Power Automate retrieves the complete response and attachment metadata.

    Failure path: If the response cannot be retrieved, the flow records the response ID in the Automation Failures list and notifies the legal automation owner.

  2. Validation: Power Automate validates required business fields, file type, target date, internal owner, and contract value. It creates a source submission key from the form version and Forms response ID.

    Failure path: Invalid or incomplete requests enter the Intake Exception queue rather than being silently discarded.

  3. Duplicate check: The flow searches the Contract Matters list for the source submission key. An existing key causes the repeated event to end successfully without creating another matter.

    Failure path: A unique-value constraint on the SharePoint column provides a second control if two runs race.

  4. Matter creation: Power Automate creates the SharePoint item and receives the numeric list item ID. It converts that value into a matter identifier such as CT-2026-000147.

    Fields updated: Matter ID, created timestamp, automation status, requester, status, priority, and reviewer assignments.

  5. Workspace creation: SharePoint folders are created for intake, working drafts, review copies, signature preparation, executed documents, and superseded files. The uploaded source file is copied into the workspace using the generated matter ID.

    Failure path: If the folder exists, the flow reuses it. If the file copy fails, the matter remains visible with an Automation Error status and a recovery link.

  6. Routing: Agreement type, department, value, template status, and deterministic risk answers are compared with SharePoint routing rules. The matter receives a legal reviewer, business approver, signatory, review due date, and triage priority.

    Failure path: No matching rule sends the record to Triage for coordinator assignment.

  7. Review and approval: A coordinator starts the review flow from the selected SharePoint item. Legal and business review can run in parallel. Higher-value matters receive an additional sequential approval after the first approvals succeed.

    Returned identifiers: Approval IDs and responses are stored in related Contract Approvals records.

  8. Signature preparation: After all required approvals, Power Automate creates a draft DocuSign envelope, uploads the approved PDF, adds recipients, and saves the returned envelope ID. A signature administrator verifies the document, recipients, order, and signing fields.

    Failure path: An uncertain DocuSign response is reconciled before a replacement envelope can be created.

  9. Signature status: DocuSign status events update the SharePoint matter. Sent and delivered events maintain the signature queue. Declined or voided events create a Signature Exception. Completed events start the archive process.

    Duplicate control: Terminal events use the envelope ID as an idempotency key so a repeated completion event cannot create a second archive set.

  10. Archiving: Power Automate downloads the completed agreement and completion certificate, saves both in the restricted Executed Contracts library, applies matter metadata, updates the executed document links, and sets the matter to Executed.

    Notification: The requester, business owner, legal reviewer, and contract coordinator receive the final archive link subject to their permissions.

  11. Monitoring: A scheduled flow checks overdue reviews, signature delays, automation failures, and possible differences between DocuSign status and SharePoint status.

    Failure path: Unresolved records enter the manual-review queue and remain there until an owner records a recovery action.

Data Structure

The main entity is the Contract Matter. Related lists store approvals, routing rules, delegation periods, operational events, and failures. Documents remain in SharePoint libraries rather than list attachments.

Core Contract Matters fields
Field and type Required Source Validation or allowed values Purpose and automation
Matter ID, single-line text Yes Power Automate Unique; format CT-YYYY-NNNNNN Primary business identifier used in files, emails, approvals, and envelopes.
Source Submission Key, single-line text Yes Power Automate Unique; form version plus response ID Prevents duplicate matter creation.
Forms Response ID, single-line text Yes Microsoft Forms Nonblank Supports intake troubleshooting.
Agreement Type, choice Yes Requester NDA, MSA, SOW, supplier agreement, DPA, amendment, other Drives routing, templates, and reporting.
Department, choice Yes Requester Sales, procurement, operations, other Determines the business approval path.
Counterparty Legal Name, text Yes Requester Trimmed; minimum meaningful length Searchable party name and archive metadata.
Business Purpose, multiple-line text Yes Requester Minimum 20 characters Explains the commercial reason for the agreement.
Requester, person Yes Forms responder identity Internal active user Receives status notifications.
Business Owner, person Yes Requester or coordinator Internal active user Owns commercial information and requested changes.
Legal Reviewer, person Yes before review Routing rule or coordinator Member of approved legal reviewer group Owns legal review and disposition.
Business Approver, person Yes before review Routing rule Authorized department approver Approves the business commitment.
Company Signatory, person Yes before signature Routing rule Authorized signatory list Used in the DocuSign recipient mapping.
Contract Value, currency Yes Requester Zero or greater Supports approval thresholds and reporting.
Currency, choice Yes Requester Configured business currencies Prevents ambiguous financial values.
Template Status, choice Yes Requester Company standard, company modified, counterparty paper, unknown Influences legal priority and signature preparation.
Target Signature Date, date Yes Requester Current date or later unless coordinator overrides Controls reminders and deadline reporting.
Personal Data, choice Yes Requester Yes, no, unknown Flags privacy review without making a legal conclusion.
Automatic Renewal, choice Yes Requester Yes, no, unknown Prompts review and later obligation metadata.
Exclusivity, choice Yes Requester Yes, no, unknown Raises triage priority.
Unusual Liability or Indemnity, choice Yes Requester Yes, no, unknown Raises triage priority but does not determine acceptability.
Foreign Governing Law, choice Yes Requester Yes, no, unknown Routes uncertain terms for legal review.
Triage Priority, choice Yes Power Automate Routine, elevated, needs clarification Calculated from deterministic intake rules.
Status, choice Yes Power Automate or coordinator Controlled workflow statuses Represents the current lifecycle stage.
Approval Status, choice Yes Power Automate Not started, pending, approved, changes requested, rejected Provides a summary of related approvals.
Current Draft URL, hyperlink Yes before review Power Automate or coordinator SharePoint tenant URL Identifies the document that reviewers must use.
Workspace URL, hyperlink Yes Power Automate SharePoint tenant URL Connects the matter to its working folders.
Envelope ID, single-line text No DocuSign connector One active envelope per matter External identifier for signature synchronization.
Envelope Status, choice No DocuSign event Draft, sent, delivered, completed, declined, voided, corrected Tracks signature progress.
Executed Document URL, hyperlink No Archive flow Restricted SharePoint archive URL Links to the authoritative executed copy.
Automation Status, choice Yes Power Automate Pending, running, completed, warning, failed, manual recovery Separates technical health from business status.
Last Automation Run, date and time No Power Automate UTC timestamp Supports monitoring and reconciliation.
Retry Count, number Yes Power Automate Integer, default zero Limits repeated recovery attempts.
Error Message, multiple-line text No Power Automate Sanitized technical summary Explains the current failure without storing credentials.
Notes, multiple-line text No Authorized users No privileged content unless site classification permits it Records operational context and manual recovery decisions.
Created and Modified, system timestamps Yes SharePoint System managed Provides record history and reporting dates.
Contract Approvals
Stores Matter ID, approval type, sequence, approver, approval provider ID, requested date, due date, response, response date, comments, reminder count, and superseded status. One matter can have multiple approval records.
Contract Event Log
Stores an immutable-style operational history containing event key, Matter ID, event type, actor, timestamp, source system, result, correlation ID, and a short detail message.
Contract Routing Rules
Stores agreement type, department, minimum and maximum value, legal reviewer, business approver, additional approver, signatory, priority, template reference, and active status.
Approval Delegations
Stores primary approver, delegate, start date, end date, approval type, and active status. The approval flow checks this list before assigning a request.
Automation Failures
Acts as a manual-review and dead-letter queue. It stores flow name, run URL, Matter ID, source event key, failed stage, error summary, retry count, owner, recovery status, and recovery notes.

The Matter ID is copied into document-library metadata and all related lists. SharePoint lookup columns can be used, but a text copy of Matter ID is also retained to simplify filtering, export, and recovery if a lookup becomes unavailable.

Workflow Statuses and Ownership

Contract workflow statuses
Status Meaning and owner Entry condition Exit condition Reminder and escalation
New Intake received; legal coordinator owns initial control. Valid form response creates a matter. Workspace and routing complete. Alert if still New after four hours.
Intake Exception Requester and legal coordinator must correct missing or invalid information. Validation fails or the source file cannot be retrieved. Required information and file are supplied. Reminder after two business days; escalate after five.
Triage Legal coordinator confirms routing and priority. Automation completes or no routing rule matches. Reviewer, approver, and current draft are confirmed. Daily queue; escalate after two days.
Under Review Legal reviewer and business approver own parallel tasks. Coordinator starts review. All responses are received, or one reviewer requests changes or rejects. Reminder based on approval due date; escalation after two overdue days.
Changes Requested Business owner coordinates a revised document or additional information. Legal or business reviewer returns the matter. New version is uploaded and resubmitted. Reminder after three days; escalate near target signature date.
Awaiting Additional Approval Additional authorized approver owns the decision. Initial approvals succeed and a threshold rule applies. Approval, rejection, or change request. Reminder after two days; coordinator escalates after four.
Approved for Signature Legal coordinator owns final document confirmation. All required human approvals are recorded. Envelope preparation begins. Daily reminder when target date is within three days.
Signature Preparation Signature administrator verifies document, recipients, order, and fields. DocuSign draft envelope is created. Verified envelope is sent or preparation is cancelled. Reminder after one day; immediate escalation if target date is near.
Sent for Signature Business owner monitors external completion; legal coordinator handles exceptions. DocuSign reports sent or delivered. Completed, declined, voided, or cancelled. Reminder based on envelope and target date rules.
Signature Exception Legal coordinator investigates. Envelope is declined, voided, corrected unexpectedly, or cannot be reconciled. Envelope is corrected, replaced, cancelled, or completed. Immediate notification and daily queue.
Executed Records owner controls retention and access. Completed document and certificate are archived successfully. Normally terminal; amendment creates a new related matter. No workflow reminder; retention schedule applies.
Rejected Business owner and legal coordinator receive the recorded reason. An authorized reviewer selects rejection. Terminal unless an authorized coordinator reopens it. No automatic resubmission.
Cancelled Legal coordinator records cancellation. Requester withdraws the matter or the business no longer proceeds. Terminal unless formally reopened. Open envelopes must be voided separately.
Automation Error Automation owner investigates the technical failure. A required flow stage fails after configured retries. Recovery succeeds and the prior business status is restored. Immediate alert, daily failure report, escalation after one business day.

A matter can move backward from Under Review to Changes Requested. Rejection and cancellation require a reason. An Executed matter is not edited to represent an amendment; a separate amendment matter is created and linked to the original Matter ID.

Step-by-Step Implementation

Step 1: Prepare the Accounts and Permissions

  1. Create separate Power Platform environments or clearly separated solution packages for development and production. Use test Microsoft Forms, SharePoint sites, and DocuSign test credentials during development.

  2. Confirm that the Microsoft 365 tenant provides Microsoft Forms, SharePoint, Microsoft 365 Outlook, and the Power Automate capabilities required by the design. The DocuSign connector may require premium Power Automate licensing. DocuSign account features and envelope allowances must be confirmed directly for the selected subscription.

  3. Create a private SharePoint site named for contract operations. Suggested groups are Contract Administrators, Legal Reviewers, Business Approvers, Records Readers, and Contract Requesters. Do not grant all employees access to the legal workspace merely because they can submit the form.

  4. Create a shared mailbox such as YOUR_EMAIL_ADDRESS for workflow notifications and replies. Give the automation connection permission to send from the mailbox only if organizational policy permits it.

  5. Create a dedicated DocuSign integration user or controlled operational account with permission to create, prepare, send, and retrieve envelopes. The account must be licensed and governed according to the organization’s agreement with DocuSign. Do not store its password in SharePoint or flow variables.

  6. Create Power Automate connections through interactive OAuth authorization for Microsoft Forms, SharePoint, Microsoft 365 Outlook, Approvals, and DocuSign. Use connection references if flows are packaged in a Power Platform solution.

  7. Store nonsecret configuration values as solution environment variables or in a restricted configuration list. These values include the SharePoint site URL, list names, library names, form identifier, legal mailbox, threshold values, DocuSign account selection, and test-mode flag.

  8. Use connector-managed authentication for DocuSign. Do not insert access tokens into actions, list columns, emails, or expressions. Production and test DocuSign accounts require separate connections.

  9. Create at least five test identities: requester, legal reviewer, sales approver, procurement approver, and signature administrator. Include one disabled or unavailable test account to verify reassignment behavior.

  10. Document who can edit flows, change routing rules, inspect run history, retry failures, access executed agreements, and authorize AI processing.

Step 2: Build the Intake

Create the Contract Intake form as a group-owned Microsoft Form associated with the controlled Microsoft 365 group. A group-owned form keeps ownership from depending on one employee and stores uploaded files in the group’s SharePoint storage rather than an individual’s personal storage.

Restrict responses to authenticated employees. File upload questions in Microsoft Forms are normally appropriate for internal respondents. If external parties must submit agreements later, use a separately governed portal or secure upload process rather than opening the internal form anonymously.

Microsoft Forms intake fields
Question Type Required Validation or choices
Requesting department Choice Yes Sales, procurement, operations, other
Agreement type Choice Yes NDA, MSA, SOW, supplier agreement, DPA, amendment, other
Counterparty legal name Short text Yes Legal entity name, not a salesperson’s name
Business purpose Long text Yes Request at least 20 meaningful characters
Business owner email Short text Yes Internal email format; validated again in Power Automate
Total contract value Number Yes Zero or greater
Currency Choice Yes Configured business currencies
Target signature date Date Yes Past dates require coordinator review
Template status Choice Yes Company standard, company modified, counterparty paper, unknown
Will personal data be processed? Choice Yes Yes, no, unknown
Does the agreement contain automatic renewal? Choice Yes Yes, no, unknown
Does it contain exclusivity? Choice Yes Yes, no, unknown
Are unusual liability or indemnity terms expected? Choice Yes Yes, no, unknown
Does it use foreign governing law? Choice Yes Yes, no, unknown
Is the request urgent? Choice Yes Yes or no
Urgency explanation Long text Conditional Displayed when urgency is Yes
Related matter ID Short text No Used for amendments or known duplicate requests
Contract file File upload Yes One PDF or DOCX file within the tenant’s configured limit
Additional context Long text No Operational facts, not passwords or unrelated sensitive data

Add a privacy notice explaining that the information will be used for contract review, approval, signature, records management, and related audit activity. Tell employees not to upload identity documents, payment card data, health information, credentials, or unrelated personal data.

Use Forms branching to display the urgency explanation and amendment reference only when relevant. Forms provides the initial required-field checks. Power Automate performs server-side validation because form controls can change and data can still be unsuitable for processing.

After submission, display a confirmation stating that the request has been received but has not yet been legally or commercially approved. The generated matter ID is sent later after SharePoint record creation.

Duplicate automation events are prevented with the Forms response ID. Possible business duplicates are not automatically deleted. If the same counterparty, agreement type, filename, and target date appear within a short period, the matter is marked as a potential duplicate for coordinator review.

Step 3: Create the System of Record

  1. Create the Contract Matters SharePoint list using the fields described earlier. Enable version history. Configure Source Submission Key to enforce unique values. Index Matter ID, Status, Legal Reviewer, Business Owner, Target Signature Date, Envelope ID, Automation Status, and Modified.

  2. Create Contract Approvals, Contract Event Log, Contract Routing Rules, Approval Delegations, and Automation Failures lists. Index Matter ID and the primary status or due-date columns in each list.

  3. Create a Contract Workspaces document library with version history enabled. Use a URL name without spaces, such as ContractWorkspaces, even if the displayed library name contains spaces.

  4. Create an Executed Contracts document library with restricted permissions. Enable version history and apply approved retention settings. If retention labels require additional Microsoft licensing, confirm that feature before designing the flow around it.

  5. Add document metadata columns: Matter ID, Agreement Type, Counterparty, Document Stage, Document Version Label, Envelope ID, Execution Date, and Record Status.

  6. Create routing rules. For example, sales NDAs and sales MSAs can route to one legal reviewer, while supplier agreements and DPAs route to another. The department selects the business approver. A representative additional approval threshold is $100,000, but the actual threshold must come from company policy.

  7. Use a unique rule priority so that a specific high-value DPA rule is evaluated before a general procurement rule. Do not rely on undefined list order.

  8. Create views for New and Triage, My Legal Reviews, My Business Approvals, Changes Requested, Approved for Signature, Signature Preparation, Sent for Signature, Overdue, Executed This Month, and Automation Failures.

The SharePoint numeric item ID is the stable technical key. Matter ID is the human-readable key. The year in Matter ID improves readability but does not reset the underlying SharePoint identifier.

Do not use a SharePoint calculated column that depends on a volatile current-date function for overdue status. The scheduled monitoring flow should update an Is Overdue field or the view should filter directly against the due-date column.

Step 4: Connect the Tools

Integration field mapping
Source Destination Trigger and authentication Important mapping Returned value
Microsoft Forms Power Automate New response trigger; Microsoft 365 connection Response ID to Get response details Complete response and attachment metadata
Power Automate SharePoint Validated intake; OAuth connection Form answers to Contract Matters columns SharePoint item ID and item link
Forms file storage Contract Workspaces After matter and folders exist File identifier or stored file path to generated matter filename SharePoint file identifier and URL
Contract Matters Approvals Selected-item review flow Matter summary, current draft link, due date, approver identity Approval ID, response, responder, comments, date
Contract Matters DocuSign Selected-item signature preparation flow Approved PDF, subject, recipients, routing order, Matter ID Envelope ID and initial envelope status
DocuSign Contract Matters Envelope status event through connector Envelope ID, status, event time, recipient status Updated matter status and event record
DocuSign Executed Contracts Completed envelope event Completed agreement and certificate to archive names and metadata Archived file URLs

Microsoft Forms file-upload output is a JSON array. Its exact properties can vary depending on whether the form is personal or group-owned and how Microsoft represents the backing drive. Run a test submission, inspect the Get response details output, and map the returned file identifier to the corresponding SharePoint or OneDrive file-content action.

For this implementation, the form is group-owned and its upload location is in the legal group’s SharePoint storage. The flow parses the attachment array, validates that exactly one item exists, retrieves its content, and writes a renamed copy into the matter workspace.

The DocuSign connector uses OAuth through the saved Power Automate connection. Connector action labels can change between connector versions. The required logical operations are create a draft envelope, add the approved document, add recipients, save the returned envelope ID, send the verified envelope, receive status changes, and retrieve completed documents.

Step 5: Build the Core Automation

Flow 1: Contract Intake Orchestrator

  • Trigger: Microsoft Forms reports a new response.
  • Conditions: The response ID exists, the submission key is new, required business fields are present, and one permitted file is attached.
  • Actions: Retrieve response details, validate data, check duplicates, create the SharePoint matter, generate Matter ID, create folders, copy the source file, resolve routing, update the matter, log events, and send confirmation.
  • Fields updated: Matter ID, status, owners, priority, workspace URL, current draft URL, review due date, automation status, and last automation run.
  • Notification: Confirmation to the requester and assignment notice to the legal coordinator.
  • Exception: Create an Automation Failures item and set Intake Exception or Automation Error according to whether the problem is business data or technical processing.

Configure the action order as follows:

  1. Initialize Correlation ID, Submission Key, Matter ID, Original File Name, File Extension, and Triage Priority variables.
  2. Get the complete Forms response.
  3. Parse the file-upload JSON array.
  4. Validate the file count, extension, counterparty, owner email, target date, value, and required choices.
  5. Search Contract Matters for Source Submission Key.
  6. If found, write a Duplicate Event entry and terminate with a successful status.
  7. Create the Contract Matters item with status New and Automation Status Running.
  8. Generate Matter ID from the returned SharePoint item ID.
  9. Update the item immediately so later failures still have a usable Matter ID.
  10. Create the matter folder and stage subfolders.
  11. Retrieve the uploaded file content and create the normalized file in 01-Intake.
  12. Copy the file to 02-Working as version 001 and store its link as Current Draft URL.
  13. Calculate deterministic triage priority.
  14. Read active routing rules and select the highest-priority matching rule.
  15. Update reviewer, approver, signatory, review due date, status Triage, and Automation Status Completed.
  16. Create Contract Event Log entries for intake, workspace creation, and routing.
  17. Send the requester the Matter ID and send the legal coordinator the triage link.

Unique records are protected by both the duplicate query and the SharePoint unique constraint. If a duplicate Create item action encounters a conflict, the Catch scope queries for the existing source submission key and records the duplicate event rather than retrying creation.

Flow 2: Start Contract Review

  • Trigger: Authorized coordinator selects a Contract Matters item and starts the review flow.
  • Conditions: Status is Triage or Changes Requested; Current Draft URL exists; legal reviewer and business approver are assigned; no active approval set exists.
  • Actions: Create approval records, start legal and business approvals in parallel, store responses, evaluate results, and start any additional sequential approval.
  • Fields updated: Status, Approval Status, review start date, current approval IDs, and last automation run.
  • Notification: Review assignments containing the Matter ID, summary, deadline, and controlled SharePoint document link.
  • Exception: Timeouts and unavailable approvers remain visible as pending or overdue approval records and enter coordinator review.

The current draft link is captured at review start. If the document changes while approvals are pending, a file-modified check marks the approval set stale. The coordinator must supersede those approvals and restart review against the new version. This prevents an approval from being applied to a later document version.

Flow 3: Prepare Signature Envelope

  • Trigger: Authorized coordinator selects an Approved for Signature matter.
  • Conditions: Approval Status is Approved; final PDF exists; Envelope ID is empty; company signatory and counterparty signer details are complete.
  • Actions: Retrieve the approved PDF, create a DocuSign draft envelope, add the document and recipients, store Envelope ID, and set Signature Preparation.
  • Fields updated: Envelope ID, envelope status Draft, signature preparation owner, status, and last automation run.
  • Notification: Signature administrator receives the DocuSign envelope reference and verification checklist.
  • Exception: An uncertain create response is not automatically repeated. The administrator reconciles DocuSign before creating another envelope.

Use a subject such as CT-2026-000147 | MSA | Counterparty Legal Name. Avoid placing confidential contract terms in the email subject.

The signature administrator opens the draft in DocuSign and verifies the document, recipient email addresses, routing order, signing fields, and company signatory. After verification, the administrator marks Signature Package Verified in SharePoint and starts the Send Verified Envelope flow. That flow checks the approval and envelope state again before calling the connector’s send operation.

Flow 4: DocuSign Status Handler

  • Trigger: DocuSign reports an envelope status change.
  • Conditions: Envelope ID maps to one active matter and the event has not already been processed.
  • Actions: Normalize status, update SharePoint, log the event, notify relevant owners, and start archiving when completed.
  • Fields updated: Envelope Status, Status, signature timestamps, error details, and last automation run.
  • Notification: Completion, decline, void, or exception notice according to status.
  • Exception: Unknown envelope IDs are written to Automation Failures for manual reconciliation.

The flow must not identify the matter by counterparty or subject alone. Envelope ID is the authoritative integration key.

Flow 5: Nightly Reconciliation

  • Trigger: Scheduled recurrence outside peak hours.
  • Conditions: Matters have an active Envelope ID and are not Executed, Rejected, or Cancelled.
  • Actions: Retrieve current envelope status, compare it with SharePoint, correct safe status differences, and queue ambiguous differences.
  • Fields updated: Envelope Status, reconciliation date, automation status, and error message.
  • Notification: Summary to the automation owner when discrepancies exist.
  • Exception: Authentication or rate-limit failures are retried according to policy, then moved to Automation Failures.

Step 6: Add Approvals, Reminders, and Escalations

Legal and business review use separate approval records even when the Power Automate actions run in parallel. This makes the evidence understandable without relying exclusively on flow run history.

  1. Before creating each approval, check Approval Delegations for an active delegation covering the current date and approval type. Substitute the delegate only when the rule is valid.

  2. Create a Contract Approvals item with status Pending, sequence, due date, document version identifier, assigned approver, and correlation ID.

  3. Create the Power Automate approval using a custom-response approval type if available. Use responses such as Ready for Signature, Changes Required, and Do Not Proceed. If the tenant exposes only standard approval responses, use Approve and Reject and require the coordinator to classify a rejection as changes requested or final rejection.

  4. Store the returned approval ID in the related approval item.

  5. Wait for the response. Configure a defined timeout for the wait action and use run-after behavior for success, timeout, and failure.

  6. Update the approval record with responder, response, response date, comments, and provider ID.

  7. After both parallel branches complete, evaluate all results. Any final rejection sets Rejected. Any change request sets Changes Requested. Only all-ready responses permit additional approval or signature preparation.

  8. If Contract Value is at least the representative $100,000 threshold, create a sequential additional approval. Do not start it if legal or business review has not succeeded.

A scheduled reminder flow runs each weekday morning in the organization’s configured time zone. It retrieves pending approval records and applies these rules:

  • Send the first reminder after two calendar days if no response exists.
  • Send another reminder when the due date is reached and the previous reminder is at least one day old.
  • Notify the coordinator and approval owner after two overdue days.
  • Escalate to the department manager or legal lead after four overdue days.
  • Increment Reminder Count and store Last Reminder Date after each successful notification.
  • Do not send another reminder if the approval has responded, been superseded, or the matter has closed.

Unavailable approvers are not inferred from an AI model or email wording. Planned delegation comes from the Approval Delegations list. Unplanned absence requires coordinator reassignment. Every reassignment records the original approver, new approver, reason, actor, and time.

Approval evidence includes the matter ID, exact document version, approver, response, response time, comments, Power Automate approval ID, and event-log record. Approval evidence is copied into SharePoint because cloud-flow and approval-service histories may have different retention behavior.

Step 7: Add Documents and File Management

Each matter uses this folder structure:

ContractWorkspaces/
  CT-2026-000147/
    01-Intake/
    02-Working/
    03-Review/
    04-Signature/
    05-Executed/
    99-Superseded/

The authoritative archive remains the separate Executed Contracts library. The 05-Executed folder can contain a controlled shortcut or a convenience copy if records policy permits it, but users must be told which location is authoritative.

  • Initial file: CT-2026-000147_v001_MSA.docx
  • Review copy: CT-2026-000147_v003_MSA_Review.pdf
  • Signature copy: CT-2026-000147_ApprovedForSignature.pdf
  • Executed agreement: CT-2026-000147_Executed_20260715.pdf
  • Certificate: CT-2026-000147_DocuSignCertificate_20260715.pdf

SharePoint version history remains enabled for working files. The legal coordinator updates Current Draft URL whenever a new review version becomes authoritative. Older drafts are not deleted simply to reduce clutter. They are retained according to legal and records policy and can be moved to the Superseded folder.

Requesters and assigned reviewers receive specific-person access only to the matter workspace they need. Anonymous links are prohibited. The executed archive has narrower access than the working area.

If a file with the intended archive name already exists, the archive flow checks its Envelope ID and file hash or size before proceeding. A matching envelope is treated as an idempotent repeat. A different envelope creates an archive conflict requiring human review.

Failed uploads leave the matter in a recoverable state. The source file remains in Forms storage, the matter retains its ID, and the failure record identifies the source file reference and destination folder. Recovery uses a controlled selected-item flow rather than asking users to resubmit the entire matter.

Step 8: Add Reporting and Operational Views

Operational views
View Source and filter Owner Action threshold
New and Triage Contract Matters where status is New or Triage Legal coordinator New over four hours or Triage over two days
My Legal Reviews Legal Reviewer equals current user and status Under Review Legal reviewers Due within two days
My Business Approvals Related pending approvals assigned to current user Department approvers Past approval due date
Changes Requested Status equals Changes Requested Business owners No update for three days
Signature Preparation Status equals Signature Preparation Signature administrator Draft older than one day
Sent for Signature Status equals Sent for Signature Business owner Target date within three days
Overdue Open matter with due date before current time Legal coordinator Any overdue item
Automation Failures Recovery status Open or Retrying Automation owner Any new high-impact failure
Executed This Month Status Executed and execution date in current month Legal and compliance Used for reconciliation
Manual Review Queue Priority needs clarification, signature exception, or automation warning Legal coordinator Reviewed daily

Add reporting fields for Intake Completed Date, Review Started Date, Approval Completed Date, Sent Date, Execution Date, Days in Current Status, and End-to-End Days. Power Automate stamps milestone dates when statuses change. Duration calculations should use these stored timestamps rather than trying to reconstruct timing from emails.

A weekly scheduled flow sends a concise summary containing new volume, matters by status, overdue count, average completed cycle time, signature exceptions, and automation failures. SharePoint remains the source. If reporting later requires cross-system financial analysis or long-term trends, the lists can feed Power BI after data governance and licensing are confirmed.

Step 9: Add Security and Governance Controls

  • Least privilege: Requesters can submit the form but do not automatically receive broad access to all contract matters.
  • Role-based access: Legal reviewers, business approvers, signature administrators, records readers, and flow administrators receive distinct permissions.
  • Sensitive fields: Legal notes, privacy flags, negotiation positions, and failure details are visible only to approved roles.
  • Sharing controls: Use specific-person links. Disable anonymous links for the legal site and archive.
  • Credential storage: Keep credentials in managed connector connections or an approved secret-management service. Never store tokens in SharePoint.
  • Activity records: Store workflow events in Contract Event Log. Do not rely solely on email or temporary flow run history.
  • Former employees: Identity deactivation must be accompanied by flow-owner reassignment, connection review, delegated approval cleanup, and access-group removal.
  • Retention: Apply the organization’s approved contract, negotiation-record, and signature-certificate retention schedule.
  • Backups: Confirm Microsoft 365 recovery and retention capabilities, and export critical configuration and flow packages according to policy.
  • Privacy: Do not collect unnecessary identity, financial, health, or credential data in the intake form.
  • AI restrictions: AI processing is disabled by default. It requires an approved service, permitted data region, documented inputs, and human validation.
  • Human control: Legal positions, policy exceptions, final approvals, and signing authority remain with designated people.

Breaking permission inheritance on every folder can create administrative overhead. At the representative volume, specific matter permissions are manageable if monitored. If unique permission scopes become difficult to maintain, separate workspaces by department or a dedicated contract platform may be more appropriate.

Step 10: Deploy and Test

  1. Build the SharePoint lists, libraries, form, and flows in a development environment using sample agreements containing no real confidential information.

  2. Package flows in a solution when the tenant supports the required deployment model. Use connection references and environment-specific configuration values.

  3. Create at least 25 test matters covering sales, procurement, company templates, counterparty paper, high value, incomplete data, duplicate submissions, approval rejection, and DocuSign exceptions.

  4. Perform technical testing before user acceptance testing. Confirm every returned identifier, status update, file location, and event-log entry.

  5. Run user acceptance testing with one legal reviewer, one salesperson, one buyer, one approver, and the signature administrator.

  6. Pilot with a limited agreement type, such as NDAs and supplier agreements, for two to four weeks. Keep the old inbox monitored during the pilot, but require pilot users to submit the form.

  7. Review failed runs daily during the pilot. Adjust routing rules, reminders, form explanations, and permission groups before expanding usage.

  8. Activate production flows only after production connections, DocuSign account selection, email recipients, SharePoint URLs, and test-mode flags have been independently checked.

  9. Prepare rollback instructions. Disabling the intake trigger should not remove existing records. Open matters must remain accessible and manually processable.

  10. Publish a short operating guide covering submission, review, changes, approval, envelope verification, recovery, and support ownership.

Code and Configuration

The core implementation does not require a custom application or standalone script. Microsoft Forms, SharePoint, Power Automate, Microsoft 365 Outlook, Approvals, and the DocuSign connector provide the required triggers and actions. The following expressions and schemas complete the native configuration.

Generate the submission key

Place this expression in a Compose action after the Forms trigger. If the connector exposes Response Id through dynamic content, insert that token rather than manually typing the trigger property.

concat(
  'CONTRACT_INTAKE_V1:',
  string(triggerBody()?['responseId'])
)

The output is stored in the Source Submission Key column. A repeated Forms event produces the same key.

Query for an existing submission

Use the following expression to build the SharePoint Get items filter. Set the top count to one.

concat(
  'SourceSubmissionKey eq ''',
  variables('SubmissionKey'),
  ''''
)

If the query returns an item, log a duplicate event and terminate successfully. Do not report a technical failure for an idempotent repeat.

Generate Matter ID

Place this expression after the SharePoint Create item action named Create_matter. If the environment does not expose padLeft, use a tested equivalent formatting expression.

concat(
  'CT-',
  formatDateTime(utcNow(), 'yyyy'),
  '-',
  padLeft(
    string(outputs('Create_matter')?['body/ID']),
    6,
    '0'
  )
)

Expected output for SharePoint item 147 is CT-2026-000147.

Validate the file extension

toLower(
  last(
    split(
      variables('OriginalFileName'),
      '.'
    )
  )
)

Store the output in File Extension. Then use this condition:

contains(
  createArray('pdf', 'docx'),
  variables('FileExtension')
)

A false result routes the request to Intake Exception. Validate the actual file using organizational malware scanning and file controls as well as the filename extension.

Create a normalized destination filename

concat(
  variables('MatterId'),
  '_v001_',
  replace(variables('AgreementType'), ' ', '_'),
  '.',
  variables('FileExtension')
)

Parse the Microsoft Forms attachment

Place a Parse JSON action after Get response details and use the file-upload question output as its content. This schema accepts the common file metadata properties while requiring only a name and link.

{
  "type": "array",
  "items": {
    "type": "object",
    "required": [
      "name",
      "link"
    ],
    "properties": {
      "name": {
        "type": "string"
      },
      "link": {
        "type": "string"
      },
      "id": {
        "type": [
          "string",
          "null"
        ]
      },
      "referenceId": {
        "type": [
          "string",
          "null"
        ]
      },
      "driveId": {
        "type": [
          "string",
          "null"
        ]
      },
      "size": {
        "type": [
          "integer",
          "null"
        ]
      },
      "status": {
        "type": [
          "integer",
          "null"
        ]
      }
    }
  }
}

Run one test submission and inspect the actual output. Microsoft can represent group-owned and personal form files differently. Use the returned identifier with the connector that owns the backing file. Do not construct an untested storage path from the filename alone.

Calculate deterministic triage priority

Initialize Contract Value as a number and the risk answers as strings. Then use:

if(
  or(
    greaterOrEquals(variables('ContractValue'), 100000),
    equals(variables('TemplateStatus'), 'Counterparty paper'),
    equals(variables('PersonalData'), 'Yes'),
    equals(variables('Exclusivity'), 'Yes'),
    equals(variables('UnusualLiability'), 'Yes'),
    equals(variables('ForeignLaw'), 'Yes')
  ),
  'Elevated',
  if(
    or(
      equals(variables('TemplateStatus'), 'Unknown'),
      equals(variables('PersonalData'), 'Unknown'),
      equals(variables('AutomaticRenewal'), 'Unknown'),
      equals(variables('Exclusivity'), 'Unknown'),
      equals(variables('UnusualLiability'), 'Unknown'),
      equals(variables('ForeignLaw'), 'Unknown')
    ),
    'Needs clarification',
    'Routine'
  )
)

This expression determines workflow priority only. It does not classify legal risk or approve contract language.

Configure Try, Catch, and Finally scopes

  1. Place the normal flow actions in a Scope named Try.
  2. Create a Catch scope configured to run after Try has failed, timed out, or been skipped because of a prior failure.
  3. In Catch, create an Automation Failures item, update the matter if it exists, record a sanitized error, and notify the automation owner.
  4. Create a Finally scope configured to run after both success and failure. Update Last Automation Run and write the correlation ID where possible.
  5. Use exponential retry for safe read operations and idempotent updates. A representative configuration is four attempts beginning with a short delay, subject to connector limits.
  6. Disable automatic retry for uncertain DocuSign envelope creation unless the operation can be reconciled through Envelope ID or another reliable idempotency control.

Normalize DocuSign status

Use a Switch action on the lower-case DocuSign status value:

DocuSign status mapping
DocuSign status Contract status Action
created or draft Signature Preparation Store Envelope ID and await verification.
sent or delivered Sent for Signature Update timestamps and notify business owner when required.
completed Remain pending until archive succeeds Retrieve documents, archive, then set Executed.
declined or voided Signature Exception Notify coordinator and record reason when available.
corrected Signature Preparation or Signature Exception Require coordinator review before assuming recipients are unchanged.
unknown value No automatic business change Create a warning and manual-review item.

Approval outcome reference

For an action named Wait_for_legal_approval, the result is commonly available through the action body. Confirm the property name by inspecting a successful test run.

outputs('Wait_for_legal_approval')?['body/outcome']

Store the raw provider response as a short operational record only if it does not contain unnecessary sensitive data. Store the normalized outcome separately for reporting.

Deployment and troubleshooting

  • Replace all site URLs, form identifiers, list names, library names, email addresses, thresholds, and DocuSign account references with production configuration values.
  • Authorize each connector using the intended production owner.
  • Test expressions with sample responses before activating triggers.
  • Inspect Power Automate run history for action inputs and outputs, subject to privacy policy.
  • Use the correlation ID to match a Forms response, flow run, SharePoint matter, approval, envelope, and failure record.
  • If file retrieval fails, verify whether the form is personal or group-owned and which storage connector recognizes the returned file identifier.
  • If person-column updates fail, verify that the email resolves to an active tenant user and that the connection can access the user profile.
  • If DocuSign actions fail, verify account selection, user consent, envelope permissions, connector connection health, and test versus production environment.

Failure Handling and Operational Reliability

Failure and recovery procedures
Failure User-visible result Automated response Manual recovery Owner
Missing required business data Matter enters Intake Exception. Notify requester with missing fields. Coordinator updates validated fields and runs Resume Intake. Requester and legal coordinator
Duplicate Forms event No second matter appears. Existing submission key is detected and event logged. None unless records differ unexpectedly. Automation owner
Possible duplicate business request Both records remain visible with a warning. Potential duplicate flag is set. Coordinator merges, cancels, or confirms separate matters. Legal coordinator
Invalid owner email Intake Exception and notification to requester. Person lookup fails safely. Correct the owner and resume routing. Requester
Failed folder creation Matter shows Automation Error. Retry safe create operation, then log failure. Verify permissions, create folder, and run Resume Workspace. Automation owner
Failed source file retrieval Workspace exists without a current draft. Preserve Forms file reference and queue failure. Retrieve the original file or request a controlled re-upload. Legal coordinator
File already exists No overwrite occurs without validation. Compare matter metadata and intended version. Confirm duplicate or assign the next version. Legal coordinator
Approval timeout Approval remains overdue. Reminder and escalation records continue. Reassign or supersede approval with recorded reason. Legal coordinator
Unavailable approver Approval cannot progress. Use an active delegation when present. Authorized coordinator reassigns the approval. Department manager
Document changes after approval starts Approval set is marked stale. Block signature preparation. Supersede approvals and restart against the new version. Legal coordinator
DocuSign create request times out Matter remains in signature preparation with warning. Do not create another envelope automatically. Search DocuSign by Matter ID and store the existing Envelope ID or retry after confirming none exists. Signature administrator
Unknown DocuSign envelope No matter is changed. Create reconciliation failure. Identify the source and map or disregard the event. Automation owner
Failed completed-document retrieval Matter remains completed in DocuSign but not Executed in SharePoint. Retry safe download and record archive pending. Download from DocuSign and run Archive Recovery. Records owner
Failed notification Record processing continues if the notice is noncritical. Log warning and retry the email action. Contact owner through an approved alternative channel. Legal coordinator
Expired or revoked connection Multiple flow runs fail authentication. Stop repeated high-impact operations and raise an alert. Reauthorize the connection and replay queued events in order. Power Platform administrator
Connector rate limit Processing may be delayed. Use connector retry guidance and controlled concurrency. Resume failed items after the limit clears. Automation owner
Malformed AI output No legal fields are updated. Send the item to AI manual review. Lawyer reviews the source contract without AI output. Legal reviewer

The Automation Failures list acts as the dead-letter queue. Staff filter it by Open, Retrying, Waiting for User, and Resolved. Recovery actions are separate selected-item flows with precondition checks. Users do not edit technical identifiers to force a retry.

Idempotency is applied at each side-effect boundary:

  • Forms response ID protects matter creation.
  • Matter ID protects folder creation and naming.
  • Approval set ID protects approval creation.
  • Envelope ID protects signature updates.
  • Envelope ID plus completed status protects archive creation.
  • Event key protects repeated webhook or connector events.

A nightly reconciliation compares open SharePoint matters with current DocuSign status. A monthly reconciliation compares Executed matters with the presence of an executed PDF and certificate. Differences remain visible until resolved.

A Complete Example

A salesperson submits a customer MSA through the Contract Intake form. The counterparty is identified generically as a prospective customer. The total contract value is $72,000, currency is USD, the target signature date is 12 days away, and the document is marked Company Modified. The requester answers No for personal data, Yes for automatic renewal, No for exclusivity, Unknown for unusual liability, and No for foreign governing law.

  1. Microsoft Forms generates response ID 843.
  2. Power Automate creates submission key CONTRACT_INTAKE_V1:843.
  3. No existing submission has that key.
  4. SharePoint creates list item 147.
  5. Power Automate generates Matter ID CT-2026-000147.
  6. The source document becomes CT-2026-000147_v001_MSA.docx.
  7. The unknown liability answer causes Triage Priority to become Needs clarification.
  8. The sales MSA routing rule assigns a legal reviewer, the Sales Director as business approver, and the authorized commercial signatory.
  9. The legal coordinator confirms the current document and changes the uncertain liability answer to Yes after checking the draft. Priority becomes Elevated.
  10. The coordinator starts legal and business review. Two Contract Approvals records are created, each containing the current SharePoint document version.
  11. The business approver selects Ready for Signature and records that the value and commercial scope are approved.
  12. The lawyer returns Changes Required with comments identifying a liability provision for negotiation.
  13. The matter moves to Changes Requested. The requester receives a controlled link and explanation.
  14. A revised document is uploaded as version 002. The prior approval set is marked Superseded.
  15. The coordinator starts a new review set. Both reviewers select Ready for Signature.
  16. The value is below the representative $100,000 additional-approval threshold, so no executive approval is created.
  17. The lawyer saves the approved PDF as CT-2026-000147_ApprovedForSignature.pdf.
  18. The signature preparation flow creates a DocuSign draft and receives a generated Envelope ID, represented here as ENVELOPE_ID_147.
  19. The signature administrator verifies the prospective customer signer, company signatory, routing order, and signature fields. The verified envelope is sent.
  20. DocuSign reports sent and later completed. Repeated sent events do not create new matter records or envelopes.
  21. The completion flow downloads the signed agreement and certificate.
  22. The archive flow creates CT-2026-000147_Executed_20260715.pdf and CT-2026-000147_DocuSignCertificate_20260715.pdf.
  23. The archive links, execution date, and Envelope ID are stored on the matter. Status changes to Executed.
  24. The requester, legal reviewer, business approver, and coordinator receive completion notices containing permitted SharePoint links.

If the archive download had failed after DocuSign completion, the matter would not have been marked Executed. It would have remained archive pending with an Automation Failure record, allowing staff to recover the files without restarting review or signature.

Implementation Cost

All amounts below are representative planning assumptions, not vendor quotations or verified client costs. Licensing, connector eligibility, DocuSign envelopes, storage, taxes, and professional rates must be confirmed for the specific tenant and contract.

Representative one-time implementation cost
Item Assumption Estimated cost
Process and security design 12 professional hours at $125 $1,500
Forms, SharePoint, and Power Automate build 48 professional hours at $125 $6,000
User acceptance testing 16 internal hours at $55 $880
Training 6 internal hours at $45 $270
Documentation and handover 8 hours at a blended $75 $600
Data cleanup and pilot support 10 internal hours at $50 $500
Total representative implementation cost Core workflow without optional AI $9,750
Representative recurring monthly cost allowances
Item Planning assumption Monthly allowance
Power Automate and connector capacity Allowance pending tenant licensing review $250
DocuSign users and envelopes Allowance pending vendor quote and actual volume $150
SharePoint storage contingency Allowance for contract and certificate growth $25
Total recurring software allowance Excludes optional AI $425
Internal maintenance labour 3 hours at $48 $144
Optional AI usage Controlled pilot allowance $75
Optional AI setup 16 professional hours at $125, one time $2,000 one time

If the business already owns suitable Power Automate and DocuSign entitlements, incremental software cost may be lower. Existing software still requires configuration, administration, support, testing, and maintenance.

Estimated Time and Cost Savings

The estimate measures administrative contract coordination. It does not assume that substantive legal review or negotiation disappears.

Representative savings assumptions
Assumption Value
Monthly workflow volume 90 matters
Current administrative handling time 42 minutes per matter
New routine administrative handling time 14 minutes per matter
Exception rate 15 percent, or 13.5 matters per month
Additional exception handling 18 minutes per exception
Monthly maintenance time 3 hours
Loaded operational labour cost $48 per hour
Recurring software allowance $425 per month
One-time implementation cost $9,750

Current monthly labour hours: Monthly volume × current minutes per record ÷ 60

90 × 42 ÷ 60 = 63.00 hours

New monthly labour hours: Monthly volume × new minutes per record ÷ 60, plus exception handling and maintenance

Routine handling:
90 × 14 ÷ 60 = 21.00 hours

Exception handling:
13.5 × 18 ÷ 60 = 4.05 hours

Maintenance:
3.00 hours

Total new monthly labour:
21.00 + 4.05 + 3.00 = 28.05 hours

Monthly hours recovered: Current monthly labour hours minus new monthly labour hours

63.00 - 28.05 = 34.95 hours

Estimated monthly labour value: Monthly hours recovered × loaded hourly labour cost

34.95 × $48 = $1,677.60

Net estimated monthly value: Monthly labour value minus recurring tool costs

$1,677.60 - $425 = $1,252.60

Estimated payback period: One-time implementation cost ÷ net estimated monthly value

$9,750 ÷ $1,252.60 = 7.78 months

The modeled payback period is approximately 7.8 months under these assumptions. This is a planning estimate, not a verified outcome.

Recovered time does not automatically reduce payroll. It can represent additional review capacity, quicker turnaround, reduced overtime, fewer administrative tasks, better coverage during absence, or the ability to process higher contract volume without adding the same amount of coordination effort.

Non-financial benefits include:

  • Fewer emails requesting missing business information.
  • Clear ownership for legal, commercial, signature, and records tasks.
  • Reliable links between approvals and document versions.
  • More consistent handling of incomplete or unusual requests.
  • Searchable status and deadline reporting.
  • Better evidence of who approved the matter and when.
  • Consistent archiving of the executed agreement and certificate.
  • Less dependency on one legal coordinator’s inbox and memory.

Readers should replace the volume, handling time, exception rate, maintenance time, labour rate, licensing allowance, implementation effort, and approval thresholds with their own measured figures.

Adding AI to the Automation

AI is an optional enhancement introduced only after intake, version control, approval routing, signature synchronization, and archiving operate reliably.

Useful AI applications for contract intake include:

  • Extracting party names, dates, renewal terms, and notice periods.
  • Locating limitation of liability, indemnity, privacy, security, exclusivity, assignment, audit, and governing-law clauses.
  • Summarizing a document for a lawyer who will verify the source.
  • Suggesting an agreement category when the requester selected Other.
  • Identifying potentially missing sections or information.
  • Comparing a revised draft with an earlier version.

AI should not replace required fields, numeric thresholds, exact envelope matching, permissions, approval rules, or signature authority. These tasks are better handled by deterministic controls.

The core automation provides complete intake, routing, status control, reminders, evidence, signature synchronization, and archiving. AI adds assistance with unstructured contract text. It does not provide the core workflow benefits and is not required for the system to operate.

The recommended enhancement extracts selected clauses and creates a structured review aid for legal counsel. It never changes Approval Status, Triage Priority, legal risk, or signature readiness.

  • Trigger: A legal reviewer selects Run Clause Extraction for a matter in Triage or Under Review.
  • AI input: Text extracted from the current PDF or DOCX through an approved tenant document-extraction action.
  • System instruction: Extract and cite contract language without approving, interpreting, or inventing terms.
  • Expected output: JSON containing clause findings, quotations, locations, confidence, and review flags.
  • Validation: Parse JSON, check required properties, confirm confidence is between zero and one, and require citations for identified clauses.
  • Record update: Create a related AI Extraction record marked Unreviewed.
  • Human review: A lawyer confirms, corrects, or rejects every finding.
  • Low confidence: Confidence below 0.80 or a missing citation enters manual review without updating contract metadata.
  • Prohibited data: Credentials, identity documents, payment card data, health data, export-controlled content, or material prohibited by policy.
  • Logging: Store matter ID, document version, model or prompt version, processing time, usage, reviewer, and final disposition.
  • Cost control: Limit processing to user-requested documents, enforce file-size limits, and monitor monthly use.
  • Failure: The lawyer reviews the original document without AI assistance.

Use the following reusable prompt. Replace the placeholders with page-labeled extracted text and matter metadata.

SYSTEM INSTRUCTION

You assist a qualified legal reviewer by extracting information from a contract.
You do not approve terms, provide legal advice, determine enforceability, or make
a final risk decision.

Use only the supplied contract text. Do not infer a clause that is not present.
For every identified clause, include an exact quotation and its page, section,
heading, or paragraph location. If a value is absent or uncertain, return null.
Return valid JSON only and follow the requested schema exactly.

A confidence score reflects extraction certainty, not legal acceptability.
Do not label the agreement approved, acceptable, standard, safe, or enforceable.

USER PROMPT

Matter ID: {MATTER_ID}
Declared agreement type: {AGREEMENT_TYPE}
Declared counterparty: {COUNTERPARTY}
Document version: {DOCUMENT_VERSION}

Extract the following:
1. Agreement type suggestion
2. Named parties
3. Effective date
4. Initial term
5. Automatic renewal and notice period
6. Termination rights
7. Governing law and venue
8. Limitation of liability
9. Indemnity
10. Personal data or data protection obligations
11. Information security obligations
12. Exclusivity
13. Assignment restrictions
14. Audit rights
15. Missing or ambiguous information requiring lawyer review

For each clause, provide:
- present: true, false, or null
- summary: a neutral factual summary
- quote: exact source language
- location: page, section, heading, or paragraph
- confidence: a number from 0 to 1

Return review flags only as attention items. Do not recommend acceptance or rejection.

CONTRACT TEXT

{CONTRACT_TEXT}

The expected response follows this structure:

{
  "matter_id": "CT-2026-000147",
  "document_version": "2.0",
  "agreement_type_suggestion": {
    "value": "Master Service Agreement",
    "confidence": 0.94
  },
  "parties": [
    {
      "name": "Alderwick Process Equipment",
      "role": "Provider",
      "quote": "This Master Service Agreement is entered into by...",
      "location": "Page 1, opening paragraph",
      "confidence": 0.97
    }
  ],
  "effective_date": {
    "value": null,
    "quote": null,
    "location": null,
    "confidence": 0.41
  },
  "clauses": {
    "automatic_renewal": {
      "present": true,
      "summary": "The agreement renews for successive one-year periods.",
      "quote": "The Term will automatically renew for successive one-year periods...",
      "location": "Page 8, Section 12.2",
      "confidence": 0.96,
      "notice_days": 60
    },
    "termination": {
      "present": true,
      "summary": "Either party may terminate for uncured material breach.",
      "quote": "Either party may terminate this Agreement for material breach...",
      "location": "Page 8, Section 12.3",
      "confidence": 0.93
    },
    "governing_law": {
      "present": true,
      "summary": "The agreement states a governing jurisdiction.",
      "quote": "This Agreement will be governed by the laws of...",
      "location": "Page 11, Section 16.5",
      "confidence": 0.98
    },
    "limitation_of_liability": {
      "present": true,
      "summary": "The agreement contains a liability cap and stated exclusions.",
      "quote": "Except for the exclusions below, each party's aggregate liability...",
      "location": "Page 9, Section 14",
      "confidence": 0.92
    },
    "indemnity": {
      "present": true,
      "summary": "The parties have stated indemnification obligations.",
      "quote": "Each party will defend and indemnify...",
      "location": "Page 9, Section 13",
      "confidence": 0.90
    },
    "data_protection": {
      "present": false,
      "summary": null,
      "quote": null,
      "location": null,
      "confidence": 0.84
    },
    "security_obligations": {
      "present": null,
      "summary": "A general safeguards statement appears, but detailed requirements are unclear.",
      "quote": "Provider will maintain reasonable administrative and technical safeguards.",
      "location": "Page 6, Section 9.1",
      "confidence": 0.72
    },
    "exclusivity": {
      "present": false,
      "summary": null,
      "quote": null,
      "location": null,
      "confidence": 0.81
    },
    "assignment": {
      "present": true,
      "summary": "Assignment requires consent subject to stated exceptions.",
      "quote": "Neither party may assign this Agreement without...",
      "location": "Page 10, Section 16.1",
      "confidence": 0.95
    },
    "audit_rights": {
      "present": false,
      "summary": null,
      "quote": null,
      "location": null,
      "confidence": 0.79
    }
  },
  "missing_information": [
    "Effective date is not completed."
  ],
  "review_flags": [
    {
      "category": "Security obligations",
      "reason": "Detailed requirements were not clearly identified.",
      "quote": "Provider will maintain reasonable administrative and technical safeguards.",
      "location": "Page 6, Section 9.1"
    }
  ],
  "overall_extraction_confidence": 0.86
}

Configure the optional Power Automate flow in this order:

  1. Trigger from a selected Contract Matter.
  2. Verify that AI processing is permitted for the matter and document classification.
  3. Retrieve the current document and version identifier.
  4. Extract page-labeled text using an approved document-processing action.
  5. Remove repeated headers and footers only if the transformation has been tested.
  6. Submit the prompt and text to the approved generative AI action.
  7. Parse the returned JSON against the approved schema.
  8. Reject output containing missing required properties, invalid confidence values, or non-JSON text.
  9. Create an AI Extraction item marked Unreviewed.
  10. Notify the assigned lawyer with links to the source contract and extraction record.
  11. Require the lawyer to select Confirmed, Corrected, or Rejected.
  12. Copy only confirmed structured values into reporting metadata.

Benefits of the AI Enhancement

AI-specific benefits are limited to handling unstructured document content. They are separate from the routing, reminder, approval, signature, and archive benefits created by normal automation.

  • Less time locating frequently reviewed clauses.
  • More consistent presentation of clause quotations and locations.
  • Quicker identification of missing dates or ambiguous renewal language.
  • Structured data that can support later reporting after lawyer confirmation.
  • Faster comparison between requester answers and document language.
  • Improved search across confirmed clause metadata.

The extraction can still omit language, select the wrong passage, misunderstand cross-references, or return malformed output. Every finding remains a review aid rather than an authoritative contract record.

What Remains Rule-Based or Human-Controlled

Deterministic and human-controlled decisions
Decision Control type Reason
Required intake information Rule-based Required fields and validation are more reliable than AI inference.
Approval threshold Rule-based Financial policy must be applied consistently.
Duplicate event detection Rule-based Exact identifiers provide dependable idempotency.
Legal interpretation Human-controlled Context, law, negotiation position, and business impact require qualified judgment.
Acceptance of liability, indemnity, privacy, or security terms Human-controlled These terms can create material obligations and policy exceptions.
Commercial approval Human-controlled The business owner must accept scope, price, commitments, and operational obligations.
Final document selection Human-controlled The approved version must be confirmed before signature.
Recipient and signature-field verification Human-controlled An incorrect signer or field placement can invalidate the intended process.
Signing authority Human-controlled Only authorized people can bind the business.
Final risk acceptance Human-controlled AI confidence is not a measure of legal or business acceptability.

Estimating the Additional Value of AI

The AI estimate is separate from the core automation calculation. It considers only clause-location work for 60 eligible contracts per month.

Representative AI value assumptions
Assumption Value
Eligible documents per month 60
Gross clause-location time saved 6 minutes per eligible document
Human validation time 2 minutes for every output
Correction rate 20 percent
Correction effort 4 additional minutes
AI failure rate 5 percent
Manual fallback after failure 6 minutes
AI monthly usage allowance $75
Gross time saved:
60 × 6 ÷ 60 = 6.00 hours

Human validation:
60 × 2 ÷ 60 = 2.00 hours

Corrections:
12 × 4 ÷ 60 = 0.80 hours

Failure fallback:
3 × 6 ÷ 60 = 0.30 hours

Net additional capacity:
6.00 - 2.00 - 0.80 - 0.30 = 2.90 hours

Estimated labour value:
2.90 × $48 = $139.20

Net value after AI usage:
$139.20 - $75 = $64.20 per month
Process comparison for an eligible contract
Process Representative effort Human role
Original manual process 42 administrative minutes plus about 10 clause-location minutes Coordinates work and reads the contract directly.
Core automation without AI 14 administrative minutes plus about 10 clause-location minutes Reviews terms with improved records and routing.
Automation with AI 14 administrative minutes plus an expected 7.1 clause-extraction and review minutes Validates cited output and makes all legal decisions.

The modeled AI value is modest at this volume. Its stronger justification may be consistency, structured metadata, and reduced clause-location effort rather than direct cost reduction. The correction and failure assumptions must be replaced with measured pilot results.

Testing Checklist

Use synthetic or approved sample data before processing real contracts.

End-to-end testing checklist
Test Expected result
Normal submission One matter, workspace, file, routing result, event history, and confirmation are created.
Missing required field Forms blocks submission or Power Automate creates an Intake Exception.
Invalid owner email No unresolved person value is written; requester receives correction instructions.
Unsupported file type File is rejected and the matter enters Intake Exception.
Duplicate submission event No second matter is created.
Possible duplicate contract Potential duplicate warning appears for coordinator review.
Simultaneous duplicate events Unique Source Submission Key prevents two records.
Failed SharePoint authentication Failure enters the dead-letter queue with no repeated side effects.
Expired DocuSign connection Envelope processing stops and the automation owner is alerted.
Failed API or connector request Safe operations retry; uncertain envelope creation requires reconciliation.
Unavailable approver with delegation Active delegate receives the approval and evidence records the substitution.
Unavailable approver without delegation Coordinator receives a reassignment task.
Approval rejection Matter becomes Rejected with responder, date, and reason.
Changes requested Matter moves backward and signature preparation remains blocked.
Reassignment Original and new approver, actor, reason, and time are recorded.
Overdue approval Reminder and escalation rules run once per configured interval.
Document modified during approval Approval set becomes stale and cannot authorize signature.
Failed folder creation Matter remains recoverable and a Resume Workspace action is available.
Failed file upload Source reference is retained and no empty draft is approved.
Failed notification Business processing continues when safe and a warning is logged.
Unauthorized user starts review Flow rejects the request and records the attempt according to policy.
Envelope declined Matter enters Signature Exception.
Repeated DocuSign completion event Only one archive set is created.
Failed completed-document retrieval Matter remains archive pending rather than Executed.
Successful completion Executed PDF, certificate, metadata, links, status, and notifications are correct.
Correct reporting Views show the record under the correct status, owner, and deadline.
Correct audit record Submission, routing, approvals, envelope, archive, and recovery events are traceable.
Correct retry behavior Retries do not create duplicate matters, approvals, envelopes, or archive files.
Malformed AI output Parsing fails safely and no legal metadata is updated.
Inaccurate AI output Lawyer rejects or corrects it; source contract remains authoritative.
AI service failure Core workflow continues without AI.
Low-confidence AI output Output enters manual review and does not update confirmed fields.

Ongoing Maintenance

Maintenance schedule
Frequency Activity Primary owner Evidence
Daily Review failed runs, archive-pending matters, and signature exceptions. Automation owner Failure queue updates and recovery notes
Weekly Review overdue approvals, stale matters, and unmatched envelope events. Legal coordinator Weekly operations report
Monthly Reconcile Executed matters with archived agreements and certificates. Records owner Reconciliation report
Monthly Review connector usage, envelope volume, storage growth, and AI cost. Platform owner Cost and capacity record
Quarterly Review permissions, site sharing, flow owners, connection owners, and former users. Security and compliance owner Access-review record
Quarterly Sample approval evidence, archive metadata, and AI extractions. Legal and compliance Quality review findings
Semiannually Test failure recovery, connector reauthorization, and rollback procedures. Automation owner Test results
Annually Review approval thresholds, routing rules, retention, privacy notice, and signatory authority. Legal, finance, procurement, and sales leadership Approved policy update

The legal operations manager is the primary business owner. A trained backup coordinator owns continuity during absence. The Power Platform administrator owns connection health and technical deployment but does not make contract decisions.

Credential rotation follows organizational policy. Connector connections must be reauthorized before an employee account is disabled when that account owns production connections. Flow packages, routing documentation, field mappings, test cases, and recovery procedures are updated whenever the workflow changes.

AI output sampling should measure extraction accuracy by field, citation quality, malformed-output rate, correction rate, failure rate, and cost. A prompt or model change requires regression testing against an approved sample set before production use.

When to Move to Dedicated Software

The implementation should not be replaced merely because a dedicated platform exists. It should be reassessed when operational requirements exceed what the current configuration can support safely and economically.

Upgrade indicators include:

  • Contract volume increases enough to create SharePoint performance or permission-management concerns.
  • Multiple business units require materially different workflows, clause libraries, and approval policies.
  • External counterparties need a secure collaboration portal.
  • Obligation, renewal, notice, and milestone management become core requirements.
  • Formal audit controls require stronger immutable event records or validated system behavior.
  • Advanced clause comparison and playbook enforcement are required.
  • Complex integrations are needed with CRM, ERP, procurement, finance, identity, or records systems.
  • Unique item and folder permissions become difficult to administer.
  • Exception rates increase and coordinators spend excessive time maintaining flows.
  • Legal operations needs advanced workload, negotiation, clause, and cycle-time analytics.
  • Mobile or offline review becomes necessary.
  • Formal vendor support and service commitments become mandatory.
  • Regulatory requirements demand specialized records, residency, validation, or legal-hold capabilities.
  • Custom automation maintenance costs approach the cost of a dedicated contract lifecycle management platform.

Relevant categories include contract lifecycle management, legal matter management, procurement contract management, and document records-management platforms. The existing SharePoint data model and Matter ID can support a later migration if metadata and event records are maintained consistently.

Implementation Checklist

  • Confirm contract types, volume, departments, owners, thresholds, and exception rules.
  • Select Microsoft Forms, SharePoint, Power Automate, Outlook, and DocuSign roles.
  • Confirm required accounts, connector capabilities, licensing, and test environments.
  • Create security groups, shared mailbox, connection owners, and backup owners.
  • Define Contract Matters, Approvals, Event Log, Routing Rules, Delegations, and Failures lists.
  • Configure unique keys, indexed columns, statuses, timestamps, and metadata.
  • Build the authenticated Microsoft Forms intake and privacy notice.
  • Configure required fields, choices, branching, attachment controls, and validation.
  • Create the Contract Workspaces and Executed Contracts libraries.
  • Enable version history, naming conventions, permissions, and retention controls.
  • Map every Forms field to its SharePoint destination.
  • Build duplicate-event and possible-business-duplicate checks.
  • Build matter creation, Matter ID generation, routing, folder creation, and file-copy actions.
  • Configure legal, business, and threshold-based approvals.
  • Store approval IDs, document versions, responses, comments, and timestamps.
  • Configure reminders, escalation intervals, delegation, reassignment, and superseded approvals.
  • Build DocuSign draft creation, recipient mapping, envelope verification, and send controls.
  • Store Envelope ID before subsequent envelope operations.
  • Build DocuSign status handling, completed-document retrieval, and archive controls.
  • Add Try, Catch, Finally, retry, idempotency, dead-letter, and reconciliation controls.
  • Create operational views for queues, owners, deadlines, exceptions, failures, and completed matters.
  • Restrict sensitive fields, folders, archive access, links, credentials, and AI inputs.
  • Test normal, invalid, duplicate, rejected, overdue, failed, and recovered scenarios.
  • Run a controlled pilot with sample and approved low-risk matters.
  • Document deployment, rollback, support, recovery, and former-user procedures.
  • Validate implementation cost, software allowances, labour assumptions, and savings formulas.
  • Add AI clause extraction only after the core workflow is reliable and approved.
  • Require structured AI output, citations, confidence checks, human review, and fallback processing.
  • Assign primary and backup maintenance owners.
  • Define review dates and criteria for moving to dedicated contract software.

Get a FREE
Proof of Concept
& Consultation

No Cost, No Commitment!