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?
Solved! Go to Solution.
Ok I'm not sure what is wrong here....It is still not pulling the records > 2000
I added a calculated ID field as well as one I populated with MS Flow called RealID
So I have 2 ID fields now CalcID and RealID which match the ID but when I use this statement the collection comes back completely blank. I've refreshed my data source and the fields show up but when I assign this to a button where it should collect this data past > 2000 records it does not do anything. The first line on a button to collect the first 2k items works fine.
ClearCollection(col1, Filter('SPTestList', RealID >=1 && ID <=2000))
ClearCollection(col2, Filter('SPTestList', RealID >= 2001 && ID <= 4000))
This is driving me bonkers!
I do notice on this statement it shows a delegation warning. I tested both the Value(CalcID) and ID both showed the blue underline however the RealID column did not but showed blue lines under the other parts of the statement I included it. So maybe you can't use a calculated field? I had RealID show up without the delgation warning and when I replaced both sides it pulled in all the information.
I would be nicer to use a calulated field though because then I wouldn't have to have an extra flow so if you know how I would do that or if it's possible. Also the first answer didn't mention delgation problems but I guess ID does not delegate as you said.
Hi @PowerAppsJunkie ,
Please also consider take a try with the following alternative solution, then check if the issue is fixed:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.