PowerApps - Explicit Column Selection

By Vinod Thachin -

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 with enabling the setting in the PowerApps as 

  • Sometimes there will be issues with the dropdown fields data.
  • Data will show blank sometime by directly without passing the column names. For example on the query below, 
                ClearCollect(colEmplData, Filter('[dbo].[Employee]', EmpID=35)) 

          this query returns empty data sometimes (Not always if any references mentioned). Passing the values below, will give us the exact data.

                ClearCollect(colEmplData, Filter('[dbo].[Employee]', EmpID=35),"Name", "Salary") 
            



Comments

Post a Comment

Popular posts from this blog

Linksys Wireless Connection Failure

By -
I configured the Linksys wireless router [WRT54G] couple of years before and it just worked great. I myself configured the password and everything worked great at my home. Anyone comes in home takes my password and it just worked great most of the time. all these were with windows server 2003 and Dell machaines. When I bought a new Hp DV9000 (XP) I had an issue connecting to the home wireless. I started browsing and found this solution: Issue : Couldn't connect to the selected connection. 1. Installed an update http://www.microsoft.com/downloads/thankyou.aspx?familyId=17d997d2-5034-4bbb-b74d-ad8430a1f7c8&displayLang=en Issue after the update : Acquiring Network address status and stayed there. Did the following after that: 1. Browsed http://192.168.1.1/ 2. used the user-id / password of the connection (default userid is empty & pwd is admin) 3. Navigated to wireless (Basic wireless settings), click Reset security and name your userid for SSID 4. Clicked save settings 5. cli
Read more

The security validation for this page is invalid. Click Back in your Web

By -
If you are getting the following error, while renaming the page title using publishingpage object " The security validation for this page is invalid. Click Back in your Webbrowser, refresh the page, and try your operation again ." Code Snippet: PublishingWeb publishingweb = PublishingWeb.GetPublishingWeb(newUri(" http://YourPortal/Plans/ ")); PublishingPage pp =publishingweb.GetPublishingPages()["Pages/TestArticle.aspx"]; pp.Title = e.Node.Text; pp.Update(); You should check for this : Navigate thru the followwing and turn the security validation Off Central Administration--->application management---->web application settings-->"turn security validation off"
Read more

Power Apps toPower Automate Error - The input body for trigger 'manual' of type 'Request' did not match its schema definition , the input String does not validate against the date

By Vinod Thachin -
While working with power Apps to Power automate, passing the Date time values as Text(DateTimeValue) throws error as below. The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'String '' does not validate against format 'date'.'. After checking the Microsoft documentation and few blogs i found out the date values should be passed as a formatted date time. TO pass the date time  we need to use following functions. Text(<<DateTimePicker>>.SelectedDate,"[$-en-US]yyyy-mm-dd") Even after passing the value i am still seeing the same issue and finally found out the default value ids sending as empty and formulae failing for empty values. So we need to make sure the Date Value should not go blank to the formulae and the value should be formatted using the formulae as above. Hope this helps.
Read more