Posted on
power apps

Wish to better know how your users are getting together with your atmosphere? Watch our free web seminar “Using Power BI &amp DocAve to visualise Workspace Usage &amp Permissions” today!

Searching for additional on Power Apps? Read our latest coverage:

Power Apps has shown itself like a great low-code solution for building effective forms to enhance business processes. One of the numerous advantages that Power Apps offers may be the ease that application makers can integrate with Office 365 along with other SaaS as well as on-premises profession data sources.

You will find generally two methods to performing CRUD (Create, Read, Update, Delete) operations in Power Apps. Application makers may either:

  1. Directly connect an application towards the data sources, or
  2. Leverage Power Automate flows which are known as to do these tasks.

You will find implications that approach an application maker chooses. In the following paragraphs, we’ll be searching in the data loading scenarios particularly.

Studying Large Data Takes hold an Application

Today, there is a limit to the amount of products that may be came back for an application from the databases. The default of 500 products could be elevated to no more than 2000 (under Advanced Settings for that application).

When the application tries to retrieve greater than 2000 products from the data set directly, just the first 2000 are came back. To enhance the performance of apps and overcome this limitation, functions for example Filter, Search, and LookUp coupled with delegation may be used to reduce the amount of products within the application.

The objective of delegation would be to pass the query straight to the information source to process the request and return the smaller sized data set towards the application. You could do when the databases is typical Data Service (CDS), SharePoint, or SQL Server. However, when the databases is one thing else, the information source will return the very first 2000 products and also the application will filter lower the outcomes.

Searching for ideas to get the most from Power Apps? Read this publish: Click To Tweet

Data Set Access

To have an application to gain access to data, the application user must have the data set. This really is fine when the user has permission to determine all of the data, but you will find occasions when an application user must only have limited accessibility databases (when the databases includes private information, for example). Such scenarios, the application builder might need to implement “security by obscurity,” an exercise in which the databases is hidden in the user however the user continues to be capable of getting towards the data.

Using Power Automate enables the application maker to produce flows that’ll be known as during OnStart(), OnVisible(), OnSelect(), or any other qualities from the application to do the information studying from sources the user may not need and apply filters towards the databases. As proven below, another flow may be required to gain access to a guaranteed databases the user does not need but demands data from using a service flow that comes with access.

power apps

Performance Implications

The Ability Automate approach extends the options from the Office 365 apps. However, additionally, it adds an amount of complexity and reduced performance towards the overall solution. The table below shows the outcomes of the experiment I conducted that measures time it requires an application to gain access to data from the SharePoint list when compared to time that it takes the application to retrieve exactly the same data utilizing a Power Automate flow like a conduit.

power apps

Within the experiment, I made use of an easy list with only a Title field (just one type of text) along with a complex list using the following fields:

  • Title (single type of text)
  • Number
  • Date
  • Person
  • Notes (multiple lines of text)

The experiment was repeated 10 occasions for lists that contains 10 products, 500 products, and 2000 products. Another experiment was performed in which a flow was known as by an application and came back nothing.

power apps

In the experiment, I concluded the next:

  1. Calling a flow from your application incurs a performance hit of ~.75 seconds whether or not the flow doesn’t do anything whatsoever.
  2. Loading data from the SharePoint list utilizing a flow takes nearly 2 seconds greater than loading it from the application.
  3. Power Apps direct data loading
    • How long it requires an application to load data from SharePoint increases linearly with the amount of products.
    • The amount and kinds of fields inside a SharePoint list change up the load time when loading from SharePoint.
  4. Power Apps data loading via flow
    1. The amount of fields and products inside a SharePoint list doesn’t have the symptoms of an immediate effect on the general load occasions.


In line with the experiment, the application maker must think about the type, sensitivity, and quantity of data that should be loaded. When the data resides in CDS, SharePoint, and SQL Server, and there isn’t any problem for the consumer being able to access the origin, then using immediate access in the application may be the preferred way of performance reasons.

However, when the databases must be guaranteed or the quantity of information is bigger than 2000 records and filtering can’t be delegated, that’s when utilizing Power Automate to retrieve the information is what you want. Just one application may leverage both approaches with respect to the requirements of the operation.

Want more insights into Power Apps? Make sure to sign up for our blog!