How to fetch 200 records out of 1500 for Power App Gallery.

[amsrivas]

Hi Folks!!

Scenario -   Excel Table having 1500 + Rows    

                 - I need only 200 rows in Power App     

Requirement : To fetch 200 rows from excel based on filter

Issue - 

I understood, in gallery, i am not able to fetch record more than 500.

I am in need of only 200 records from excel which having 1500 + rows

Is there any way to read such 200 rows.

Thanks

Amit Srivastava

http://fascinatingsql.blogspot.com/

https://youtu.be/Hoa7rkyUlzs

[Pstork1]

Unfortunately, since Excel doesn't support delegation the only way to do that is to increase the data row limit in Power Apps settings to at least 1,500.  You can then apply a filter to the data source to get just the 200 rows you want.

[amsrivas]

Hi @Pstork1 ,

Could you please let me know how to increase the limit to 1500.

Thanks

Amit Srivastava

http://fascinatingsql.blogspot.com/

https://youtu.be/Hoa7rkyUlzs

[Pstork1 · Accepted solution]

Take a look at point #1 in the following blog.  It will show you how to update the limit.

https://michalguzowski.pl/how-to-overcome-500-items-limit-in-powerapps/ 

[Gianluca]

Hi Amit.

I guess, your Excel file is *not* static, right?
Second option, if you don't want to increase the limits or think one day you will have more than 2'000 rows in Excel, is to create a Flow that stores your Excel data into SharePoint, e.g. every night. Once the data is in SharePoint you can use delegable funtions in PowerApps.
Cheers,

G.

[amsrivas]

Hi @Gianluca 

My excel source is not static in nature, data will be change every month, plus i need to update this file from Power App as well.

Also, i didn't want to change to the SharepPoint List.

Any way, whether in Gallery, DataTable etc which can read data more than 500 from the excel source.

Thanks

Amit 

[Pstork1]

If you change the data row limit in Power Apps you should be able to read more than 500 rows from the Excel file.  The limit can be raised to up to 2,000.  There is no other way.