cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SkiDK
Solution Sage
Solution Sage

Forall with collect freezes app

Hi everyone,

I suppose this is pretty common, but I was wondering if there is a better alternative for it.

In an app I have two collections A and B. Both are exactly the same. At some point I want to collect all the records from collection B into collection A. Basically I do it like next:

ForAll(
    collectionB,
    Collect(
        collectionA,
        ThisRecord
    );
);

However, when the ForAll runs, the app completely freezes. It could be that collectionB has several hundreds of records, which then freezes the app for even a few minutes. When the ForAll is finished, then the app unfreezes again and all records from B are loaded into A.

Is there a better way to do it? This way is just not very user friendly, as for the users it just looks like the app is crashing.


Advice is much appreciated. Thanks,

Ski

1 ACCEPTED SOLUTION

Accepted Solutions
SkiDK
Solution Sage
Solution Sage

Okay, I don't know why I was being so retarded. 

Of course why don't I just Collect the on collection in the other?

Collect(collectionA, collectionB);

At the end of some days you just can't think straight again. Sorry! 

View solution in original post

1 REPLY 1
SkiDK
Solution Sage
Solution Sage

Okay, I don't know why I was being so retarded. 

Of course why don't I just Collect the on collection in the other?

Collect(collectionA, collectionB);

At the end of some days you just can't think straight again. Sorry! 

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,215)