Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Fix In and RemoveIf Delegation

Hello everybody,


I am working with powerapps and sharepoint list wich contains more than 5000 rows. I created the app i wanted with IN and RemoveIf function. Everything is working with less than 2000 rows in my sharepoint list.


BUT it not works with more than 2000 rows because the functions are Not Delegable.


Please, is there any solution to fix this problem ?


I would like to do this two things (separately) :


- I must to update several items in one shot

- I must to only display the items of my sharepoint list wich have a SerialNumber present in a gallery wich contains filtered items of another sharepoint list. (The two list have a common collumn : SerialNumber).


THANKS for your help,

and Have a good day!!

Super User
Super User

If you are using IN to check if a column contains any one of a number of values - e.g. Filter(MyTable, MyColumn IN (Value1, Value2, Value3)) then you can use OR instead e.g. Filter(MyTable, MyColumn = Value1 OR MyColumn - Value2 OR MyColumn = Value3). If the number of values in dynamic you have to get a bit creative with your formulas, but it can be done.

If you are using IN similar to SEARCH, then you are out of luck with SharePoint, the best you can do (for a delegable formula) is to use STARTSWITH instead.

SharePoint is very limited as a datasource which is why it is so frustrating that, if you are trying to avoid premium licensing, it is really your only option (excepting Dataverse for Teams about which I have little knowledge as it does not suit my use-cases).

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,220)