Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

powerapps sharepoint search with huge data


Hi Team,


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


Hi @Vinith 


Please use the filter command to query data from sharepoint:
Expression: Filter(CT_Data,'CT ID' = TextInput1.Text && 'CT Name'=TextInput2.Text)
Here, I have used TextBox control, but if you are using any other Control, please replace TextInput1.Text and TextInput2.Text with corresponding values.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Super User
Super User

Hi @Vinith 

For a SharePoint list of that size, you must use a delegateable function like StartsWith() to search it. See 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

Helpful resources

Top Solution Authors
Top Kudoed Authors
Users online (4,155)