Answered

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

(0) Share

Report

Posted on by Salamander94

184

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Salamander94 184 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like
a
(1)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No