![\"How](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/How-to-Use-User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n<\/p>\n
Building Canvas Apps in PowerApps presents a challenge. Microsoft has provided great built-in functions, but what if your App needed something other than the built-in functions? You would have to create workarounds\u2014repeating formulas, juggling nested logic, and spending extra time managing it all. It worked, but it wasn\u2019t ideal.<\/p>\n
Now, Microsoft is upgrading the process by introducing the User-Defined Functions (UDFs)<\/strong>! This upcoming feature will let you create your own custom functions, perfectly tailored to your App\u2019s needs.<\/p>\n Here\u2019s why it\u2019s useful:<\/p>\n Imagine you are building a Tax Calculator feature for Business and Salary income in your App. Previously, you might have to write the same formula on different buttons to calculate taxes for salary and business income.<\/p>\n With User-Defined Functions (UDFs), you can simply create a function like TaxCalculator() and reuse it across forms, pages, and buttons. Efficient and consistent, right?<\/p>\n Moreover, UDFs can be combined with user-defined types (UDTs)<\/strong> to handle complex data like records or tables in one go.<\/p>\n User-Defined Types (UDTs)<\/strong> are advanced features in PowerApps that enable App developers to create custom data types.<\/p>\n Launch your application in Power Apps<\/a>, then go to Settings <\/strong>in the command bar and select Updates<\/strong>. Next, within the Experimental <\/strong>tab, turn on both the User-Defined Functions <\/strong>and User-Defined types<\/strong> options to start adding UDFs and UDTs in your App.<\/p>\n Let\u2019s explore a simple example to see how User-Defined Functions (UDFs) can make your app smarter and cleaner.<\/p>\n Imagine you have a tax calculator over two forms: one for business owners and another for salaried employees. Each form has similar fields that are used to calculate tax for business and salary.<\/p>\n Depending on which button is clicked, the app should calculate the tax based on the user\u2019s input fields like income, tax rate, deductions, etc.<\/p>\n Before UDFs, you might have written separate logic for each button on every form, making your app cluttered and hard to manage. But with UDFs, you can create a single reusable function and simply adjust the parameters based on the button clicked and the form it\u2019s used on.<\/p>\n Here\u2019s how it works:<\/p>\n Step-by-Step Process to Set <\/strong>Up UDFs:<\/strong><\/p>\n Open your Canvas App<\/strong> in Power Apps.<\/p>\n Below is a simple function that is added to calculate the tax based on the income and other details given by the user.<\/p>\n UDF Function:<\/strong><\/p>\n TaxCalculator2(<\/p>\n Income: Number,<\/p>\n TaxRate: Number,<\/p>\n Deductions: Number,<\/p>\n Allowances: Number,<\/p>\n TDS: Number<\/p>\n ): Number =<\/p>\n (Income – Deductions – Allowances) * (TaxRate \/ 100) – TDS;<\/p>\n Add this UDF function<\/strong> inside the PowerFx formula after selecting Named Formula<\/strong>.<\/p>\n Now I will be calling this function on multiple events, and in our scenario, I will be calling it on the click of Calculate<\/strong> buttons for business and salary income.<\/p>\n Here is my Salary tax calculator on the Canvas App form:<\/p>\n Here is another Business income tax calculator on another Canvas App form:<\/p>\n I have added a function on click of these buttons as you can see below, OnSelect<\/strong> is my event which will call my function named TaxCalculator()<\/p>\n Similarly, if the user clicks the Button added to the Salary Tax Calculator form then the same function will be triggered :<\/p>\n The different parameter is passed on the click of both buttons but the function is the same which is TaxCalculator().<\/p>\n In the current example for Salary Tax Calculation, we are taking inputs like Income, Tax Rate, Allowance, TDS, and Deductions from the form fields that the user will fill in.<\/p>\n Based on these inputs, the app calculates the tax and displays the result to the user, ensuring accurate and dynamic calculations.<\/p>\n Similarly, to Calculate the Business Income Tax, we have added a few fields on form page like, Gross revenue, COGs, Operating Expenses, Net Profit, Income, Deductions, Allowance, and TDS.<\/p>\n Let\u2019s dive into an example that shows the use case of User-Defined Types (UDTs)<\/strong> in simplifying how we work with custom or structured data type.<\/p>\n Imagine you\u2019re building an App which is a product inventory system<\/strong> that handles orders. Each order has details like the Order ID, Customer Name, Status, Delivery Date, and more. Before UDTs, you\u2019d manage these fields individually, which could lead to messy code and repeated work.<\/p>\n With UDTs, you can define a custom type to group all these fields into a single, reusable structure.<\/p>\n The basic syntax to define a UDT looks like this:<\/p>\n Step 1: Get the Data<\/strong><\/p>\n Here, ProductType is the custom type, and it contains the fields:<\/p>\n Step 2: Define the UDT Type<\/strong><\/p>\n We can define types for a single product as a special named formula that uses the := assignment operator and Type<\/em> function.<\/p>\n ProductType <\/em>:=<\/em> Type<\/em>(<\/em> {<\/em> ProductID: Text<\/em>,<\/em> ProductName: Text<\/em>,<\/em> Price: Number<\/em>,<\/em> StockQuantity: Number <\/em>}<\/em> )<\/em>;<\/em><\/p>\n Step 3: Using the User-Defined Types inside User-Defined Functions<\/strong><\/p>\n Now that we have a ProductType which is a custom data type, to use this data type we will be creating a UFD<\/strong> inside which we will be using the product type data type.<\/p>\n Inside the UFD, it will take in a product and calculate its total value based on the stock quantity and price of the product.<\/p>\n Here is the User-defined function:<\/p>\n TotalValue<\/em>(<\/em> Product: ProductType <\/em>)<\/em>: Number <\/em>=<\/em> Product.Price <\/em>*<\/em> Product.StockQuantity;<\/em><\/p>\n This function which is TotalValue<\/em>, takes in a Product<\/em> (data type <\/em>ProductType<\/em>)<\/em> and returns the total value of that product in stock.<\/p>\n Here is How you could define the data and the custom data type inside the power fx formulas as shown below:<\/p>\n Let\u2019s say we have a table of products, and we want to calculate the total value of each product in stock. Here\u2019s how we can do it:<\/p>\n TotalValue(First( Products ))<\/p>\n Here, we call the TotalValue<\/em> function, passing the first product from the Products table, and then the function calculates and returns the total value (Price * StockQuantity).<\/p>\n We will be calculating the first product and the data inside that product is Price = 1000 and StockQuantity = 50.<\/p>\n As per the TotalValue <\/em>function, It should return the value which is (Price * StockQuantity) i.e: 1000* 50 = 50000 as you can see in the screenshot below.<\/p>\n Conclusion<\/strong><\/p>\n In this blog, we explored the capabilities of User-Defined Functions (UDFs)<\/strong> and User-Defined Types (UDTs)<\/strong> in PowerApps, showcasing how they enable more structured and reusable app logic.<\/p>\n By defining your own data types and leveraging UDFs, you can simplify complex processes, improve maintainability, and enhance the flexibility of your applications. The button-click example shows how you can easily change parameters to create flexible solutions for different needs.<\/p>\n","protected":false},"excerpt":{"rendered":" Building Canvas Apps in PowerApps presents a challenge. Microsoft has provided great built-in functions, but what if your App needed something other than the built-in functions? You would have to create workarounds\u2014repeating formulas, juggling nested logic, and spending extra time managing it all. It worked, but it wasn\u2019t ideal. Now, Microsoft is upgrading the process\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1954,38,2361],"tags":[1988],"class_list":["post-40298","post","type-post","status-publish","format-standard","hentry","category-canvas-apps","category-microsoft-powerapps","category-technical","tag-canvas-apps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/40298","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=40298"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/40298\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=40298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=40298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=40298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
Prerequisites<\/strong><\/h2>\n
![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/1User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\nExample Use Case of User-Defined Function<\/strong><\/h2>\n
\n
![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/2User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/3User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/4User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/5User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/6User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\nNotify($\"{TaxCalculator(\r\n\r\nbusiness_profit<\/em>.Text,\r\n\r\nbusiness_taxRate<\/em>.Text,\r\n\r\nbusiness_deductions<\/em>.Text,\r\n\r\nbusiness_allowance<\/em>.Text,\r\n\r\nbusiness_tds<\/em>.Text)}\"\r\n\r\n)<\/pre>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/7User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\nNotify($\"{TaxCalculator(\r\n\r\nsalary_income.Text,\r\n\r\nsalary_taxRate.Text,\r\n\r\nsalary_deductions.Text,\r\n\r\nsalary_allowance.Text,\r\n\r\nsalary_tds.Text)}\"\r\n\r\n)<\/pre>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/8User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/9User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\nExample Use Case for User-Defined Types<\/strong><\/h2>\n
Products =[\r\n{ProductID:\"P001\",ProductName:\"Laptop\",Price: 1000,StockQuantity:50},\r\n\r\n{ProductID: \"P002\", ProductName: \"Smartphone\", Price: 500, StockQuantity: 100},\r\n\r\n{ProductID: \"P003\", ProductName: \"Tablet\", Price: 300, StockQuantity: 200 }\r\n];<\/pre>\n\n
![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/10User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/11User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n![\"User-Defined](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/12User-Defined-Functions-and-User-Defined-Types-in-Canvas-Apps.png\")
<\/p>\n