How we helped a UK lending company replace multiple spreadsheets and disconnected systems with a single Power Apps loan management solution - complete with automated credit checks and CRM integration.
Before our engagement, the team juggled multiple Excel spreadsheets, Google Sheets, and disconnected tools - creating a fragmented workflow where applications regularly fell through the cracks.
We delivered a centralised loan portal built on Power Apps with SharePoint as the data backbone, featuring direct integrations with Creditsafe for credit scoring, Companies House for company verification, and Zoho CRM for customer data synchronisation.
Loan applications tracked across multiple Excel files and Google Sheets with no single source of truth. Different team members had different versions.
Staff logged into Creditsafe separately, copied results manually, and often forgot to run checks until late in the process.
Customer data in Zoho CRM was completely separate from the lending process. Duplicate entry was common, and records frequently didn’t match.
Management couldn’t see pipeline status without manually checking with each team member. Reporting took hours to compile.
Applications were taking 2-3 weeks to process when competitors were turning them around in days. The team estimated they were losing 15-20% of potential deals simply because applicants went elsewhere while waiting. Compliance was also a growing concern - with no audit trail, they couldn’t demonstrate their process to regulators.
Application intake forms with validation, a pipeline view of all active applications by stage, document upload with automatic categorisation, and mobile-responsive design for field access.
Automated credit checks triggered on application creation. Risk scores and credit limits pulled directly into the application record.
Instant company verification, director lookups, and filing history. No more manual searches or copy-paste errors.
Bi-directional sync keeps customer records aligned. New applications create CRM contacts; status updates flow both ways.
Routing based on loan value and risk tier, automated applicant notifications, SLA monitoring with management escalation, document request workflows and approval workflows for credit decisions.
Structured lists for application data, document libraries for supporting files, full version history for compliance, and Power BI dashboards for real-time pipeline reporting.
“We went from hunting through spreadsheets to having everything in one place with credit checks happening automatically. The team can actually focus on lending decisions now instead of data entry. Within two months, we’d processed more applications than the previous quarter - with fewer people involved.”
Yes. Power Apps built on Microsoft 365 inherit enterprise-grade security and compliance controls. Combined with proper architecture - audit logging, retention policies, and role-based access - Power Apps solutions can meet FCA, GDPR, and other regulatory requirements.
Via custom connectors or Power Automate flows. For this project we built custom connectors for Creditsafe and Companies House that handle authentication, request formatting and response parsing - presenting clean data to users without exposing API complexity.
This project was delivered in 8 weeks from initial scoping to go-live. A simpler loan tracking system might take 4-6 weeks; more complex solutions with multiple API integrations can take 10-12 weeks.
Absolutely - this is one of the most common and high-value use cases. Spreadsheets lack validation, audit trails, access control and workflow automation. Most clients see ROI within 3-6 months of deployment.
Book a free 30-minute discovery call to discuss how a Power Apps solution could streamline your operations.