Leave Calendar - Power Automate and Power Apps
The client wanted information from their third-party leave calendar tool (Timetastic) embedded within their SharePoint site.
Case Study100%
reduction in manual effort, enabling instant report generation and seamless sharing
50%
faster report generation, optimising SQL views and automating Power BI processes
95%
improvement in data accuracy, ensuring reliable and consistent revenue reporting
70%
increase in user engagement, driving better adoption and interaction with reports
The Challenge
The client needed a way to quickly view employees on leave within the next two weeks, with the leave types color-coded for clarity, similar to the layout in the Timetastic tool. The calendar view had to preserve the existing order of users, with clear markings for the current day and weekends. Aesthetically, it was essential that the display closely resembled the third-party Timetastic application.
Our Solution
To meet the client’s requirements, we explored various methods for retrieving and displaying Timetastic data within SharePoint. Since no pre-built connectors were available, we opted for a custom solution. After evaluating multiple approaches, such as building a SharePoint web part using React JS, creating a custom Power BI report, or developing a bespoke Power App, we chose to move forward with a custom Power App integrated with Dataverse.
We started by designing a suitable data table within Dataverse to store the leave records. Using Power Automate, we sent an HTTP GET request to retrieve existing Timetastic data, which was then synced to our Dataverse table via a webhook for real-time updates. Finally, we constructed a calendar in Power Apps, linking it to Dataverse to ensure the dynamic display of leave data in a format that mirrored the Timetastic tool.
The Result
This solution allowed the client to access a real-time, visually familiar calendar displaying employee leave for the upcoming fortnight. The integration of Timetastic data with Dataverse and Power Apps provided a seamless, efficient experience that met both functional and aesthetic requirements.
Other Case Studies
At Synapx, we’re proud to show how our solutions have transformed the way our clients work and operate. Below you can see our latest client project.
Learn Fast - Share Knowledge, Scale Adoption
Centralised Subscriber Data Integration with Power Automate
The client approached Synapx for support with the Power Platform through a time-and-materials engagement. The project focused on centralising subscriber data management and streamlining processes. This involved integrating three distinct mailing list forms into a unified database to enable efficient...
Migrating Power BI to Fabric Lakehouse with Medallion Architecture
The client approached us to automate their material transfer processes between internal and external sites. The project aimed to centralise operations and improve efficiency by replacing their manual methods with an automated system for real-time tracking. We delivered the solution...
Power BI Reporting & Power Apps AVC Calculator
The client approached Synapx to provide Power Platform support under a time-and-materials engagement. The project aimed to enhance data analytics and streamline business processes through Power BI implementation and creation of an AV Calculator from Excel to Power Apps,...
Power Platform Center of Excellence Implementation - Power BI
The client approached us in order to implement a reporting system to provide oversight on the implementation of power-platform within their organisation.
Material Management Application with Business Central Automation - Power Apps with Power Automate
The client approached us needing a system to automate their processes for managing the transfer of different materials held in piles between their internal and external sites.
Policies and Procedures - Power Apps with SharePoint Documents Library
The client wanted an application to effectively manage their companies policies and procedures from within a SharePoint documents library.
Personnel Directory - Power Apps
The client wanted a directory within their SharePoint site to display all their staff members, and provided key contact details such as their phone number and email address.
Leave Calendar - Power Automate and Power Apps
The client wanted information from their third-party leave calendar tool (Timetastic) embedded within their SharePoint site.
Book A Free Discovery Session
Schedule a FREE call with our power platform specialists.
Book a Discovery Session