Avoiding connecting directly to data sources
One of the biggest aspects when talking about applications created using Power Apps is performance. Most canvas apps use external information, which could be an Excel file, a SharePoint list, or some of the other data sources available.
To interact with these data sources, you can use galleries, forms, and other controls that will either consume or send data to the data source, and here is one of the main points where we can improve our applications, especially when talking about consuming data from the data source.
In the Using variables to store data section, we talked about collections, and this is a great way to avoid connecting a gallery (consuming data from the data source) to the data source directly.
When you have a gallery connected directly with the data source, filtering and interacting with the data will fetch the data once again from the data source, and it can overload your app's performance, depending on how...
