cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Sharepoint List Search Function

I have read many articeles but lloking for current information on "Search" function in SharePoint List (43,000) items.

 

I currently use the Filter Function.

Filter(draft_brandmaster,StartsWith(Supplier_Name,TextInput6.Text))

This is working fine on returning records. 

 

I was wondering if the "Search" function for SharePoint Lists will work the same as a "Contains" or "IN"  and still be ok with delegation issues in SharePoint 365 , office 365.

 

Dave Powell

 

3 REPLIES 3
Highlighted
Super User
Super User

Re: Sharepoint List Search Function

Hi @DAVIDPOWELL 

Search is not delegatable in SharePoint. Neither is “in” .  I believe Filter and StartsWith are your best bet unless you move to Sql or CDS.

Highlighted
Community Support
Community Support

Re: Sharepoint List Search Function

Hi @DAVIDPOWELL ,

Do you want to avoid the effect of delegation by using "in" instead of "StartsWith" in your formula?

Firstly, I'm afraid "in" is not delegable in sharepoint list.

Search() function is not delegable in sharepoint list neither.

So if you replace startswith() with "in" or replace Filter() with Search(), you will both be affected by delegation problem.

Here's a list about the delegate functions of sharepoint list:

3101.PNG

 

Here are some alternative solutions for your reference:

1)"=" is delegate in sharepoint list.

So you could use this formula which will not meet delegation problem:

Filter(draft_brandmaster,Supplier_Name=TextInput6.Text)

 2)save your list data in collection.

You will not have delegation problem in collection.

ClearCollect(collection1,draft_brandmaster);
Filter(collection1,TextInput6.Text in Supplier_Name)

If your collection has meet its max limit, you could save your list data to several collections. Then filter them one by one.

For example:

ClearCollect(collection1,Filter(draft_brandmaster,ID<=10000));
ClearCollect(collection2,Filter(draft_brandmaster,ID<=20000,ID>10000));
ClearCollect(collection3,Filter(draft_brandmaster,ID<=30000,ID>20000));
ClearCollect(collection4,Filter(draft_brandmaster,ID<=40000,ID>30000));
ClearCollect(collection5,Filter(draft_brandmaster,ID<=50000,ID>40000));
ClearCollect(filtered data, 
Filter(collection1,TextInput6.Text in Supplier_Name),
Filter(collection2,TextInput6.Text in Supplier_Name),
Filter(collection3,TextInput6.Text in Supplier_Name),
Filter(collection4,TextInput6.Text in Supplier_Name),
Filter(collection5,TextInput6.Text in Supplier_Name))

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User
Super User

Re: Sharepoint List Search Function

Hi @DAVIDPOWELL 

There is another option if your list is being used for a look up only and not requiring editing.  You can convert it to an Excel table and bring it in as a static Excel datasource.  I have an example that I use for zip codes (also about 43,000 items). Automatically-Prefill-City-and-State-using-Zip-Codes-in-your-App 

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,763)