Thanks for the support @v-xida-msft
I will start from the beginning:
Supporting the Service Desk division, the guys generate an Excel document every month in which they register Support Tickets that they have successfully solved. They want to have a live search engine, which looks in the description of the title of those tickets.
They update new tickets in the SharePoint list, that's the data source. As we know, Search () is not delegable, so long ago the user @mr-dang @ had proposed an interesting code
UpdateContext ({firstrecord: First (datasource)});
UpdateContext ({lastrecord: First (Sort (datasource, RecordId, Descending))});
UpdateContext ({maxiter: RoundUp ((lastrecord.RecordId-firstrecord.RecordId) / 500,0)});
ClearCollect (iter,
AddColumns (AddColumns (Filter (HundredChart, Number <= maxiter), "min", (Number-1) * 500), "max", Number * 500)
);
Clear (datasource_temp);
ForAll (iter,
Recopilar (datasource_temp,
Filtro (fuente de datos, RecordId> = firstrecord.RecordId + min && RecordId <firstrecord.RecordId + max)
)
)
LINK: https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/500-item-limit-in-CDM-entity-search-filter-need-to-switch-to-asp/td-p/18134/page/4
Today, there are several similar proposals like the ones you mentioned in the links, Based on creating several Collection () to collect the data from the list in parts and finally join them:
Concurrent (
ClearCollect (col1, Filter (sharepointList, recordID> = 1 && recordID <= 2000)),
ClearCollect (col2, Filter (sharepointList, recordID> = 2001 && recordID <= 4000)),
ClearCollect (col3, Filter (sharepointList, recordID> = 4001 && recordID <= 6000))
);
ClearCollect (colCombined, col1, col2, col3)
I create a button that contains
ClearCollect(Col1;Filter(Lista_Excel_Pfizer;ID>=1995&&ID<=2005))
This button is for simple tests of storing the ID rows (my column) from 1995 to 2005 in a collection called "Col1".
Then in the "DataTable1" table only display this collection.
As we can see, Filter () never allows me to obtain records above ID 2,000, no matter if I only request 10 items.
What I want to do is collect approximately 5,000 records from the SharePoint List (which grows 500 items every month). And then apply a Search () in a column of text. It is important to mention that StarsWith () does allow me to delegate without problems, but the objective is to collect the items that are labeled "TextSearchBox" and that look anywhere in the text.
