Answered

Power Apps Gallery View will not scroll past first 100 rows

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have an employee directory which is a SharePoint list connected to a Power Apps gallery view. The list is filtered to return only employees of a certain job title. There are 654 total employees and of these, 139 employees that should be displayed, but only the first 100 are showing. It does not load more when you scroll down to the end of the 100 rows. Please let me know what I should do to allow all 139 employees to display. I will add that everywhere I look online, it says that the gallery should load more when you scroll to bottom, but this is not working for me. Please advise, thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PHN_Developer ,

Please post your Gallery Items (in Text)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sort(Filter('PHN Employee Directory',!IsBlank(Specialty)),'Last Name',SortOrder.Ascending)

Explanation: Only Providers have a specialty listed so this formula displays Providers only, which there are a total 139 of.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @PHN_Developer ,

The issue you have is that the Not() operator is not Delegable. so !IsBlank(Specialty) will cause only the first 500 records to be considered in the filter. It may be a coincidence that 100 out of the first 500 fit this criteria. You may have to increase your Data Row Limit or modify your data schema so that maybe None is the Default for Specialty instead of Blank() (this is something I do on most criteria so I do not need to is IsBlank() in filters).

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for explaining this. I swear, this will be my first and last post regarding delegation! Since I didn't want 515 employees to have N/A or None listed as their specialty, I created a hidden [Provider : Yes or No] column which did the trick: Sort(Filter('PHN Employee Directory',Provider.Value="Yes"),'Last Name',SortOrder.Ascending)

Was this reply helpful? Yes No