Unanswered

Simple RemoveIf does not work

(0) Share

Report

Posted on by Community Power Pla...

I use RemoveIf very often, never had any problems.

I have 3 SP lists (each 20k+ records). I want to remove records from them. There are 1-20 rows for each criteria per SP list.

When I click a button, something is going on for a few seconds and then it is done. I get no errors, but records are still present in SP list. Criteria types are correct. This is not first time I used this command on these lists. Today it is not working.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous ,

Although RemoveIf() is not Delegable (it will not remove more than your Delegation Limit, your filters seem to be, however try the following (first example here)

With( { wRecords: Filter( approve_events, TripID = "21122_28660" ) }, RemoveIf( approve_events, ID in wRecords.ID ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz thank You for possible solution. at first it didn't paste but I changed it a little:

Anyways it does not work - records are still present in the list.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

@Anonymous ,

Yes - free-typing tends to do that (I have fixed original).

However there is no reason this should not work (in fact your original code should work). One of my productions apps deletes records in 50k+ Libraries with the ID as the criteria using the same structure.

I assume Trip_ID is a Single Line of Text ?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@WarrenBelz correct - it is single line of text and is in Title column.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (2)

Report
@Anonymous ,

Have you tried

With( { wRecords: Filter( approve_events, Title = "21122_28660" ) }, RemoveIf( approve_events, ID in wRecords.ID ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (1)

Report

@WarrenBelz if that doesn't work, is there a chance it's a potential list permissions issue?.. inadvertent change... or would that usually flag an error?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

@AmDev ,

Good thought, but it should generate an error. @Anonymous - worth looking at though

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Thank You for support. It didn't work, I created a blank app and tried to run

RemoveIf(approve_Events,TripID="211222_28660");

It took about 15 seconds but it worked.

Previously I tried to run all commands on my Testing app. I always test or do attitional operations in that app. Perhaps it became corrupted after hundreds of tests and commands didn't work properly.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,
As I said at the start of this, your original code should have worked.

Was this reply helpful? Yes No
Ferminaterz 150 on at

Like (0)

Report

I am getting the same thing. I had the RemoveIf using the title column and was working find and it stopped. Tried to troubleshoot and created a collection that only pulled that title. I can use every other column to RemoveIf and it clears my collection but not the Title column for some reason.

Was this reply helpful? Yes No