issues in Removeif and updatecontext

(0) Share

Report

Posted on by Veblitz

2,249

I am facing issue on the below code as its not removing items properly from the current screen and please help

updatecontext({spinnersearch:true});

RemoveIf( Employee,Empid=Empid1);

If(

IsBlank(Lookup(Employee,Empid=Empid1)),

RemoveIf(Employee_Lookup,Eid=Empid1));

RemoveIf(Emp_dept_lo,Empid=Empid1);

RemoveIf(Attachments,Eid=Empid1);

ClearCollect(AttachmentID,Filter(Attached_docs,Eid=Empid1));

ForAll(AttachmentID,RemoveIf(Attached_docs,ID=AttachmentID[@ID]));

UpdateContext({Empdelete:false,spinnerLoad:false,Empid1:Blank(),vardept:false,Attachtab:false,regvisible:false,deptSearchNew:false});

Reset([@txtsearch]);UpdateContext({Spinnersearch:false})

Categories:

Building Power Apps

All responses (24)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Veblitz

Please consider changing your Formula to the following:

UpdateContext({Spinnersearch:true}); RemoveIf(Employee, Empid=Empid1); If(!Lookup(Employee,Empid=Empid1, true), RemoveIf(Employee_Lookup,Eid=Empid1)); RemoveIf(Emp_dept_lo,Empid=Empid1); RemoveIf(Attachments,Eid=Empid1); ForAll(Filter(Attached_docs,Eid=Empid1) As _item, RemoveIf(Attached_docs, ID=_item.ID)); UpdateContext({Empdelete:false,spinnerLoad:false,Empid1:Blank(),vardept:false,Attachtab:false,regvisible:false,deptSearchNew:false}); Reset(txtsearch); UpdateContext({Spinnersearch:false})

I hope this is helpful for you.
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your inputs.
unfortunately,it is not working.
I placed the above code in the yes button on select property,when i click on delete button it throws the popup in that yes or no will display so the above code is placed in yes button onselect and now button got freezed and no luck.Kindly help
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Veblitz

I am not sure I am following what you mean by it froze.

Are these collections or datasources that you are working with? The suggested formula should work based on what you had, so I would need more details on the sources of the formula.
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure. when i click yes button there was no luck.i am using sharepoint list in the back end,
these are collections . At UI level ,grouped 2 buttons for pop notification which has yes ,no button and the above code is placed inside the yes to perform the delete .

Could you please help me to understand what was the issue with my above code that i shared and that was failing to delete properly?

Kindly revert incase of any details.Thanks again
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

Appreciate kind help.
Further,i am newly working with powerapps apps design
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

As per my above code its deleting properly on saving my apps
when i try to test my code after publish apps its failing partially.
it seems to be inconsistent before and after publish apps

Appreciate kind help in this regards
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Veblitz

If there is an inconsistence, then usually there is something that is converting incorrectly and improperly referenced in the Formula.

Tell me about the items highlighted in the formula below:

RemoveIf(Employee, Empid=Empid1);
If(!Lookup(Employee,Empid=Empid1, true), RemoveIf(Employee_Lookup,Eid=Empid1));

RemoveIf(Emp_dept_lo,Empid=Empid1);
RemoveIf(Attachments,Eid=Empid1);

ForAll(Filter(Attached_docs,Eid=Empid1) As _item, RemoveIf(Attached_docs, ID=_item.ID));

For the RED - what are each of these? Collections or your Datasource? If collection, how are they defined and where are you adding or removing items to that collection in your app?

For the Green - what, exactly, are those in your datasource? Are they numeric or text?

For the Blue - what is this and how is it defined?
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

For the Red-datasource is sharepoint list
For the Green- number field in the sharepoint list datasource
For the Blue- variables defined in the section control
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

For the blue: under the gallery control, Empid1 is declared as variable that binds the current selected empid and it defined as below in the app

updatecontext({Empid1:Thisitem.Eid});
Veblitz 2,249 on at

Like
a
(0)

Report
Copy link

Link copied!

After publish issue is associated with the below line of code,this section is not getting removed hence it performs only partial deletion
If(
IsBlank(Lookup(Employee,Empid=Empid1)),
RemoveIf(Employee_Lookup,Eid=Empid1));