Microsoft PowerApps provides a large range of connectors to access data from external services. However, when the service you require is not there what options are available?
One recent scenario I had was to provide a display of the bookings in our organisation's meeting rooms on a given day. We use Exchange Online, as part of Office 365, to manage our meeting room calendars. I needed a way to connect to these meeting room calendars and present the information easily and quickly.
Happily, PowerApps provides the ability to define a custom connector allowing you to access a Web API which provides quite allot of potential.
Using Azure Functions, its possible to create an API that will expose details of meeting room lists (e.g. meeting rooms per building), meeting rooms for a given list and the bookings for a meeting room on a given day.
This API can be used with PowerApps, via the custom connector, to create the solution:
Over a series of posts, I will go through how to build the solution: