With more than 73% of French people having a smartphone in 2018 according to a Credoc study and 67% of web access now taking place via a mobile device, we can no longer dispute this reality: smartphones and tablets are fully integrated into our daily habits.
This is all the more true in the professional sphere, where cloud services and multiple innovations in Web languages allow decision-makers and entrepreneurs to pursue their activity at any time, in any place. Working as a perfect nomad, carrying your office and tools with you, has become more than ever a reality today. But these devices and these habits of a new type also call for a profound change in the tools and means of access to data.
What is Microsoft Power Apps?
This is precisely where Microsoft PowerApps comes in, a powerful platform for developing business applications tailored for these mobile devices. In a few steps, you can thus prepare a real application dedicated to your activity and your needs: you connect your data to it and consult, manipulate or enrich it interactively, taking advantage of great flexibility and easy access. perfectly intuitive.
Thanks to Business Intelligence: create a mobile application adapted to your needs
First part of our series of tutorials devoted to this new way of integrating Business Intelligence into your activity, this file will guide you in getting started with the help of PowerApps consulting company. By following and adapting our examples, you will be able to create a real mobile application tailored to your needs, thanks to which you will be able to better manage your activity.
So remember the essential concept that governs the use of your mobile app: it will help ensure the convergence of data towards Power BI. You will thus integrate new information in an intuitive way that you can then use and analyze through the range of Power BI tools.
Prepare and access data in Microsoft Power Apps
To experience the Power Apps platform, first refer to the official Microsoft website and click on the “Get started for free” button.
Included in Microsoft Office 365 Business and Dynamics 365, Power Apps is also individually licensed starting at €5.90 per user per month. Do not hesitate to take advantage of the free 30-day trial version to discover the tool and its possibilities.
To prepare the ground, start by entering your e-mail address in the field provided for this purpose, then click on the button “Register”. You will then be invited to complete the registration form and then validate the procedure by entering a confidential code, automatically sent by e-mail. You’ll finally get to your Power Apps dashboard, which opens with a series of sample apps that you’ll be able to build through it.
As we saw in the preamble, PowerApps does not just create a series of “frozen” screens for your smartphone or tablet: access to data is at the center of your future applications and these allow you to monitor their progress in real time.
For this, the platform has nearly 200 “connectors” thanks to which you will link multiple types of data to the views you are preparing. Lists:
- Excel Online
- OneDrive for Business
- SQL Server
- Azure SQL
Database, One Drive or Outlook tasks: all these ready-to-use connectors facilitate the integration of data into your application and you create, by simple drag and drop, all the views necessary for your activity.
Here is an example of Business use of Power Apps:
In the context of this example, we are going to build a simple tool for supervising the leave of employees of a VSE/SME. You can obviously adapt it to any type of data, this is one of the great strengths of Power Apps.
We will thus start by creating a new workbook in Excel 2016, before saving it in OneDrive in order to update it dynamically from any Internet connection, thus getting rid of the frozen user station.
Prepare your data by indicating the nature of the columns on the first line: we are thus going to enter the name of the employees, the start and end date of their leave, their nature (sick leave, vacation, etc.) and their status (“leave in courses”, “holiday ended”…).
Select the set of data ranges, refer to the “Insert” tab of the top ribbon and then click the “Table” button. This turns all these elements into an array.
Save your document to One Drive, the cloud data sharing service.