PowerApps and Flow Recommendation

Development

Requirements PowerApps + Flow SharePoint App + Logic App Custom Cloud App
Requires Coding / Development Skills No(t really) Yes Yes
Cost of Development Low Medium High
OOTB Support for (SP) Lookup Fields Yes Yes N.A.
OOTB Support for People Picker Yes Yes Custom
OOTB Support for People Picker (Multi) No Yes Custom
OOTB Support for Multilingual Yes Yes Custom
OOTB Support for Taxonomy Picker No (Roadmap) Yes Custom
OOTB Support for Global App State Yes Yes (Optionally Redux) Custom
OOTB Support for Custom Fields / Validations Yes Yes Custom
OOTB Support for Deep Links Yes Yes Custom
OOTB Interation with Flow Yes Yes (HTTP triggered) Yes (HTTP triggered)
OOTB Interation with Logic Apps Yes (Custom API) Yes (HTTP triggered) Yes (HTTP triggered)
Complex Forms Limited Yes Yes
Ease of Coding / Code Editor (App) No (see 1) Yes e.g. VS Code Yes e.g. VS Studio
Ease of Coding / Code Editor (Workflow) Yes (see 2) Yes e.g. VS Studio Yes e.g. VS Studio
Business Logic in one place / Architecture No (see 3) Yes Yes
Unit Test No Yes Yes
End user can test Yes Yes Yes
automated testing No Yes Yes

Maintainability

Requirements PowerApps + Flow SharePoint App + Logic App Custom Cloud App
All artifacts in one solution No (see 4) Yes Yes
App provisioning can be fully automated No Yes (VSTS CI/CD) Yes (VSTS CI/CD)
Ease of deploy from Dev to Test to Prod No Yes (VSTS CI/CD) Yes (VSTS CI/CD)
Solution is easily portable No (see 5) Yes (VSTS CI/CD) Yes (VSTS CI/CD)
Solution can be easily refactored No (see 3) Yes Yes
Defect analysis Cumbersome Fairly easy Fairly easy

Connectivity

Requirements PowerApps + Flow SharePoint App + Logic App Custom Cloud App
OOTB connect to SharePoint Online Yes Yes Yes (CSOM)
OOTB connect to Azure SQL DB Yes No (custom Web API) Yes (SQL Connection)
OOTB available for External Users No Yes No (custom AAD Int.)

Governance

Requirements PowerApps + Flow SharePoint App + Logic App Custom Cloud App
Supported by IT No Yes Yes
Nr. of App Owners / Editors can be limited Yes Yes Yes
Ownership can be transferred No (see 6) Yes Yes
Access can be restricted Yes Yes No (custom AAD Int.)
Code versioning Yes Yes (VSTS CI/CD) Yes (VSTS CI/CD)
Code can be saved in source safe system No (manually) Yes (VSTS CI/CD) Yes (VSTS CI/CD)
  1. Lacks Intellisense, code formatting and checking.
  2. Flow Editor offers intellisense and code checking but the experience is far from pleasant.
  3. Formulas are “hidden” in Screen Loading events etc.
  4. SharePoint and other dependencies need to be provided separately.
  5. PowerApps and Flows can be exported but require manual steps to make it work.
  6. For PowerApps not but Flows can be changed into Team Flows.

You May Also Like

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: