web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Asynchronous Function ...

Power Apps

Answered

Asynchronous Function Executing

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
KeithHo1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Join the conversation