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

powerapps search with huge data against sharepoint

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.

 

any help provided will be highly appreciated

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: powerapps search with huge data against sharepoint

Hi @Vinith46 ,

Could you please share a bit more about the Search formula you used in your Gallery?

Do you want to search your SP List records (25000 records) based on the ID (Number) and Name column (Text)?

 

Based on the needs that you mentioned, I have made a test on my side, regardless of which Filter function or Search function you used in your app, you would faced a Delegation warning issue with your formula.

If you have faced a Delegation warning issue with your formula, it means that PowerApps could not delegate the data process to your SP List data source, you could only process data locally. In default, you could only process 500 records at most. You could change the limit to maximum value -- 2000.

More details about the Dlegeation in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

 

As an alternative solution, you could bulk-save your SP List records into multiple separated collections in your app. Then save the multiple collections into a Single one Collection (MergedCollection). Then use the MergedCollection as data source within your app instead of your Original SP List data source.

Please check and see if the alternative solution mentioned wihtin the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/Pulling-in-large-ish-SQL-tables/m-p/243777#M7...

On your side, please take a try with the following workaround:

Concurrent(
            ClearCollect(Col1, Filter('YourSPList', ID >= 1 & ID <= 2000)),
            ClearCollect(Col2, Filter('YourSPList', ID >= 2001 & ID <= 4000)),
ClearCollect(Col3, Filter('YourSPList', ID >= 4001 & ID <= 6000)),
ClearCollect(Col4, Filter('YourSPList', ID >= 6001 & ID <= 8000)),
ClearCollect(Col5, Filter('YourSPList', ID >= 8001 & ID <= 10000)),
ClearCollect(Col6, Filter('YourSPList', ID >= 10001 & ID <= 12000)),
ClearCollect(Col7, Filter('YourSPList', ID >= 12001 & ID <= 14000)),
...
...
ClearCollect(Col11, Filter('YourSPList', ID >= 20001 & ID <= 22000)),
ClearCollect(Col12, Filter('YourSPList', ID >= 22001 & ID <= 24000)),
ClearCollect(Col13, Filter('YourSPList', ID >= 24001 & ID <= 26000)) );
ClearCollect(MergedCollection, Col1, Col2, Col3, Col4, ..., Col11, Col12, Col13)

Then set the Items property of the Gallery to following:

Filter(MergedCollection, TextSearchBox1.Text in ID || TextSearchBox1.Text in Name)

4.JPG

Note: Please make sure you have changed the "Data row limit for non-delegable queries" option within Advanced settings to 2000 (maximum value). The TextSearchBox1 represents the Text Input box (where you type the search text) in your app.

 

Please take a try with above solution, then re-load your app, check if the issue is solved.

 

More details about changing the Delegation limit, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#changing-the-limit

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: powerapps search with huge data against sharepoint

Hi @Vinith46 ,

Could you please share a bit more about the Search formula you used in your Gallery?

Do you want to search your SP List records (25000 records) based on the ID (Number) and Name column (Text)?

 

Based on the needs that you mentioned, I have made a test on my side, regardless of which Filter function or Search function you used in your app, you would faced a Delegation warning issue with your formula.

If you have faced a Delegation warning issue with your formula, it means that PowerApps could not delegate the data process to your SP List data source, you could only process data locally. In default, you could only process 500 records at most. You could change the limit to maximum value -- 2000.

More details about the Dlegeation in PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

 

As an alternative solution, you could bulk-save your SP List records into multiple separated collections in your app. Then save the multiple collections into a Single one Collection (MergedCollection). Then use the MergedCollection as data source within your app instead of your Original SP List data source.

Please check and see if the alternative solution mentioned wihtin the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/Pulling-in-large-ish-SQL-tables/m-p/243777#M7...

On your side, please take a try with the following workaround:

Concurrent(
            ClearCollect(Col1, Filter('YourSPList', ID >= 1 & ID <= 2000)),
            ClearCollect(Col2, Filter('YourSPList', ID >= 2001 & ID <= 4000)),
ClearCollect(Col3, Filter('YourSPList', ID >= 4001 & ID <= 6000)),
ClearCollect(Col4, Filter('YourSPList', ID >= 6001 & ID <= 8000)),
ClearCollect(Col5, Filter('YourSPList', ID >= 8001 & ID <= 10000)),
ClearCollect(Col6, Filter('YourSPList', ID >= 10001 & ID <= 12000)),
ClearCollect(Col7, Filter('YourSPList', ID >= 12001 & ID <= 14000)),
...
...
ClearCollect(Col11, Filter('YourSPList', ID >= 20001 & ID <= 22000)),
ClearCollect(Col12, Filter('YourSPList', ID >= 22001 & ID <= 24000)),
ClearCollect(Col13, Filter('YourSPList', ID >= 24001 & ID <= 26000)) );
ClearCollect(MergedCollection, Col1, Col2, Col3, Col4, ..., Col11, Col12, Col13)

Then set the Items property of the Gallery to following:

Filter(MergedCollection, TextSearchBox1.Text in ID || TextSearchBox1.Text in Name)

4.JPG

Note: Please make sure you have changed the "Data row limit for non-delegable queries" option within Advanced settings to 2000 (maximum value). The TextSearchBox1 represents the Text Input box (where you type the search text) in your app.

 

Please take a try with above solution, then re-load your app, check if the issue is solved.

 

More details about changing the Delegation limit, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#changing-the-limit

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Administrator
Administrator

Re: powerapps search with huge data against sharepoint

Hi @Vinith46 how are you progressing with this? Was the above reply from our Community Support Team helpful?

 

Thank you,

 

@TopShelf-MSFT 

Helpful resources

Announcements
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: 57 members 4,906 guests
Recent signins:
Please welcome our newest community members: