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'
)
)
)
