Only 256 Entries show from Sharepoint list?

[FlashFire]

I can only get the first 256 entries to show on a powerapp from a sharepoint list with ~ 1,000 entries. 

Online is says that there were problems with delegation 3 months ago where only the first 500 results would show. Responses to that said it would get fixed in about a month, so I'm wondering if this issue is still current, but changed from 500 to 256? 

Thanks

[Anonymous]

I get the impression that this is not a high priority for Microsoft in hopes that people will migrate their data from SharePoint to CDS.

[koconnor]

Doesn't appear so. I did talk with a powerapps support rep and they informed me the fix is coming soon. How soon? No clue

[KeremY]

Hey folks,

I know a lot of you are eagerly waiting for this, but we are having some difficulty making this work, especially to properly integrate it with the search functionality that's available in PowerApps. We had hoped to roll this out this month, but found severe limitations in our current implementation that would result in more frustration for you, rather than successful scenarios. We are refactoring our connector to be able to support this the right way, rather than in a limited way, and this is a top scenario to support for the SharePoint connector. We are definitely committed to making SharePoint lists work with more than 256 items. We just need a little more time to make this work. 

Our current estimate is that this will be available in January/February 2017.

We apologize for the wait, and really appreciate your patience.

[estevaf]

do we have an updated ETA for this fix?

[KeremY]

Hi @estevaf, we hope to deploy the first part of the solution by January that will let you scroll past the top set of results, and also sort and filter by columns using the "equals" operator on the server side. More info coming in January! 

[LangFalcon]

Is there any update on this? I still seem to be limited to 500 items when working with a SharePoint List as of 1/13/17.

Thanks

[thananji]

It seems Filter formula with equal sign works fine with column. 256 row limitation is also overcomed. 

PS: If you have more than 5000 items in your list, you should indexed the column you filter.

@KeremY Thank you PowerApps SharePoint team !

Expecting other formulas also working with SharePoint List.

[KeremY]

@thananji, glad you noticed. The blog post announcing support for more than 256 items just went live:

https://powerapps.microsoft.com/en-us/blog/powerapps-now-supports-working-with-more-than-256-items-i...

Please keep the feedback coming and let us know what you want to see next.

[Anonymous]

I have roughly 800 items in my SP list.  When I attempt to get to end, whether that be scrolling or sorting the list from Z-A, I only see the first 500 items.  If I search for an name that is beyond the first 500 in the list, the search returns void.  Is there a solution or workaround for this issue.  Also, what are the current alternatives that allow us to access more than 500 items.

Lastly, are there any examples of using PowerShell to populate some other data source, like a database using the common data model?

Thank you,

W.

[LangFalcon]

If you follow the link provided by @KeremY > https://powerapps.microsoft.com/en-us/blog/powerapps-now-supports-working-with-more-than-256-items-i... you'll notice that there are some changes that need to be made to the default Items property of the Gallery before scrolling past 500 items will work.

"For lists that contain more than 500 items, there are some changes you need to make to your app (to the “Items” property of the Gallery control), and once these are done, you should be able to simply scroll to the bottom of a list, and PowerApps will bring in the next set of results from SharePoint to make things work."

The default "Items" property includes a Search function, which is not delegable. Switching this to Filter should give you your desired results.