Advantages, Disadvantages And Limitations Of PowerApps

Introduction

Advantages

• Power Apps comes integrated with Microsoft Flow.
• Power Apps is an alternative of Info-path forms and this can be used to create the responsive custom forms and connected to a verity of data sources
• Power Apps support Mobile devices as well. (Responsive UI)
• Power Apps integration with Office 365, Microsoft Flow, and Microsoft Power BI, it’s easy to get data into and out of SharePoint, or Excel, or any of the other 365 apps on which your business depends.
• It can connect a variety of data sources like SQL, SharePoint, PowerBI, Excel, MS Access, etc.
• Many standard data storage services are easy to connect to and use with Power Apps. Multiple OOTB connectors are available by default. (As per Power Apps license - Standard and Premium connectors are available to use)
• If you have Excel background & Logic concept, you can easily Make Apps (rather than writing Apps) within seconds as basic workable apps, using fast track mode, for a CRUD app -- (Less Code required)
• CSS writing is almost not required as Power Apps Studio is, just like PowerPoints, enable drag and drop, change and modify, from within Power Apps Studio. - CSS configuration can be done.

Disadvantages

Limitations

• In PowerApps, you can Retrieve only 500 items by defaults and it can be extended maximum up to 2000 (performance decreases)
• If we are using the Canvas application, then only one developer can work at a time.
• Attachment control will work fine with the SharePoint as a back-end. If we are using custom SQL then attachment control will disable. Workaround to use one-drive, SharePoint, etc. to store attachment and refer in the PowerApps.
• Can not integrate JavaScript in power apps forms
• PowerApps exists within the business context, and as such, are meant for internal use. Therefore, you can’t create a Power App and share it outside your organization. This has to do with the licensing model, as well as technical limitations when it comes to sharing them with external users.