Microsoft PowerApps | Case Study | Attendance System

Case Study
Microsoft PowerApps

Australian NGO leverages
Microsoft Power Platform to streamline kids’ attendance system to manage their safety and wellness

Industry: NPO
SharePoint PowerApps Microsoft Flow Bing Maps

Client Background

Our client is a Western Australia-based non-profit organization that works with young people and families to increase their participation in employment, training, and education opportunities. They aim to build capacity by empowering them to reach their full potential and provide support to and positively engage with children, young people, and families. They also manage services and programs for the provision of youth and family support in accordance with the funding guidelines and strategic direction of the association.

Situation

With the aim of increasing the engagement and skills of children, young people, and families, the NGO offers several programs and activities every day. These activities are open to all those who are homeless and cannot afford to spend the night in a safe zone.

  • The NGO needed a system in place where they could manage the attendance system (check-in and check-out) of these children from specific locations to the activity center and drop off.
  • They provided buses and vans in specific areas and picks up students, children, and young people who are on the street and attendance was captured on the location of pick-up and drop
  • They have specific activities as per age group, gender, and communities.
  • They take care of specific communities that are exposed to anti-social activities, especially during the afternoon and night time.

Solution

powerapps for office 365

Leveraging Office 365 License and PowerApps services

Understanding the requirement of the client, we suggested using Power Platform, especially PowerApps, to create an attendance management system. They already had an Office 365 and SharePoint license, and this could help them to use it to its full potential.

sharepoint powerapps

Integration of PowerApps with SharePoint and Bing Maps

We decided to create a complete list of all children, youth, and families who were participating in the various programs. This list was created in SharePoint, which was then integrated within the PowerApps. The NGO also wanted to track the location of each participant who was checking-in, so we suggested integrating the app with Bing Maps to track the location.

powerapps functions

Enterprise Mobility, Flexibility and Easy to Use the App

We created an enterprise-level application that was integrated with their SharePoint list. They could easily manage, add, or delete names of participants in this list. Their faculties that were responsible for managing the pickup and drop off participants had installed this application on their mobile phones. All they had to do was choose the right activity and the correct participant name and click the check-in button at the time of pick up and check-out at the time of drop off. The data was again saved in the SharePoint list.

Power BI

Power BI Enabled Reports

The admin department was responsible for keeping track of detailed information as to how many children, youth, and families were benefitted on a daily, weekly, and monthly basis with each of their programs. For this, we suggested using Power BI and creating extremely intuitive and informative dashboards and reports which were customizable as well.

Benefits

  • The NGO could get an enterprise-level application in a very short span of time.
  • They could save on cost just because the development of applications using PowerApps was far cheaper than custom application development.
  • Sharing of application internally with several faculty members at a time was very easy as the application was available on Teams.
  • The application was on mobile, so it was available anytime, anywhere, on the go.
  • The admin could easily keep track of how many participants were benefitting from each program and activity.
microsoft powerapps examples
microsoft powerapps examples

Explore more about Beyond Intranet’s
PowerApps service offerings

Our Resources

True SharePoint Experts!

We have worked with Beyond key on the development of our company intranet which is hosted in [...]

Our Resources

Excellent Tool and Customer Support

This tool is excellent, it is simple to use and configure and meets our business need.[...]

Our Resources

Amazing APP & support. Don't change.

We are using this as a people finder for our college. We did look at a few options[...]

Our Resources

Outstanding Support

App worked out of the box, I had a few questions on configuration so I email[...]

9 Best practices for flawless Employee Offboarding

9 Best practices for flawless Employee Offboarding

No company likes employees leaving the organization when they become assets to the whole system. Inevitably, all organizations lose some people over time. Once an employee has given notice, it also becomes important for HRs to transition them out of the workforce as[…]

Read More
Use the News web part on a SharePoint page

Use the News web part on a SharePoint page

Web parts are the main characteristic of your page in the site. One such dynamic web part is the news web part, which you can easily use to engage the audience and inform them about important announcements, status updates, and more. Here’s a small guide on how […]

Read More
How to get Custom Theme for your Modern SharePoint site

How to get Custom Theme for your Modern SharePoint site

A couple of months ago, Microsoft introduced new branding and theming capabilities for the Modern SharePoint sites in Office 365. It came up with eight attractive themes which were in-built and you could simply choose any one and apply […]

Read More

Let’s Discuss Your Project