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

(0) Share

Report

Posted on by amsrivas

177

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

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 69,042 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
amsrivas 177 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Pstork1 69,042 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Gianluca 68 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
amsrivas 177 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pstork1 69,042 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No