SharePoint List item Limit of 2000...What do I do?

[Salamander94]

I have crated a production app that is being used on a daily basis.  Today I ran into a problem where the search function wouldn't pull over what they were searching for.  Turns out there's a 500 item limit for queries.  I upped it to 2000, but that will only be a very limited fix.  I need a permanent one.  What can I put our data into that will not give us a limit and still be able to use it with a PowerApp?

[RandyHayes · Accepted solution]

@Salamander94 

PowerApps is limited to a maximum record count of 2000 for all datasources.

Options are:

1) Narrow first - If you can narrow your records, you can then search over that.  This means that you can perform a narrowing filter with delegable criteria first and then perform your search over that list.

    ex.  Search(Filter(yourList, delegableCriteria), yourText, yourColumns)

2) Pull all the records from your datasource - this one is painful and performance impacting, but you can initially pull all of the records of your datasource through a series of delegable criteria into a collection and then use the collection as  your datasource in your app to search over.

Personally, I rely on #1 the most.

I hope this is helpful for you.

[Salamander94]

Okay, so that is working.  I am curious though, is there something wrong with my code here:

Filter(REM_Wood_Inventory,Title=TextInputSearch_1.Text && Quantity>0 && cantboardfeetoriginal>=0)

Because, for example, if I search "tes" nothing appears.  When I search "test" I see my test entry appear.

[rebeccas]

For Search you use the = but for Filter you will use in so 

Filter(REM_Wood_Inventory,Title in TextInputSearch_1.Text && Quantity>0 && cantboardfeetoriginal>=0)