Displaying only 500 rows out of 5000 items from Sharepoint Excel Table

(0) Share

Report

Posted on by affanain

Hi All,

I've created a gallery control and applied filters to it for search. Here's the formula:

Filter(

ProjectDatabase,

(IsBlank(SelectedProjectNumber) || 'Project number' = Text(SelectedProjectNumber)) &&

(IsBlank(TextInput_Search.Text) ||

TextInput_Search.Text in Text('Project number') ||

TextInput_Search.Text in 'Base item code' ||

TextInput_Search.Text in Customer ||

TextInput_Search.Text in 'Country' ||

TextInput_Search.Text in 'Offering category description' ||

TextInput_Search.Text in 'Task names')

)

The issue is, it is not searching through all of my records, which are in my excel file, and when I display the number of entries, it only has 500 rows whereas my table has around 5000+ entries.

The formula shows a warning sign as well:

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report

HI @affanain I would request you to go through this documentation by Microsoft. It is regarding delegation in PowerApps: Understand delegation in a canvas app - Power Apps

There is one paragraph which describe this:

Please check these posts:

https://www.matthewdevaney.com/sharepoint-delegation-cheat-sheet-for-power-apps/

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-resolve-delegation-warning-message-on-PowerApps-formula/td-p/274507

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
Verified answer

developingteal 392 on at

Like (1)

Report

So you are having delegation issues - you can change delegation to be 2000 rows in your settings, however you are maxed at that. One solution for it to search all your records is to use a gallery instead, and the gallery will still filter/search all your records, even if it only loads on screen 2000

Was this reply helpful? Yes No
affanain 20 on at

Like (0)

Report

Hi,

I'm already using a gallery control and it isnt searching all the records, can you please elaborate more on that?

Was this reply helpful? Yes No