03-25-2020 11:52 AM
In a health emergency like the Covid-19 pandemic, hospitals can be overwhelmed with the number of patients in ICUs or isolation care units leaving no time for healthcare professionals to communicate with relatives. This situation makes it difficult for the patient’s family to receive updates on the status of their relatives as in most cases, they cannot enter the Hospital or communicate directly with the healthcare professionals. That is the experience that many families are enduring during the Covid-19 pandemic in different countries.
This application is a PowerApps Portal that facilitates access to medical reports for the patient’s family. They can use a unique patient code to register on the portal and access the latest updates on the evolution of their loved ones, freeing time from healthcare staff to focus on dealing with the critical tasks on the healthcare crisis.
A group of MVPs and volunteers built this application with the support of Microsoft Spain to support the Madrid public health system during the Covid-19 emergency.
Hello Any chance we can get more information about this great looking application?
I'll try to give you a bit more detail about the features. The app is still evolving as we get new requirements while dealing with this health crisis. We haven't yet published the solution anywhere, and we are actively changing it as we go. I'll update this thread as soon as we can to share more.
If anyone needs access, please reach out, and we will find a way to share it. We have just made it available for another regional health-care system in their separate tenant. The solution is currently in Spanish and parts of it would need translation.
You can check the screens on the original post to get an idea, but I'll try to detail the functionality.
The solution consists of a Portal App and two Model-Driven Apps. There are two main use cases currently being rolled out. One to provide updates on the patient's status to relatives and the other is to coordinate volunteers supporting disabled and older people in isolation.
Portal for Family Members:
- Admissions teams at hospitals give a unique invitation code which is a combination of a patient number and the family member ID / Passport number.
- A family member goes to the Portal Power App to exchange that code for a new account - they can also associate it with an existing account if they already have another relative hospitalised.
- There is a Power Automate Flow that links the patient reports to the relative contact record on successful redeem of the invite.
- Family members can log into the portal at any time to check the latest medical updates available for their relatives. They also get email alerts generated via Power Automate flows when a new update is available.
Portal for Volunteers:
- When the coordination team enrolls new volunteers, they register them in the portal with an invite that is associated to a Volunteer Web Role. This opens access to the Volunteer section of the portal.
- Volunteers redeem the invite for an account on the portal.
- Volunteers can see a list of pending and completed tasks assigned to them. They can check the details of the tasks and update the status until completion.
- When the coordination team assigns a task to a volunteer, they get an email from Power Automate with a link to review the task in the portal and accept it or reject it.
Patients Management Model-Driven App:
- Used by the operations team to manage Relatives (Contacts), Patients (Custom entity) and Updates (Custom Entity). As well as Portal Invites and other settings.
- This app is only used if required for manual updates and setup of relatives. There is also a Power Automate flow capable of importing a CSV file coming directly from Hospitals. This flow takes care of creating new relatives records and generating the invitation codes for redemption. Thus, the process is fully automated to deal with high-volumes.
Volunteers Management Model-Driven App:
- Coordinators can setup volunteers as contacts. They can also generate a portal invite to enable them to manage their tasks in the portal.
- People requiring assistance are also contacts in the app - with a different contact type. We have added a few customisations to allows us to track what kind of support they need (grocery shopping, meds, walking the dog, etc.)
- Coordinators schedule the tasks and assign them to volunteers. Volunteers receive a notification and accept it via the portal. There is an SLA timer that alerts the coordinators if no action is taking after assigning the task.
- Once the job is closed, the coordination team calls the person needing support to check on them and get a rating on the volunteer. This is recorded against the task, and an average is rolled-up for the volunteer.