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

Problems with Remove

Hi PowerAppers.


I got two lists in Sharepoint where list 1 is the "Master list" (4000 rows) and List 2 is the "request list"... both lists got three identical columns (field 1, field 2, field 3), and List 2 also got a "Status" field and a "Changetype" field.

I'm trying to create a button to which Removes all posts in List 1 which has the Status = Pending and Changetype = Remove in List 2.

But I can't seem to get it to work.

Remove If with Count worked, but only for 2000 rows.

I've also tried RemoveIf with !IsEmpty(Filter), Remove If with !IsBlank(Lookup) and For All with If, which for most cases does nothing when the code runs, but in a few "nested situations" I even got a "Throttling Problem".

Would really appreciate some clues on how to get this to work as I would like.

Super User
Super User

If it's one time thing you can sort list Descending and use your solution that worked.

so first it will work on first 2000 record. and then last 2000 record,

Hmm, that would work at the moment... but the masterlist could exceed 4000 one day.
I would prefer a more stable solution if possible... but thanks for the idea! 🙂

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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,068)