Document Library filter very very slow

(0) Share

Report

Posted on by td1979

157

Hi,

I am building an app that should return a PDFs thumbnail based on a user selection in a combobox

The app has two data sources (for the moment), plus one combobox and one gallery

Data source 1. an excel file hosted on sharepoint connected via Excel Online (buisness). I have no choice but to use the excel file (SP list is not an option), the excel file has a column of unique names that populate the combobox

Data Source 2. a sharepoint document library with 650 pdfs (will grow)

Combobox

Filter(
 myExcelFileSource;Name_Column
 )

Gallery Item

With (
 {_item: PDF_Documents};
 Filter(
 _item;
 
 hiddenIsFolder = "no" && NameDropdown.SelectedText.Name in Name 
 )
 )

Gallery Image

ThisItem.Miniature.Large

There is no delegation warning in the developer screen and the code above works, but it is really really slow - it can take a couple of minutes to retrieve the thumbnail.

Looking in the monitor I see the gallery item filter is requesting 2000 lines and returning 650 line (the number of PDFs)

Does this mean that each time a look up is called the app downloading all 650 thumbnails !?

Can anyone help

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

td1979 157 on at

Like (0)

Report
Copy link

Link copied!
I have noticed that if I change my gallery items filter to the simple statement below the call of a thumbnail is instantanious...
Filter(PDF_Documents;Name = NameDropdown.SelectedText.Name)

however there is a delgation warning 😕 - so I guess my question evolves into how I modify the above filter to not have a delgation warning

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @td1979，

The following formula is delegable:

Filter(PDF_Documents;Name = NameDropdown.SelectedText.Name)

This formula is delegable as well:

Filter( PDF_Documents; hiddenIsFolder = "no" && Name=NameDropdown.SelectedText.Name )

Here is my testing result, could you please show me your delegation warning and mark which part it exists?

Was this reply helpful? Yes No