Announcements
With more complex power apps consuming multiple data sources and where relationships exist between the data sources it almost seems inevitable to me that you'll need to use collections (and probably multiple collections). This just creates extra complexity in the app to allow for the necessary UI. I realize I'm making a general statement.1) But if I'm correct, that immediately solves the problem of delegation as you can let the data sources flow in all the data and then perform the filters on the collections (which if I understand correctly don't have delegation concerns). 2) But that seems to me that if you then need to change a value in a variable that you are looking at on the screen and that value is being shown through a collection then it means most likely you have to update the data source in the original table and possibly the collection as well - am I right? 3) I suppose I can force a refresh of the source data tables but I'm wondering about the performance of that. Thoughts.I realize that's a high level question but does anyone have any experience with these more complex scenarios.
@sasrsc
Basically, for maximal efficiency the datasource should be able to handle millions of records with maximum delegatable functions and operators. Only SQL and CDS meet those requirements. This minimizes the need for collections.
1) Using Collections doesn't solve the problem of delegation because you still have to get the values into the collection from the online data source. Get that data can take substantial time if its a large data source.
2) Yes, using a local collection means changing things in both places. It also makes it difficult if the data needs to be shared between multiple users because each person will be making changes to their local collections. Updates will only really be shared when people load the data the first time. As mentioned in #1 that can take a substantial amount of time so you wouldn't do it for every change.
3) See #1 and #2. Refreshing the data source in this case will be minimized to improve performance.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
