Answered

Gallery limiting views

(0) Share

Report

Posted on by dvoinikat

Hello all,

I have an app developed which is connected to SharePoint list. The data source has more than 1000 records but the gallery in the App is showing only till 999 records.

The Filter function I am using is based on a service column in SP which holds only 0 and 1. So if the line has 1, should be displayed. The formula under 'Items" is the following:

Sort(Filter('SharePointList',FilterNum = 1),Title,Descending)

Where "SharePointList" is the datasource and "FilterNum" is the column from where I am taking the values

I played with the advanced settings of changing the limit to 2000 rows, but this is not helping. Can yoo please support me in that?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dvoinikat ,

Firstly your filter

Sort( Filter( 'SharePointList', FilterNum = 1 ), Title, Descending )

assuming FilterNum is a numeric field is Delegable, so it should display all matching records if that is the Items of a gallery (your Delegation settings will have no bearing). It will however display the records in batches of 100, but scrolling down will see the subsequent 100 groups displayed.

How are you testing the 999 (this figure has no relevance to any limits)
dvoinikat 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz . I want the most recent records to be on top. Meaning, I shouldn't scroll in order to get the latest number. Column "FilterNum" is a numeric column and the formula lives in "Items" section of the respective gallery. In the SharePoint list I have record which matches the condition and has ID of 1007, but it is not diplayed in the app.
The formula you are quoting is the same which I am using, but it is not giving me the result wanted
Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@dvoinikat ,

If you want the newest on top, you would do this

Sort( Filter( 'SharePointList', FilterNum = 1 ), ID, Descending )

I must repeat that there is no reason all records matching the numeric column will not display in the gallery (after scrolling to the end) as this is the most basic of Delegable 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.
dvoinikat 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz. Seems the issue was with using "Title" instead of "ID". Pretty quick fix (ashamed I didn't figure it out on my own).