Loading time takes 2mins

[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?

[eka24]

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]

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]

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]

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.

[WarrenBelz · Accepted solution]

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]

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]

@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]

@keihimekawa ,

Did you look at the suggestion in my last post? Is there any reason this will not work for you?

[WarrenBelz]

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.