cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User III
Dual Super User III

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/ 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

6 REPLIES 6
Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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

Dual Super User III
Dual Super User III

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/ 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Advocate I
Advocate I

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.

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 

Dual Super User III
Dual Super User III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (19,919)