cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Vinith
Level: Powered On

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

2 REPLIES 2
Super User
Super User

Re: powerapps sharepoint search with huge data

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

Re: powerapps sharepoint search with huge data

Hi @Vinith 

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