Power Automate Time Condition
End-to-end digitization of multi-tier CAPEX/OPEX purchase requisitions across Power Apps, Dataverse, and SAP — replacing email quote spreadsheets and per-envelope DocuSign fees with external vendor portals (/r/:token), Teams Adaptive Cards, and SHA-256 sealed PDF contracts (/sign/:token).
⚠️ Legacy Challenge & Bottlenecks
Requisition approvals above EUR 25,000 stalled for an average of 9.4 business days across Finance, Plant GM, and Legal. Microsoft Forms blocked external suppliers from uploading PDF quotes and tax certificates, while Word Online Business and DocuSign per-seat/per-envelope licensing made automating 1,400+ monthly purchase orders prohibitively expensive.
- ✕Microsoft Forms "Upload File" disabled for external non-Entra B2B suppliers
- ✕9.4-day approval bottleneck across disconnected Outlook email threads
- ✕$38,000+/yr projected cost for Word Online Premium + third-party e-sign envelopes
- ✕Manual currency conversion errors on EUR / USD / TRY cross-border requisitions
✅ Power Platform + Zetaleap Solution
Engineered a responsive Canvas Power App backed by Dataverse row-level security and dynamic budget routing matrices. When external quotes are needed, Power Automate provisions a bot-safe multilingual (/r/:token EN/TR/DE) intake portal. Internal approvers act in one click via Microsoft Teams Adaptive Cards v1.5, after which Zetaleap merges the Word (.docx) agreement, converts it to pixel-perfect PDF, and dispatches a cryptographic SHA-256 E-Sign envelope (/sign/:token) with automatic SAP PO creation.
- ✓Reduced median requisition-to-PO cycle time from 9.4 days down to 6.5 hours (-91%)
- ✓Eliminated $38,400/year in external e-signature envelope and premium document connector fees
- ✓100% cryptographic SHA-256 audit certificate archival in SharePoint & Dataverse for ISO 27001 / SOX audits
- ✓Zero Microsoft 365 guest licenses required for 620+ domestic and European suppliers
⚡ 5-Stage End-to-End Execution Pipeline
🛡️ Enterprise Security, DLP & ALM Governance
- ◆Dataverse Security Roles + Business Unit isolation across 4 manufacturing plants
- ◆DLP-compliant Zetaleap OpenAPI 2.0 Custom Connector using Entra-scoped vault secrets
- ◆Bot-safe read-only GET portals (/r/:token & /sign/:token) immune to Defender Safe Links prefetching
- ◆Automated Azure DevOps / GitLab Managed Solution ALM promotion (Dev -> Test -> Prod)
🧩 Technology & Connector Stack
Engineered with governed Microsoft Cloud services and drop-in Zetaleap Swagger 2.0 Custom Connectors: