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 AutomateWritten by
![](https://www.synapx.co.uk/wp-content/litespeed/avatar/10a9efe75229f0f68c1a001929387f28.jpg?ver=1725632286)
Published on
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](https://www.synapx.co.uk/wp-content/uploads/Microsoft-Power-Automate-Logo.png)
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.
![](https://www.synapx.co.uk/wp-content/uploads/Picture6.webp)
The Outcome
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.