Checking in with Power Apps, Flow and Power BI

Asgeir Gunnarsson

In this session, we will create a Power App that will allow users to check in at their location. We will then create a Flow that will take that location and write to a Power BI data source and refresh it. We will then create a Power BI report that will display the data on a map.

Power Apps is a great tool that allows you to create a desktop or mobile app with minimal coding. The app we are creating in this session uses the Bing location services to get the user’s location when a button is pressed. Microsoft Flow is similarly a tool that allows you to create data flows and logic with minimal coding. The flow we create in this session will take the location and user information and write it into an Excel file. We will then create a custom connector in Flow that will allow us to refresh a Power BI data set. This will mean that the data will be visible in the Power BI report almost as soon as the user presses the check-in button. Power BI is a self-service reporting tool that allows you to connect to multiple data sources and mash-up data into a beautiful report or dashboard. In the report that we will create in this session, we will connect to an Excel file with the location information in it and display it in a report including the location on a map.

The audience will take away useful information about Power Apps, Flow, and Power BI including all the code created during this demo.