Need help to resolve search option
I have to search against 25000 records from sharepoint
I have ID,Name to search with
I have tried with combobox but cant able to search with 25000 rows?
Concatenate(CT_Data.'CT ID'," - ",CT_Data.'CT Name')
Using textbox and gallery i tried with filetrs but not able to provide an search option(enter single letter show related options )
Is there any other way to resolve the search option, backend i have sharepoint.
can we try with restApI else to solve the issue
any help provided will be highly appreciated
Expression: Filter(CT_Data,'CT ID' = TextInput1.Text && 'CT Name'=TextInput2.Text)
For a SharePoint list of that size, you must use a delegateable function like StartsWith() to search it. See https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-startswith There are several posts in the documentation regarding delegation in PowerApps and the functions supported by each connector. There are limitations in SharePoint that are not present in Sql or CDS. However, if your list is for reference only and will not need to be edited, you may want to export it from SharePoint and connect it as a static Excel datasource. In that case, with 25,000 items, you will need to import your list in two Excel files and combine them in a single collection since this connector is limited to 15,000 items. For an example of how this works with a list of >40,000 items, please see my post in the community blog https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Automatically-Prefill-City-and-State-us...