Sudden Drastic Performance Issues with Existing Power App

(0) Share

Report

Posted on by Thor_PPC

359

Hello,

I have an important Power App that has suddenly developed performance issues to the point where it is basically unusable. I'm wondering if anyone can help me figure out what the issue could be and how I could potentially resolve this.

The purpose of the Power App is to act as a search for the project’s sharepoint document library so that users can easily search through the document library, find a specific pdf, and then view it. It needed to be a Power App because a lot of the users don’t understand how to use SharePoint at all, so I had to develop a Power App with screens and functionality that are as simple as possible for the user. The Search Screen allows for various filtering of a data table that is hooked up to the document library. When they find the entry that they want to view, clicking the name will navigate to the PDFViewScreen which displays the pdf selected from the data table. This had previously been running just fine, but is now taking multiple minutes for the data table to update or display information. There are currently 20 pdfs saved in the document library. When I had previously tested this with more than 20 pdfs in the library, everything was running smoothly. The pdfs range in size, but some of them are very long (in the hundreds of pages).

The data table has the Items property of the code pasted below, in order to have the data table either show every entry in the document library or just the filtered version. This code was given to me by someone else on this forum, I believe WarrenBelz.

With(
   {
      _Data:
      Filter(
         'Library1',
         
         (
            Len(DepartmentComboBox.Selected.Value) = 0 || 
            Department.Value = DepartmentComboBox.Selected.Value
         ) &&
         (
            Len(SchoolComboBox.Selected.Value) = 0 || 
            School.Value = SchoolComboBox.Selected.Value
         ) &&
         (
            Len(CampusComboBox.Selected.Value) = 0 || 
            Campus.Value = CampusComboBox.Selected.Value
         )
      )
   },
   Filter(
      _Data,
      (
         Len(MechanismInput.Text) = 0 || 
         MechanismInput.Text in 'Mechanism'
      ) &&
      (
         Len(KeywordsInput.Text) = 0 || 
         KeywordsInput.Text in 'Keywords' 
      ) &&
       (
         Len(AgencyTextbox.Text) = 0 || 
         AgencyTextbox.Text in 'Agency' 
      )
   )
)

Categories:

General Questions

Using Apps Using Formulas

Connecting to Data

All responses (4)

Answers (0)

Thor_PPC 359 on at

Like (0)

Report

Sudden Drastic Performance Issues with Existing Power App

Thank you for your help, WarrenBelz. I did try this new code; however, it doesn't seem to have improved the performance. It's so bizarre because it is only 20 documents and there's nothing else on the site. I keep trying ideas, but nothing seems to be improving the performance and the app checker doesn't highlight anything in particular.
WarrenBelz 146,524 Most Valuable Professional on at

Like (0)

Report
Sudden Drastic Performance Issues with Existing Power App

Hi Thor_PPC

Yes - that certainly looks like my code. I structured it like that to give you some Delegation capacity. The top filter is Delegable and providing it returns record numbers less than your Data Row Limit, the non-Delegable bottom filter will then execute "locally" on the output table from the top filter.

If you are never going to have more files than your (500-2000) Data Row Limit, then do this.

With( {_Data: 'Library1'}, Filter( _Data, ( Len(DepartmentComboBox.Selected.Value) = 0 || Department.Value = DepartmentComboBox.Selected.Value ) && ( Len(SchoolComboBox.Selected.Value) = 0 || School.Value = SchoolComboBox.Selected.Value ) && ( Len(CampusComboBox.Selected.Value) = 0 || Campus.Value = CampusComboBox.Selected.Value ) && ( Len(MechanismInput.Text) = 0 || MechanismInput.Text in 'Mechanism' ) && ( Len(KeywordsInput.Text) = 0 || KeywordsInput.Text in 'Keywords' ) && ( Len(AgencyTextbox.Text) = 0 || AgencyTextbox.Text in 'Agency' ) ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee
Thor_PPC 359 on at

Like (0)

Report

Sudden Drastic Performance Issues with Existing Power App

Only 20. The PDFs are the only documents store on the site at all.
lbendlin 7,794 Super User 2025 Season 1 on at

Like (0)

Report

Sudden Drastic Performance Issues with Existing Power App

How many documents are now in the SharePoint Document Library overall? (not just your PDFs)