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.
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.
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:
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:
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.
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))
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
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021