A case on how Power Apps helped a hospital standardize mortality reporting formats to meet both internal and regulatory requirements.
The Client
The client is a private, not-for-profit hospital in the UAE, known for its deep-rooted commitment to compassionate care. With a strong foundation in serving women, children, and families, it is guided by values like integrity, humility, and excellence. The hospital blends medical expertise with a people-first approach, creating an environment that treats every individual with dignity and respect. They continue to uphold international care standards while staying grounded in their founding principles.
Challenges Faced by the Client
Tracking infant and maternal death rates is a sensitive and critical responsibility for the client. Their medical review teams needed a dependable way to collect, monitor, and assess mortality data over time, both for internal audits and external reporting. However, the process was not as efficient or consistent as needed.
Some of the key issues they were facing included:
- Manual data entry in spreadsheets: Mortality case details were recorded in Excel files, which made version control messy and tracking updates difficult.
- Lack of structured workflows: There was no clear system for assigning, reviewing, or approving mortality case reports, often leading to delays or missing inputs.
- Limited audit traceability: Without centralized access or standardized forms, audits and regulatory submissions were chaotic and sometimes incomplete.
Solutions
Upon understanding the client’s existing tracking method, we recommended a structured digital solution using Power Apps and Power Automate. We built a custom Canvas App, backed by SharePoint for data storage and automation to handle inter-departmental handoffs and communication.
Here is how we addressed their concerns:
- Form Initiation at Reception: The process begins at the front desk, where a patient’s attendant or hospital receptionist initiates a new mortality form directly from the app. The form is designed with 11 well-defined sections and over 150 fields, of which 54 are mandatory for submission.
- Automated Case Alerts: As one department completes filling their respective section, the app triggers a flow that notifies the next assigned department or team member via email.
- Structured Data Storage: All data entered into the form is structured and saved using JSON formatting within SharePoint. This helps maintain clarity between sections when data is retrieved for viewing or editing.
- Final Review by Clinical Team: Each department, whether it is nursing, pediatrics, obstetrics, or administration, has access to the app, allowing them to update their section or review entries assigned to them. The system tracks who completed what, ensuring role-based collaboration is intact.
- Role-based Access Control: Once all sections are filled and the form is marked complete, reviewers (often senior clinical staff) access the same form via a View screen. From here, they conduct their review and confirm the final details for closure.
- API-based Submission to DoH: After the final review, automation takes over again to send the collected data to the Department of Health (DoH) through a secure API call. The API flow includes authentication and a record of the action, so the hospital stays compliant with external reporting requirements.
Solutions Benefits
- No More Manual Tracking: Staff no longer use Excel or paper forms — everything is now filled and stored digitally in one place.
- Faster Case Handling: Departments are notified automatically after each step, so the form moves along without anyone needing to follow up manually.
- Better Data Quality: With 54 required fields and guided form sections, the chances of missing or incorrect information are much lower.
- Real-time Dashboard: A live dashboard is added for better visibility, showing real-time stats like the number of cases per month, and reviewer assignments, all searchable and filterable by time.
- Audit-ready Form: Every entry and change can be tracked through SharePoint, making it easier for teams to handle internal reviews and external audits.
Conclusion
The client successfully transitioned from manual Excel-based tracking to a fully digital, user-friendly mortality review system. With automated reporting to the Department of Health, the hospital now stays compliant while ensuring greater transparency in its medical review processes. The system also gives every department the clarity and structure they need to collaborate better. At UB Technology Innovations, Inc., we don’t just recommend digital solutions; we guide healthcare teams with the right approach and always go the extra mile.
About Us
UB Technology Innovations, Inc. (UBTI) is a leading global technology solution provider with over 3 decades of experience across all industries, specializing in Capital Markets, Logistics, and Healthcare. We are the preferred Microsoft Solutions Partner backed by a world-class team of Microsoft Certified experts with rich experience in Azure Cloud Platform and Data Analytics.
Winner of the prestigious Azure
Synapse Hackathon 2021 award
One of the Top 10 winners of the
Microsoft’s Azure AI & ML Workathon