PowerApps Slow to Load

(1) Share

Report

Posted on by manjotsingh057

164

I tried to build a Power App for SharePoint List as well as SQL Server.

What i observed is the response is very slow. It's not smooth when loading data in data table.

By default it loads 500 items but in that also it takes time. Even clicking on button takes time to reflect and this happens when connected to data source. When you are not loading any data it works better. If you see the sample apps provided by microsoft, it works so smooth but in realty when connected to data sources like SharePoint or SQL it response time increases drastically and it adds to the users frustration. From my point of view, it's not user friendly at all.

I check on desktop PowerApp and Mobile layout as well.

Anybody experience the same thing ?? How can this be improved ? Is there any best way to improve on this ?

Categories:

Building Power Apps

All responses (12)

Answers (0)

Sort by

Meneghino 6,949 on at

Like
a
(1)

Report
Copy link

Link copied!

Here are some thoughts:
https://baizini-it.com/blog/index.php/2017/09/13/powerapps-improving-app-performance/
v-xida-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @manjotsingh057,

I have made a test on my side, and don't have the issue that you mentioned.

There are many reasons that a app may be slow to load. The available reasons as below:

1. The app has a large number of controls/objects that directly reference on-line data sources. 2. Shaping expressions (i.e. Filter or Search) that contain clauses that require frequent server calls. 3. Shaping expressions that are not delegated. 4. Use of inherently slow data sources. 5. Network is not in good condition. 6. The data source has large number of records.

Please check if your app meets one or more reasons mentioned above.

In order to improve the app performance, please take a try to check the suggestions mentioned within the following blog (as @Meneghino mentioned):

https://baizini-it.com/blog/index.php/2017/09/13/powerapps-improving-app-performance/

Best regards,

Kris
manjotsingh057 164 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft
Here are the answers to your queries!
1. It's just an app containing data table connected to SQL table. Approx. 20 field.
2. Yes it contains Search and Sort function but i am intially trying with 540 records only. When i show it in data table. It does not load after 200 records . It just show "Loading data" at the bottom but does not load untill and unless i click on refresh button. Data source here is SQL.
3. I am just using Search and Sort.
4. Data source here is SQL table.
5. Network is good.
6. Initially i am testing it with 540 records.

Thanks
Manjot
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @manjotsingh057 have you reviewed the blog presented by @Meneghino? Please let us know if that is a helpful resource.

@Anonymous
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

@manjotsingh057
do you know if your shaping expression is delegated?
manjotsingh057 164 on at

Like
a
(0)

Report
Copy link

Link copied!

@Meneghino@Anonymous

Here is the case.
"In" operator not working when you are directly using SQL datasource and have more than 500 items.
So i used Collect function to load SQL data to collection and it's working fine.

Can you please confirm if "In" operator is not delagable ??
Meneghino 6,949 on at

Like
a
(1)

Report
Copy link

Link copied!

As far as I know the 'in' operator is not yet delegable for SQL.
It will be much faster to create a view to deal with the 'in' operator on the server, rather than downloading all the data and then doing the shaping in the device memory.
You can even parametrise it using a stored procedure, like here:
https://baizini-it.com/blog/index.php/2018/05/10/powerapps-concurrently-returning-variables-and-multiple-arrays-from-azure-sql-database/
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

deleted
manjotsingh057 164 on at

Like
a
(0)

Report
Copy link

Link copied!

@Meneghino
Ok.. But as per the documentation, It says it's delegable as in below screenshot from
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list
Please confirm if this is in some different context or actually there is some error in documentation ??
Meneghino 6,949 on at

Like
a
(1)

Report
Copy link

Link copied!

As far as I know it is an error in the documentation. There are comments on this at the bottom of the page you took the screensoht from and I reported this at least a year ago.
In any case, now that we have the possibility of using views, delegation is not quite so much of an issue as it was back then.