Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Improvee a Filter LARGE Sharepoint List by Created Day (without time)

(0) ShareShare
ReportReport
Posted on by 102

Hi,

I'm looking for help to filter a Sharepoint List with over 10,000 rows and growing daily with hundreds more, by the Created 'Day', or whatever it applies, to speed up the loading time and prevent Delegation Warnings.


Explanation of the scenery:

The Evaluations_Details List has over 10,000 rows which consist of the Answers of Evaluation_Points made on several Evaluations.

 

My Lists are:

Sharepoint List - Evaluations (have nearly 1,000 records to date, and approx 100 new per Week)

ID|Location ID|Supervisor (single line string)|Created By (default column)|Created (default column)

Sharepoint List - Evaluation_Points (have 24 records to date, and nearly no changes)

ID|Active (true/false)|Evaluation_Objetive

Sharepoint List - Evaluations_Details (over 10,000 records and over 100 new records per workday)

ID|ID_Evaluation|Response (single line string)|ID_Evaluation_Points|Created By (default column)|Created (default column)

 

Currently, before knowing it would escalate this much, I just used to filter all the responses to location X, but now that there are over 80 different Evaluations in each location, almost 100 different locations, AND every Location considering the 24 mandatories Evaluations_Points that stores in Evaluation_Details a row per each, the app is starting to lag/freeze/taking up to 15 seconds to load any screen.

 

 

Considering:

  1. On App.OnStart is filtered the Locations associate with a specific Supervisor
  2. On the First View, a DataGallery shows all the Evaluations created by that person and the user chooses which one to fill / register/read responses
  3. On the Second View, it is possible to VIEW in another DateGallery all the details about the unique inspection selected
  4. On the Second View, also, it is possible to view in a FormViewer has all the information related to each response with a Filter from the first DataViewer.
  5. On the Second View, at OnVissible is where I am currently filtering with this formula/Collection:
    ClearCollect(ColeccionDeResponses,Filter(Evaluations_Details,ID_Evaluation = Text(Gallery_Browser_Evaluations.Selected.ID)));
    ClearCollect(
    ActiveEvaluationsPoints,
    Filter(
    Evaluation_Points,
    Activa = 1
    )
    )

 

Also attached the app to this; the app variables are mostly in Spanish due to the language of my inner customers but translate for the purpose of this threat.

 

Thanks for any improvement possible to this.

  • RandyHayes Profile Picture
    RandyHayes 76,287 on at
    Re: Improvee a Filter LARGE Sharepoint List by Created Day (without time)

    @OSBSoto 
    I reviewed your App. 

    To critique a bit...

     

    1) One of the things I noticed is that you are recollecting data on every screen OnVisible.  This is primarily your source of slowness.   There is no need to do this and this is one thing that Collections in apps will cause...constant reloading of the collection.   And...you ARE constantly recollecting the same information that you already have in your app!

    A collection is a static snapshot of a table.  In your case you are taking static snapshots of your data table...which is already a table.  As long as you can delegate your filter criteria to the datasource, you need not use them at all - especially in this app.

    2) You have a fairly decent amount of redundant controls in your app.  As well as more variables than an app this size should need.  

    3) You are not utilizing some of the built-in capabilities of the Editforms for validation and are writing more formulas than necessary.

    4) You are reusing groups of controls on each page that should be consider to be moved to a component instead.

     

    The only real delegation issue I see would come from your searching in the Gallery_Browser_Vistas.  BUT, that is already pre-filtered from the collection level with delegable criteria.  SO...the collection can be removed (as with all of them) and move the prefiltered data lookup directly in the gallery.

     

    In conclusion...yes, you have some serious amount of load, load, load of data.  It is not necessary and if you remove all of that, I believe your performance would be tremendously different.

     

    Sorry to beat up so much, but I believe you were looking for a honest critique of the app, as you provided it.

     

    I hope this is helpful for you.

     

     

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Improvee a Filter LARGE Sharepoint List by Created Day (without time)

    @OSBSoto 

    Take a look at @WarrenBelz 's blog post here for the most up to date way to deal with delegation in SharePoint. https://www.practicalpowerapps.com/delegation/power-apps-delegation-sharepoint/ .  

  • OSBSoto Profile Picture
    OSBSoto 102 on at
    Re: Improvee a Filter LARGE Sharepoint List by Created Day (without time)

    Hi, can't change the data source; Sadly I am to say that "I'm lucky to have at least several licenses of Office 365 Basic" (it's a small family business in the Caribbean Sea)

  • Drrickryp Profile Picture
    Drrickryp on at
    Re: Improvee a Filter LARGE Sharepoint List by Created Day (without time)

    @OSBSoto 

    While there are work-arounds, I suggest that you change to SQL or Dataverse if possible to take advantage of the flexibility in those systems with regards to delegatable functions in PowerApps for large datasources.  The delays will likely become unbearable as your data grows. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard