PL 400: Implement complex formulas to manage control events and properties (Create canvas apps)

The most interesting factor of Power Platform is that anyone can design/build apps. To simplify the complexity of the code, Microsoft introduced formulas that work like Excel. With the help of formulas, the user can enhance the functionality, performance and user experience in Power Apps.

According to Wikipedia:

In Science,  a formula is a concise way to expressing information symbolically, as a mathematical formula or a chemical formula.


In computer science, formula is used as the term for computing, but in power apps, the user can calculate and take action as well as alter the user experience. These formulas are easily included with controls and used with events.

In March 2021, Microsoft has now extracted these formulas and syntax into an independent language called Power Fx. In development, there are two points that may be worth noting:

  • This is the common language that Power will use across products in the platform.
  • It is open source.

Below formulas are frequently used in the Canvas Apps:

Conditional Formatting:

Apply conditional formatting to app is a great way to enhance the look and feel as well as user experience.

If(Sum(Value(TextInput1.Text), Value(TextInput3.Text)) > 50, Color.DarkGreen, Color.Darkred)

Function for Validating Data:

IsBlank -- This function checks a field, property, or variable to see if the result is blank. If the object is blank, then the function returns true.

IsBlankOrError -- This function checks whether an expression is blank or results in an error, and returns true or false.

IsEmpty -- This function checks a table of data to see if it contains records. If the table is empty, then the function returns true.

IsMatch -- This function checks a field, property, or variable to determine if the result matches the specified pattern. If the pattern is a match the function returns true. For details about the various matching patterns, see IsMatch function in Power Apps.

IsNumeric -- This function checks a field, property, or variable to determine if the result is numeric. If the object is numeric, then the function returns true.

IsToday -- This function checks if a date or time value is between midnight today and midnight tomorrow. If the date or time value is within that range, the function returns true.

Power Apps includes the following counting functions:

Count counts the number of records that contain a number in a single-column table.

CountA counts the number of records that aren't blank in a single-column table. This function includes empty text ("") in the count.

CountIf counts the number of records in a table that are true for a logical formula. The formula can reference columns of the table.

CountRows counts the number records in a table.

Count and CountA only support single-column tables, and that is the only argument they accept.

CountIf accepts a table and then the logical formula to process. It then returns a count of all of the records that match the logical formula.

CountRows accepts only a table as an argument and then returns a count of the number of rows in that table.

Change the screen that's displayed : Back and Navigate function

Control a Signal : Enable and Disabled function

Refresh, Update or Remove items in a Data Source: Refresh, Update, Updateif, Patch, Remove, Removeif

Update a context variable: UpdateContext function

Create, Update or rename items in a collection : Collect, Clear, ClearCollect

The Not Function returns the opposite of true or false.


Comments

Post a Comment

Popular posts from this blog

Powering Up Your Analytics: Exploring Power Query in Power BI

Image
Data is a valuable asset that has a profound impact on almost every aspect of modern life. Its proper collection, analysis and application can promote innovation, improve efficiency and solve complex challenges in various sectors. In data processing, ETL is a comprehensive process that includes data extraction, transformation, and loading, while Power Query is a specific tool that facilitates the "extract" and "transformation" aspects of ETL, allowing data to be collected and analyzed. Permission is granted to process. And reporting. is ready. It becomes easy to do this. Microsoft's ecosystem of products. Power Query is a data transformation and data preparation engine. Power Query is available in Microsoft Excel and Power BI. Power Query provides a user-friendly and intuitive interface for data professionals and analysts to access and manipulate data from various sources without the need for extensive coding or scripting. It allows users to connect to a wide ra
Read more

Power App Component Overview : Canvas App vs Model-Driven App

Image
The Power Platform is a suite of low-code/No-code tools and technologies developed by Microsoft and Power App is integral component of Power Platform. Power App is platform that enables users to build custom web and mobile applications with a visual interface and minimal coding. The platform support various data sources, including Microsoft 365, Azure Service, and many other, enabling users to integrate and interact with their existing data and systems. In Microsoft's Power Apps, there are two main types of apps that we can create: Canvas Apps: Canvas apps provide a blank canvas where you can design highly customizable applications with a drag-and-drop interface.  Model-Driven Apps: Model-driven apps are built on top of the Dataverse, which provides a set of pre-built data entities and business logic. There are few key technical difference between Canvas App and Model Driven App: During the usability analysis, these high-level technical differences need to be considered. The choi
Read more

Exam PL-400: Microsoft Power Platform Developer

 Create a technical design (10-15%) Validate requirements and design technical architecture design and validate the technical architecture for a solution design authentication and authorization strategy determine whether you can meet requirements with out-of-the-box functionality determine when to use Logic Apps versus Power Automate flows determine when to use serverless computing, plug-ins, or Power Automate determine when to build a virtual entity data source provider and when to use connectors Design solution components design a data model design Power Apps reusable components design custom connectors design server-side components Describe Microsoft Power Platform extensibility points describe Power Virtual Agents extensibility points including Bot Framework skills and Power Automate flows describe Power BI extensibility points including Power BI APIs, custom visuals, and embedding Power BI apps in websites and other applications describe Power Apps portal extensibility points incl
Read more