How can healthcare organisations leverage Power Apps to resource and distribute PPE effectively?

Healthcare workers across the UK are relying on personal protective equipment (PPE) to protect themselves and others from being infected during Covid-19. However, shortages are leaving key frontline workers worryingly ill-equipped. Since the start of the Covid-19 outbreak, the demand for surgical masks has increased six-fold and the number of gowns has doubled.

Health and Social Care Secretary, Matt Hancock published a UK-wide plan to ensure that critical PPE is delivered to those on the frontline responding to coronavirus.

But with 27% of healthcare workers surveyed reporting that PPE is not very available in their place of work, with another 8% saying PPE was not available at all and the number of cases in the UK still high, how can healthcare organisations leverage Power Apps to resource and distribute PPE effectively?

Could Microsoft Power Apps hold the answer? Let’s find out…

We’ve been busy developing an app on the Power Platform that will enable healthcare organisations to better understand PPE stock levels and manage where they are distributed.

By leveraging tools such as Microsoft Forms Pro, Power Automate, Common Data Service and Power BI, the solution, designed for area managers of healthcare organisations, will offer insights into where more equipment is needed in real time.

Starting with Microsoft Forms, a survey is sent to area mangers of healthcare organisations such as care homes, district nurses and hospitals to get a situation report on what their current status is and how they are coping with PPE levels.

Each type of healthcare organisation has a set template to make sure the data is that comes back is relevant and the appropriate support can be provided. Using Power Automate, the survey can be sent regularly to organisations of a certain type during a set time period.

The user friendly form is designed to offer collect a well-rounded over view of the current situation at that particular healthcare organisation, gathering data on whether the organisation is open, how many staff are available, any issues they are having, how much PPE they have and when they will need more and if they are having an supplying issues.

This data is stored securely in the CDS to create a contact profile for each individual organisation. The system also stores the organisations’ answers to previous forms. Allowing for users to analyse how equipment levels change. All the data can be visualised in Power BI dashboards. Users can filter by region, see expected vs actual equipment levels and PPE conditions, all in real time.

Once equipment levels reach certain thresholds, the system will automate a task to send out required PPE as soon as it’s needed.

This app built in a matter of hours and can be customised to meet the needs of any healthcare organisations battling Covid-19.

Watch the video to learn more about the solution and see it in action. And if you still can’t get enough of Power Apps, head to our hub for everything you need to know.

Innovation Hub

Check out some other blog