⊞
🔍   Search
🔔
❓
⚙️
GO
📋 Vendor Management Portal
← Apps Showcase 📐 UI Mockup — Enterprise Project 01
⚠️   3 contracts expiring within 30 days — review required.   View expiring contracts →
Vendor Management Portal › Vendors Master List
🏢 Vendors Master List 384 items
Enterprise vendor registry — Procurement · Facilities · HR · Legal · Administration
384
Total Vendors
341
Active SLA
28
Expiring < 90d
15
Expired / At Risk
12
Pending Approval
Filtered by: Status: Active × Dept: All × + Add filter Clear all
ID ↑ Vendor Name Category Department SLA Status Contract Expiry Priority Contact Approver L1
📦
Dataverse Data Model — Vendor Lifecycle & Contract Management
Parallel Dataverse implementation of the SharePoint architecture · 5 custom tables · Publisher prefix: mka_ · Power Apps Model-Driven App backed
5
Custom Tables
38
Columns
4
Relationships
3
Business Rules
🏢mka_vendorCore
🔑 mka_vendoridUniqueIdentifier
mka_namenvarchar(200)
mka_categoryOptionSet
mka_departmentOptionSet
mka_primarycontactnvarchar(100)
mka_statusOptionSet
mka_slaexpirydateDateTime
mka_contractvalueCurrency
mka_prioritytierOptionSet
📄mka_vendorcontractContract
🔑 mka_vendorcontractidUniqueIdentifier
🔗 mka_vendoridLookup → mka_vendor
mka_contractnumbernvarchar(50)
mka_startdateDateTime
mka_expirydateDateTime
mka_valueCurrency
mka_statusOptionSet
mka_documenturlnvarchar(500)
🔧mka_vendorserviceService
🔑 mka_vendorserviceidUniqueIdentifier
🔗 mka_vendoridLookup → mka_vendor
mka_servicenamenvarchar(200)
mka_slatargetDecimal
mka_statusOptionSet
mka_lastreviewdateDateTime
✅mka_approvalrecordApproval
🔑 mka_approvalrecordidUniqueIdentifier
🔗 mka_vendoridLookup → mka_vendor
mka_approvalstageOptionSet
🔗 mka_approverLookup → systemuser
mka_approvedonDateTime
mka_commentsnvarchar(2000)
mka_statusOptionSet
⚠️mka_vendorincidentIncident
🔑 mka_vendorincidentidUniqueIdentifier
🔗 mka_vendoridLookup → mka_vendor
mka_incidentdateDateTime
mka_descriptionnvarchar(2000)
mka_severityOptionSet
mka_resolutionnvarchar(2000)
mka_resolvedonDateTime
Table Relationships
mka_vendor1 : Nmka_vendorcontract— all contracts per vendor
mka_vendor1 : Nmka_vendorservice— services provided
mka_vendor1 : Nmka_approvalrecord— 3-level workflow records
mka_vendor1 : Nmka_vendorincident— incident tracking
Business Rules & Plugins
⚡
SLA expiry auto-calculation: sets mka_status to Expiring when ≤ 90 days remain
BR
⚡
Approval stage gating: blocks stage advancement until previous stage resolves
BR
🔌
Post-create plugin: triggers Power Automate flow for folder provisioning in SharePoint
Plugin