PowerApps is a service for creating business apps across platforms quickly and easily.
Let’s face it the business word no longer relies on one application to complete their business needs. The days of working in silo or relying on a single platform for completing tasks are over. PowerApps allows you to take your business collaboration to the next level. You can interact with data from any and all data sources. Furthermore, it allows you to loop in your field workers. Data can be reported to and from field workers and desktop users in real time via apps.
To accommodate this, business would traditionally need to create custom coded apps. Creating custom mobile apps from scratch is expensive and most business don’t have the IT resources to dedicate to it. In addition, the return on investment is not great when the time and cost is so high.
PowerApps takes that all away by enabling power users and developers to quickly create apps in hours instead of months.
In the apps store, users can download PowerApps and log in using their Office 365 account. Once logged in, all apps shared with that user will be listed.
For those organizations coming from earlier versions of SharePoint, you may have used InfoPath for creating custom SharePoint forms. Microsoft has announced that InfoPath will no longer be supported in 2026 and PowerApps is the official replacement for InfoPath. But it is NOT a one for one replacement. InfoPath and PowerApps both allow you to create custom SharePoint forms but that is where their similarities end.
InfoPath is a third-party product for SharePoint that allows you to customize forms. PowerApps is not exclusive to SharePoint. Data can be stored anywhere. You can connect data from anywhere. It can be used as a standalone app or as a custom form.
Unfortunately, you cannot automatically convert your old InfoPath solutions to PowerApps. The solutions will have to be rebuilt with PowerApps.
PowerApps designer studio is used to create apps. This can be downloaded from the app stored or you can use the online version. Currently, the online version has the same features and capabilities as the application, so I use the online studio.
Link to PowerApps Studio: https://create.powerapps.com/studio/
PowerApps come with multiple templates that you can use as a starting point. This will allow you to explore the different components and formulas in an existing, functional app. It will give you a feel for what you can do and how you can leverage PowerApps. You can customize the templates further or use them as is.
There are 2 options / starting points for PowerApps. You can create a standalone app or customize an existing SharePoint list form. If you choose to customize a list form, this will replace the default edit/new item forms with your app.
In order to customize a list form, navigate to the SharePoint list and select the dropdown for PowerApps. Select customize forms from the dropdown. (The other 2 options will take you to the PowerApps studio.)
Otherwise, if you are starting an app from another data source or from scratch, navigate to the PowerApps studio.
Link to PowerApps Studio: https://create.powerapps.com/studio/
There are 3 basic steps for creating your app:
These are the main components for your PowerApp:
Every app will contain at least 1 Screen and controls to input or display data. Most of the designing in your app is through the control properties. The control properties can be set to actual values or you can set it to values based on other values using formulas.
The formulas used in PowerApps are based on an excel-like inspired language also known as declarative logic. The app is constantly recalculating values based on the current input or state of the controls on the form. For example, in excel if you want to calculate the total value of a row, you would add a formula to a cell that will add up all the cells in that rows value. PowerApps works the same way. However, instead of calculating values based on other cells, it calculates values based on other controls (other text boxes, dropdown menus, galleries, etc).
And of course, the best way to learn is to get started and try it out!
Do you want to learn more about SharePoint and Office 365? Join a SharePoint Learning Tree course!