web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to load large data...

Power Apps

Answered

How to load large data in a gallery the right way?

(0) Share

Report

Report

Posted on by RobHajj98

496

Hello everyone,

I hope all is well,

My problem is:

I'm trying to load 10 SQL tables inside 10 collections so I can use them locally.

Unfortunately, whenever I create these collections at the app start property, the application is not performing well at all.

My request:

I need the right practice for storing and loading these tables in a gallery as well as the items in the dropdown that reside within this gallery.

Therefore, I would appreciate any advice you can give me about how I can improve this app's performance.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Roberto_el_Hajj

The best way to work with large data from SQL is to use delegatable functions. (FYI, Collect(), ClearCollect() are not delegatable and the more that you require PowerApps to do locally, the worse will be your performance). Using delegatable functions and operators allow calculations and formulas to be carried out at the server level. Luckily, most PowerApps functions are delegatable. In addition, SQL views allow for data manipulation prior to using the result in PowerApps. IMHO, collections should be avoided if possible in favor of using delegatable functions and the original dataset.

For practice, set your row limit to 1 when designing your app. If you can work around that, then your app will be able to handle the every dataset, no matter how large it gets.

Was this reply helpful? Yes No
Verified answer

RobHajj98 496 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Drrickryp , thanks for your response.

What i did as a work around is the following:

Concurrent( ClearCollect(coltblJobWorkFlow1,Filter(tblJobWorkFlow,jwId<2000)), ClearCollect(coltblJobWorkFlow2,Filter(tblJobWorkFlow,jwId >=2000 And jwId<4000)), ClearCollect(coltblJobWorkFlow3,Filter(tblJobWorkFlow,jwId >=4000 And jwId<6000)), ClearCollect(coltblJobWorkFlow4,Filter(tblJobWorkFlow,jwId >=6000 And jwId<8000)), ClearCollect(coltblJobWorkFlow5,Filter(tblJobWorkFlow,jwId >=8000 And jwId<10000)), ClearCollect(coltblJobWorkFlow6,Filter(tblJobWorkFlow,jwId >=10000 And jwId<12000)) ); ClearCollect(coltblJobWorkFlow, coltblJobWorkFlow1,coltblJobWorkFlow2,coltblJobWorkFlow3,coltblJobWorkFlow4,coltblJobWorkFlow5,coltblJobWorkFlow6);

Was this reply helpful? Yes No

Join the conversation