cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerAppsJunkie
Helper II
Helper II

Filter a SharePoint list with more than 2000 records

Is it possible to filter on a SharePoint list with more than 2000 records?

 

What I want to do is do a filter in for a column that has text like "NameA; NameB; NameC".  So there are 3 names in this column that are seperated by a ";"  I need to filter on a name so lets use "NameB" as an example.  So that if "NameB" exists anywhere in that column it will show the list item in a gallery.

I can't use StartsWith because well Name B could exist anywhere in that column...so it could be "NameC;NameA;NameB" on one list item or it might be "NameD;NameB;NameA" in a different list item.  I need to show all SP list items that could have "NameB" anywhere in that column.

The issue I'm running into is how to search anywhere in that column for "NameB" and not run into delegation issues because the list has 3,300 items in it.

So is there any work around or can I use Flow to help fix the problem?

21 REPLIES 21

@v-xida-msft May i know how can i use the same trick to solve delegation problem , for my combo box with formulae

 

Items :

Distinct(
'Site Admins',
If(
NewComboBox.Selected.Value = "Supplier",
Supplier,
NewComboBox.Selected.Value = "City",
City,
NewComboBox.Selected.Value = "Site",
'Site Name'
)
)

@v-xida-msft I tried the forumula.. but some how neither Col1 or Col2  or MergedCollection doesnt yeild any results from my Sharepoint List.. I am missing anything .. it doesnt get any records into collection.

 

App:

On Start : 

Concurrent(
ClearCollect(col1, Filter('Site Admins', ID >= 1 && ID <= 2000)),
ClearCollect(col2, Filter('Site Admins', ID >= 2001 && ID <= 4000))
);
ClearCollect(MergedCollection, col1, col2);

 

Combo Box :

Items : 

Distinct(
MergedCollection,
If(
NewComboBox.Selected.Value = "Supplier",
Supplier,
NewComboBox.Selected.Value = "City",
City,
NewComboBox.Selected.Value = "Site",
'Site Name'
)
)

 

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,711)