Isssue is with RemoveIf() function in PowerApps

(0) Share

Report

Posted on by sayyed007amir

357

I use this code to remove old records and add new:

RemoveIf(DailyDiaryContractor,ProjectLinkID=Gallery1.Selected.ProjectLinkID);

this is not working 1st time when i open app and patch record.
After that its working for n times.
Don't know why it have issue with 1st time only.
Note: My SharePoint list having more than 5000 records.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-yutliu-msft Microsoft Employee on at

Like (1)

Report

Copy link

Link copied!

Hi @sayyed007amir ,

Do you mean that if you directly use removeif function it doesn't work, if you firstly patch then removeif it will work?

Could you check the item ID that you select at the first time and the second time?

Actually, I do not think your formula has any problem.

I think this is a delegation problem.

RemoveIf function is not delegate , which will lead to some problems.

What's more, there's no delegate function about removing action.

The table of delegate functions for sharepoint:

Item	Number	Text	Boolean	DateTime	Complex [1]
Filter	Yes	Yes	Yes	No [4]	Yes
Sort	Yes	Yes	Yes	Yes	No
SortByColumns	Yes	Yes	Yes	Yes	No
Lookup	Yes	Yes	Yes	No	Yes
=	Yes	Yes	Yes	No [4]	Yes
<, <=,<>, >, >=	Yes [2]	No	No	No	Yes
StartsWith	-	Yes	-	-	Yes
IsBlank	-	No [3]	-	-	No

To solve this problem, I suggest you split your list to 3 lists.

Powerapps could at most delegate 2000 records.

Also, please change the delegation limit to 2000.

Best regards,

Was this reply helpful? Yes No

Verified answer

sayyed007amir 357 on at

Like (0)

Report
Copy link

Link copied!
I solved this issue by showing those list data in Gallery (previously i was collecting data based on primary id).
Now i added a button in Gallery with code (Buttons's Onselect):
Select(Parent);Remove(DataSource,ThisItem);

Was this reply helpful? Yes No