Removing Delegation Warning

[SoSoDef276]

Hello, 

Not sure how to resolve this with Clear Collect.

The data source for my gallery is a SharePoint document library but I also have it pointed at a search box . At the moment the data source will stay under 500. 

Can anyone help?

[Drrickryp · Accepted solution]

@SoSoDef276 

It is a warning not an error. You can increase the item limit to 2000 in advanced settings and as long as your list stays well below that, you can ignore it.

[Adrian_Celis]

Your search results will be correct if the records are under 500. But if you really want to remove the delegation warning, put your data source in a collection first:

ClearCollect(collKnowledgeBase, 'Knowledge Base')

Then in your gallery Items:

Search(collKnowledgeBase, TextBox.Text, {column name})

[Drrickryp]

@SoSoDef276 

Look at my answer and example here on how to use delegatable functions Filter + StartsWith() instead of search. This will work on thousands of records.

ClearCollect() is not delegatable and will only work on the first 2k records if you increase the item limit in the advanced settings to the maximum allowed.

[SoSoDef276]

Thank you both for the information. I will pivot based on how much records we decide to use.