A centralized referral management solution built with Microsoft Power Apps, SharePoint, and Power Automate to automate referral intake, adviser allocation, client follow-ups, notifications, payment calculations, and referral tracking.
Trasol designed and developed a centralized Referral Management System using Microsoft Power Platform to streamline the complete referral lifecycle—from referral submission and adviser allocation to follow-ups, notifications, payment calculations, and final completion.
The solution was built from scratch using Microsoft Power Apps, SharePoint Online, Power Automate, and Microsoft 365 Outlook.
The application provides staff with a structured interface for submitting and managing referrals, while automated workflows reduce manual administration and ensure that the right users are notified at the right stage of the referral journey.
The organization was managing referral activities across multiple manual processes, making it difficult to maintain consistent tracking and timely communication.
Key challenges included:
The organization needed a solution that could standardize the referral process while automating repetitive administrative activities.
Trasol analyzed the referral lifecycle and converted the existing business process into a structured digital workflow.
We designed the solution around three key components:
A user-friendly Power Apps Canvas Application was created for staff to submit, view, update, and track referrals.
SharePoint Online was used to maintain referral records, adviser information, tracking details, payment information, and automation-control fields.
Power Automate was implemented to automate notifications, follow-ups, reminders, payment calculations, and referral-related business processes.
This architecture provided a flexible solution that could be enhanced as the organization's referral process evolved.
The Power Apps Canvas application acts as the primary interface for users managing referrals.
The application provides users with a consistent and structured way to manage referral information.
SharePoint Online provides the underlying data structure for the solution.
The system maintains information such as:
This centralized structure improves data consistency and provides a reliable source for reporting, tracking, and auditing.
Power Automate forms the automation layer of the solution.
Multiple workflows were developed to automate referral-related processes and minimize manual intervention.
Adviser Allocation Notifications
When a referral is allocated or reassigned to an adviser, Power Automate identifies the relevant adviser and automatically sends the referral information.
Client Follow-up Automation
When an existing-client referral reaches the required business stage, automated workflows initiate the appropriate follow-up activities.
Thank-You Card Workflow
The system automatically identifies eligible referrals and triggers the required thank-you-card process.
Hamper Notification Workflow
Eligible referrals can trigger automated hamper-related notifications while maintaining tracking information within the referral record.
Staff Referral Automation
When a staff referral reaches the agreed business stage, the system calculates the applicable staff referral bonus based on configured business rules and notifies the relevant internal users.
Internal Adviser Referral Payment
For internal adviser referrals, the system calculates the applicable payment based on the configured percentage of IAC and stores the payment information for tracking and audit purposes.
Reminder Automation
Automated reminders help ensure that required referral activities and follow-ups are completed on time.
The complete referral process was digitized into a structured workflow:
Submit Referral
↓
Validate Information
↓
Generate Referral ID
↓
Allocate Adviser
↓
Notify Adviser
↓
Track Referral Progress
↓
Trigger Follow-ups
↓
Calculate Applicable Payments
↓
Complete Referral
This creates a consistent process from the initial referral through to completion.
A major focus of the implementation was ensuring that automated workflows operate reliably without generating unnecessary duplicate notifications or incorrect payments.
We implemented several control mechanisms, including:
Power Automate trigger conditions were used to ensure workflows execute only when the required business criteria are met.
The system checks relevant field changes before triggering certain notifications, reducing unnecessary workflow executions.
Dedicated control fields help track whether a specific automation has already been executed.
The workflows maintain notification status to prevent the same communication from being repeatedly generated.
Business rules were designed to safely handle blank, null, and zero-value fields during calculations.
When a referral is reassigned, the system can identify the change and trigger the appropriate adviser notification.
Power Apps validation prevents incomplete or invalid information from being submitted.
Payment-related information is maintained within the referral record, providing greater transparency and auditability.
The solution follows a simple Microsoft Power Platform architecture:
Users
↓
Power Apps Canvas Application
↓
SharePoint Online
↓
Power Automate Workflows
↓
Microsoft 365 Outlook
This architecture enables the organization to manage referral information centrally while automating communication and business processes.
| Technology | Purpose |
|---|---|
| Microsoft Power Apps | Canvas application for referral submission and management |
| Microsoft SharePoint Online | Centralized referral and adviser data management |
| Microsoft Power Automate | Workflow automation, notifications, reminders and calculations |
| Microsoft 365 Outlook | Automated email communication |
The implementation delivered a more structured and automated referral management process.
Automated notifications, follow-ups, reminders, and calculations reduce repetitive administrative work.
Advisers receive automated notifications when referrals are assigned or reassigned.
Users can track referral status, outcomes, follow-ups, and payment information from a centralized system.
Automation controls and trigger conditions reduce the risk of duplicate notifications and repeated processing.
Validation rules and standardized forms help ensure that referral information is captured consistently.
Configured business rules allow applicable staff and adviser referral payments to be calculated automatically.
Referral and payment information is maintained in a structured and traceable format.
The Power Platform architecture provides a foundation that can be extended with additional workflows, reporting, integrations, and business rules as requirements evolve.
Trasol successfully transformed the referral process into a centralized digital and automated solution.
The new system provides a single platform for managing referrals while automating key activities such as adviser allocation, notifications, follow-ups, reminders, and payment calculations.
By combining Power Apps, SharePoint Online, and Power Automate, the organization gained greater process visibility, reduced manual administration, improved data consistency, and established a more reliable referral lifecycle.
The solution also provides a scalable foundation for future enhancements, including advanced reporting, dashboards, additional integrations, and expanded automation.
At Trasol, we help organizations transform manual business processes into secure, scalable, and automated digital solutions using Microsoft Power Platform.
Our expertise includes:
Power Apps | Power Automate | SharePoint Online | Dataverse | Power BI | Power Pages | Microsoft 365
Build smarter. Automate faster. Scale with confidence.