A contact-centre CRM built for scale
- Context
- A production CRM used by more than 230 people had to remain fast, secure and dependable across nine million Dataverse records.
- What changed
- Contact search fell from about two minutes to under five seconds. With nine million records, loading more data into the app was not an option, so I kept the search delegable with Filter, StartsWith and SortByColumns. I then used DelayOutput and a minimum character threshold to avoid unnecessary Dataverse requests. I also traced more than 70 data-changing formulas, prioritised the risks and delivered the fixes.
- My role
- As the primary developer, I built the Canvas app and owned the wider Dataverse solution. That included the model-driven CRM, tables, case processes, reporting, year-end data reports, security, integrations and deployments.
Build and architecture
- Status
- In production. I continue to support it.
- Built with
- Canvas and model-driven apps, Dataverse, Power Fx, Power Automate, Power Platform Pipelines, Azure DevOps
- Canvas app
- Dataverse
- Model-driven CRM
- Integrations
- Power Automate
- Reporting