This blog post title was initially titled ‘Why I disregarded PowerApps but now I radically changed my mind’. I changed my mind and I now think that PowerApps is a very powerful tool and basically it does a lot of the app form functions that Access does but way better. I get it now and I want to explain how I changed my mind about PowerApps.
PowerApps performs the same function as Access can do: building the business apps you need and extend or customize the apps you already use. Only, PowerApps does it way better because it has the robustness, scalability, security and performance of the Azure cloud with Office365 inbuilt in the app from the start.
In this blog post, I’ll set out where I think PowerApps fits in the business, and why it’s way better than Access. There are plenty of PowerApps templates but I hope that this post will convince you to give it a try.
TL;DR – I care about producing business-friendly solutions that are maintainable, robust, perform well, have potential for scale, and that I can hand off to an IT support team. PowerApps gives me these things. Access does not because it is not always backed up, or placed on a network so people can update it, and it is not always secured properly. So you can think about migrating your Access apps to Power Apps, for example. In this blog post, we will answer the following questions:
- What can PowerApps do for you?
- How do you get started with PowerApps?
- What I’d like to see PowerApps do next
What can PowerApps do for you?
PowerApps allows you to design, create, use and share custom business apps with your team and organization. PowerApps installation means that you can use apps that have been shared with you, and it also means that you can create your own apps.
What kind of apps can you create? Intelligent laziness is very important! The automation of tasks means that you can focus on the activities that are more meaningful and add more value to the organization. If you are leading a team, then it means that you and your team can work wherever you happen to be, on any device.
What kind of apps can you create? Many Access forms could be redone in PowerApps since they involve data entry. Here are some examples:
- Connect apps to your existing data, such as SharePoint, Salesforce, Dropbox, Google Drive and more
- Create and update customer invoice, receipt and order forms
- Create Helpdesk apps
- Create Expense apps
As a BI person, I have spent time curing businesses from cottage industry Access databases and Access forms. Often, in my experience of rescuing Access databases and forms, I find that they proliferate through the business, usually unmonitored, untested properly and aren’t always production ready. They are often built in an ad-hoc fashion. In short, when I find some Access, I perform an internal sigh and I immediately start to mastermind it’s replacement. Access is often a the sticking plaster to solve a genuine business problem and it is quick to produce something quick. As Brent Ozar puts it, Access has Play-Doh factor. Yes, it’s an old post from Brent Ozar ( b ¦ t ) but it is still holding true.
So when I saw PowerApps at first, my reaction was ‘Oh no, it’s the new Access’. My initial vision was that developers would hate it, and I’d spend my life running around chasing after apps as well as Access to make them production ready.
So here’s what I found:
PowerApps has the IT guardian role built in
PowerApps solves the Access problem of scaleability, robustness and performance. PowerApps is built in Azure as part of Office365 so that means that Azure takes care of these factors for you. For me, this is a massive relief because I care about producing solutions that are maintainable, robust, perform well, have potential for scale, and that I can hand off to an IT support team. When I leave site, I want to leave with a job well done. I don’t intend to be there forever; it’s not what I do. So I like to enable others and bring people on a journey that they can continue without me. So what does PowerApps mean for the small business?
PowerApps for the Small Business
PowerApps is robust and secure. If you are using Access or Excel to run your business, then you should consider PowerApps. It provides a much more robust way for small companies to track data and projects than Excel or Word because it is in the cloud so you don’t need to worry about losing or screwing up your Excel spreadsheet of inventory, orders and so on. Also, it means that you can be more confident that your data is secure because it is in the cloud, and not on a USB.
PowerApps is mobile. It is also an easy way to mobilise apps as well. The functionality is built in. This is another big win over Access, in my book. This means that PowerApps has the most value added for tracking your organization in terms of projects, budgets, and growth.
PowerApps lets IT do their job more easily. PowerApps will give your IT people an easier way to manage your business-built apps rather than having them hidden on a laptop somewhere. PowerApps lets IT do their job, of being the guardian of the data and the IT function. It’s easy to maintain, which is idea for the organic business user turned power user turned ad-hoc techie. The idea of creating databases and trying to maintain them seems like an unnecessary use of resources; however, for small businesses, PowerApps creates a database for you so you can focus on what you need to do for your organization: managing growth and delivering success.
PowerApps has Play-Doh factor but in a good way. Creating apps in PowerApps allows a business to customize its own apps, thereby streamlining business processes. For example, you can use it to track crucial business information for each customer, including contact information, addresses, order information, invoices, and payments. Since it is in the Azure cloud, team members can access and update it, so the information can stay current and secured. Since the frm is a central idea to Power Apps, this helps small businesses ensure that employees enter data accurately and consistently so your data is cleaner at source.
How do you get started with PowerApps?
At a high level, here are the steps:
- Choose from professionally designed templates to start quickly
- Start with a blank canvas, and customize to suit your needs
- Add business logic and intelligence using the power of Excel-like expressions
- Create interactive visuals and media to build unique, professional apps
PowerApps is an easy jump for the BI Developer who already knows DAX. To create more custom apps, PowerApps has some object-oriented ‘formula’ that you can change, configure and set. It also has intellisense so you are guided to program correctly.
PowerApps is constantly being updated. For information about what’s new in this release, please see this topic: https://aka.ms/powerapps-releasenotes