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

Not all records from a connected Sharepoint list are showing up in my PowerApp

I have connected a 1500 record Sharepoint list to a PowerApp Gallery and some of the records from the list are missing when I view it in the PowerApp.  I have taken the same Sharepoint list and exported it to Excel and connected to it and get the same results.

 

Any idea as to why all the records within this list or spreadsheet would not be visible in the app?

 

Thanks,

Todd

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Hi @thanke

 

PowerApps has a limit of 500 records when taking data from any source. This is to increase performance. 

 

If you want to access records that are over 500 limit you have to use Sorting and Filtering to narrow down the set of records to be withing 500. However, this only applies to datasources that support delegation.

 

Delegation Info

Delegatable Data Sources 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @thanke

 

PowerApps has a limit of 500 records when taking data from any source. This is to increase performance. 

 

If you want to access records that are over 500 limit you have to use Sorting and Filtering to narrow down the set of records to be withing 500. However, this only applies to datasources that support delegation.

 

Delegation Info

Delegatable Data Sources 

View solution in original post

v-monli-msft
Community Support
Community Support

Hi @thanke,

 

Here is an another documention about Large SharePoint lists, Delegation details, Flexible height gallery, Validation with regular expressions, and more:

https://powerapps.microsoft.com/en-us/blog/powerapps-update-large-sharepoint-lists-startswith-delega...

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,341)