Answered

Asynchronous Function Executing

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I have a button with the following code

RemoveIf(datasource, GUID = Var_GUID);
Collect(datasource, {GUID = Var_GUID, xxxxxx});

Basically, it is to remove all the existing records and collect a set of new.

The issue I encounter is that second collect function does not always execute as expected,
The thought in my mind is that the first syntax is still being executed then the second started therefore a conflict.

Anyone have affirmative mechanism or how to solve it?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Anonymous ,
Any specific reason to use Collect instead of ClearCollect?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @Anonymous :

The formulas separated by ";" in the Canvas app are executed in order. RemoveIF must have been executed before the Collect is executed.

I suggest you check whether there may be a problem with "{GUID = Var_GUID, xxxxxx}" (for example, whether there are duplicate values in a field that does not allow duplicate values).

In addition,maybe you could try this formula:

RemoveIf(datasource, GUID = Var_GUID); Refresh(datasource); Collect(datasource, {GUID = Var_GUID, xxxxxx});

Best Regards,

Bof

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

Like (0)

Report

Hi Thank you for your reply.

I also noticed that, my previous concern was it is just an order sending to the server.
While server takes time to execute, the second syntax is excuting before the server finishes.

Now I know the order is executed only when the previous one finishes

Was this reply helpful? Yes No
KeithHo1 4 on at

Like (0)

Report

I found that PowerApps does not wait for the completion of the refresh function before executing the next function. Are there any asynchronous or .then functions available to make the app wait for the refresh? Currently, I'm only using a timer to wait for 3 seconds before refreshing.

Was this reply helpful? Yes No