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

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 138 members 3,729 guests
Recent signins:
Please welcome our newest community members: