Answered

Remove function takes so much time to run

(0) Share

Report

Posted on by asdadasdasdasss

Since the others table contains the foreign key, so I have to delete it first. But it takes too much time to complete the whole delete process. Can someone help me to optimize my code?

//remove foreign key
Set(InitialInjuredPerson_Activity,
 RemoveIf(
 InjuredPerson_Activity,
 InjuredPersonId = InjuredPersonDeleteID
 )
);

Set(InitialInjuredPerson_SuspectedInjured,
 RemoveIf(
 InjuredPerson_SuspectedInjured,
 InjuredPersonID = InjuredPersonDeleteID
 )
);

Set(InitialInjuredPerson_OngoingPlan,
 RemoveIf(
 InjuredPersion_OngoingPlan,
 InjuredPersonID = InjuredPersonDeleteID
 )
);

//remove main table
Set(InitialInjured_Person,
 RemoveIf(
 Injured_Person,
 InjuredPersonID = InjuredPersonDeleteID
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @asdadasdasdasss ,

Have you tried the Concurrent function to perform these formulas in parallel? At first glance there doesn't seem to be a dependency between the four, so you can give this a try:

Concurrent( //remove foreign key Set(InitialInjuredPerson_Activity, RemoveIf( InjuredPerson_Activity, InjuredPersonId = InjuredPersonDeleteID ) ), Set(InitialInjuredPerson_SuspectedInjured, RemoveIf( InjuredPerson_SuspectedInjured, InjuredPersonID = InjuredPersonDeleteID ) ), Set(InitialInjuredPerson_OngoingPlan, RemoveIf( InjuredPersion_OngoingPlan, InjuredPersonID = InjuredPersonDeleteID ) ), //remove main table Set(InitialInjured_Person, RemoveIf( Injured_Person, InjuredPersonID = InjuredPersonDeleteID ) ) )

Was this reply helpful? Yes No
asdadasdasdasss 33 on at

Like
a
(1)

Report
Copy link

Link copied!
Thanks for your answer! I thought the concurrent only could use in On Start property. But I would like to ask you whether the code below will wait for the "concurrent" finishes and then proceed with the last code.

Concurrent( //remove foreign key Set(InitialInjuredPerson_Activity, RemoveIf( InjuredPerson_Activity, InjuredPersonId = InjuredPersonDeleteID ) ), Set(InitialInjuredPerson_SuspectedInjured, RemoveIf( InjuredPerson_SuspectedInjured, InjuredPersonID = InjuredPersonDeleteID ) ), Set(InitialInjuredPerson_OngoingPlan, RemoveIf( InjuredPersion_OngoingPlan, InjuredPersonID = InjuredPersonDeleteID ) ) ) //remove main table Set(InitialInjured_Person, RemoveIf( Injured_Person, InjuredPersonID = InjuredPersonDeleteID ) )

Was this reply helpful? Yes No