Leave Calendar - Power Automate and Power Apps

The client wanted information from their third-party leave calendar tool (Timetastic) embedded within their SharePoint site.

Power Apps, Power Automate

Written by

Agusthi Bakhshi

Published on

August 22, 2023

Customer

UK Asset Management Company - Power Apps

Organisation Size

30

The Challenge

At a glance they wanted to see those on leave within the fortnight as displayed within the Timetastic tool itself. Each leave type would be distinguishable by it’s color, and the ordering of users within the calendar would be set within the application itself. Dates such as the current day and weekends would need to be marked and the aesthetic would need to replicate the third-party application as close as possible.

Microsoft Power Automate Logo

Our Approach & Solution

In order to achieve the clients requirement we researched various options available for retrieving and displaying data from Timetastic within SharePoint. As there were no pre-built connectors for Timetastic in SharePoint it was apparent we would need to build something bespoke; our options were to build a webpart using React JS within SharePoint, built a custom Power BI report or Build a Custom Power App. The first step was to design the desired table within Dataverse, we then retrieved existing records from Timetastic using a HTTP GET request on Power Automate, and linked Timetastic to our table by creating a web-hook allowing for real-time sync. We then constructed the calendar on Power Apps and linked it to our Dataverse table.

The Outcome

We were able to create an application which displayed leave data in real-time, and demonstrated the power of using API’s to link systems together. We were also able to add some additional features such as the ability to search for a user, and control the ordering of users displayed on the calendar. We were able to display different leave types by different colours and provide a tooltip displaying further information when hovering over a users leave.

Related Case Studies

Take a look at similar case studies stories from our other clients

Internal Controls Risk Register - Power Apps

UK Asset Management Company

The client wanted an application to manage risks within their business by ensuring they had relevant controls in place.

View Case Study

Power Automate - Excel Process Automation

Global Asset Management Company

This company approached us as they were having to manually format and update Excel workbooks daily, taking a considerable amount of time out of their day, doing the same task day upon day. We at Synapx engaged with the stakeholders,...

View Case Study

Power Apps - Contract Management System

Financial Services client

This company approached us after becoming frustrated with their data quality. They were spending large amounts of time sifting through unorganised, messy data.

We worked closely with their Ops director and Database Administrators to provide a service which met the...

View Case Study
View All Case Studies