Jo Karnes was recently approved for the Preview version of Microsoft’s upcoming offering: PowerApps.
Here, she shares some initial thoughts as she tries it out.
What is Microsoft PowerApps?
PowerApps is a GUI-based tool that allows business and IT users to create mobile-based organization applications without the need to write extensive code.
For example, let’s say you’re a small company and you currently have all of your users submit an Excel sheet for their time or expenses. At the end of the month, someone in your organization consolidates those Excel sheets into one big Excel sheet and sends them over to Accounting for approval – basically, a big and inefficient way of doing things.
The goal for PowerApps is to allow you to quickly and easily connect to a data source (in this case we can use it to connect to that consolidated Excel sheet) where it can read the fields and then create views that will allow you to search, view and edit those fields in a mobile application.
In addition, you can add logic behind the scenes, so that when Employee A uses this new app to submit his expenses to the data source, it can first go through an approval process before it is submitted – all without writing code (however, formulas will need to be added; I’ll dive into these in a later post) and presented in a mobile view users are comfortable with:
What Else Can PowerApps Do?
While this is still in preview, PowerApps can accomplish some very powerful tasks right out of the box. It currently has 10 predefined connectors to allow you to connect your PowerApps to several cloud-based data sources, including Dropbox; Dynamics CRM Online; Google Drive; Microsoft Translator; Office 365 Outlook; Office 365 Users; OneDrive; SalesForce; SharePoint Online; and Twitter. But even in preview, you also have the option of connecting your own API’s to PowerApps through Azure. You’re not limited to just predefined data sources.
PowerApps also provides a web-based builder GUI, and a Windows 10 app-based builder GUI. While there are some limitations between using the web-based GUI (mostly around using predefined templates to build the app), the Windows 10 App fills in those gaps. Over the next few posts, I will get hands-on in building a sample PowerApp, and flesh out those differences in greater detail.
Where Is the Benefit?
Organizations are becoming more diverse each day in how they expect their employees to create and consume data, and mobility is a key driver in that. One of the greatest disadvantages in many corporate tools in recent years is the lack of mobility options for line-of-business applications, whether they be third-party or just home-grown business processes.
This is Microsoft’s big attempt to bring mobility to the forefront and allow business users to develop applications on their terms, and not necessarily a vendor’s. It also can help business and IT collaborate in other ways, by bringing an easy-to-use and useful tool that can be leveraged by both sides of the house.
I’m excited by the possibilities of PowerApps and hope Microsoft can really execute on this vision, as it could become a widely-used application in many organizations – if it’s done right.
Originally published on Jo’s blog, Office – 365 Days a Year: Fun with Microsoft.
Moving to Microsoft Office 365 is about more than migrating email to the cloud. It’s about digital transformation and workplace collaboration.
That’s where our Enterprise Collaboration Practice comes in. We focus on all aspects of the adoption lifecycle and go beyond technical configuration to drive successful, long-term adoption of Office 365.