PowerApps - Explicit Column Selection
Explicit Column Selection is an option PowerApps to improve the Performance. Microsoft provided an option to enable and disable the "Explicit Column Selection" as below. By enabling the Explicit Column Selection option PowerApps performance will be increased. Enabling Column Selection option allows to get the columns from the backend database (only for the Data verse and SQL). This will improve performance by retrieving only the data in the rows and columns that are necessary. For example, If we are selecting the Employee table, we try to display Employee Name and Address fields in the gallery, Enabling the setting will get only Employee Name and Address. If we disable the field it will get all the data from Employee table. Getting required fields and Getting all the fields will be affected the Performance of the PowerApps like we have 10 columns in a table of 2000 rows with size 412 bytes, we are just pulling 2 columns less than 100 bytes. There are few issues wi...