Power Platform Community Forum Thread Details

So, we are in the process of migrating all of our existing SharePoint on-premise lists that use Infopath and Workflow to SharePoint On-line using Power Apps and Power Automate.

We began with the idea we would use a true Canvas Power App with SharePoint as the data source (using vertical galleries on the first screen for selection, etc.), but quickly realized many of our lists had over 2000 rows (even after logical cleanup), and we couldn't do a search with the "in" function. We know you can use "Starts with", but that just doesn't cut it.

So, we've decided that we will continue to use SharePoint lists / views as the front end with a customized form for presentation.

We don't have licensing for SQL Server (Premium).

Have others had to go this route to due to this limitation?

Thanks!

Categories:

Building Power Apps

@pullesb - there are no real workarounds for functions which are not delegable. However, the Filter function is delegable with SharePoint.

If you can pre-filter your lists on a specific criteria that will return less than 2,000 rows, you can then perform a Search or StartsWith function on that smaller subset of data. For example we could have population data that has 5,000 rows of people per district, but if we know that each neighbourhood within those districts will return less than 2,000 rows, it is ok to use a non-delegable function within that smaller subset using delegable Filters.

Refer to the article from @WarrenBelz for more on this here:

https://www.practicalpowerapps.com/delegation/with-statement-managing-delegation/

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.