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?
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.
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!
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.
@thananji, glad you noticed. The blog post announcing support for more than 256 items just went live:
Please keep the feedback coming and let us know what you want to see next.
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?
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.
Check out new user group experience and if you are a leader please create your group
Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.