Answered

Loading time takes 2mins

(0) Share

Report

Posted on by keihimekawa

Hi everyone. I have this app which loads 100k data initially. App works fine, no delegation issues but it takes 2mins to load initially but afterwards, it loads super fast. Is there a way to shorten the 2mins initial load time?

Categories:

Building Power Apps

All responses (10)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If the 100k does not change regularly, can you consider an import of the table instead of always loading at OnStart.
If it should be live connection, can you consider a Power Automate
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
the365bit 136 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you need all the 100k data initially?

I don't know you scenario but consider how dynamics does retrieve of multiple records, it uses pagination to avoid making the user wait until all the records are loaded. If you could load the data in batches it would improve the user experience, another option would be to use Azure cache to store the data that would also improve but it's hard to go further without more details.
keihimekawa 99 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for the response @eka24. There's an existing 3-level approval process. I'm currently using SP List to house all 100k+ data
keihimekawa 99 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @the365bit. not all 100k are initially needed. The data to be displayed will be based on an approval list (to check what data should be displayed for a particular user). Like, approver1 should see item1, 9, 100, etc. approver 2 should see item item9000, item26000, etc. from my testing, the most number of rows a user can see is 600.
Verified answer

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @keihimekawa ,
If you can identify the records (600) needed on a Text or Numeric field, you could collect them for the user logged in (a reference for the user would also have to relate to a Text field in the list. First set a Variable at App OnStart
Set( vUserName, User().FullName )
Then assuming you have this name in the list (or can reference it with a text lookup) - could also be at App OnStart
ClearCollect( colUserRecords, //call it whatever you want Filter( YourListName, YourUserField=vUserName //you could also have a lookup in here ) )
this is just a concept to answer your question.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @keihimekawa
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
keihimekawa 99 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz- apologies for the late response. Been too busy with multiple projects 🙂
We do have a separate list which holds all approvers (as of now, this list holds around 700 records and I'm sure it will go up once the business agrees to incorporate other approvers). Approvers are filtered based on 2 items. Let's call then "Department" and "CostCenter". An approver can work on different cost centers but same department and vice versa (business procedure). Each approvers can see around 5k items.
There's also this part wherein once the approver clicks on "submit" and decision is "reject", it will create a new line item which will then be used for other selections (this is just one part of the "complex" business procedure).
The app's flow is quite complex as there are a lot of business procedures to consider. I'd deeply appreciate it if I can reach out to you via PM and perhaps I can share my codes to you?
Another thing that we noticed was that the loading time changes. There are instances wherein it loads in 2mins. Somethings 4-5mins. I don't think this is a network issue since I can load other PowerApps forms (those without complex codes) just fine.
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@keihimekawa ,
Did you look at the suggestion in my last post? Is there any reason this will not work for you?
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @keihimekawa ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
keihimekawa 99 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi! So sorry for the super late response. I got this working by doing the filter first before loading the data/selection. Got positive feedback from various users that the workaround worked.