FinalAmount (Float)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/06\/3Power-Fx-Functions-Preview-in-Power-Apps.png\")
<\/p>\n
Formula :\r\nWith(\r\n\r\n{\r\n\r\n\u00a0\r\n\r\ndiscount:\r\n\r\nIf(\r\n\r\ninvoiceTotal >= 3000 && invoiceTotal <= 5000, 0.1,\r\n\r\ninvoiceTotal > 5000 && invoiceTotal <= 10000, 0.2,\r\n\r\ninvoiceTotal > 10000, 0.3,\r\n\r\n0\r\n\r\n)\r\n\r\n},\r\n\r\n{\r\n\r\nDiscountApplied: discount,\r\n\r\nFinalAmount: invoiceTotal * (1 - discount)\r\n\r\n}\r\n\r\n)<\/pre>\nOnce defined, Click Save Then click Publish.<\/p>\n
Step 3: Test the Power Fx Function<\/strong><\/p>\nClick the ellipsis (\u2026) next to the function.<\/p>\n
Click Test.<\/p>\n
![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/06\/4Power-Fx-Functions-Preview-in-Power-Apps.png\")
<\/p>\n
Enter a test value for invoiceTotal and click Play<\/p>\n
You will see the discount applied and final amount returned.<\/p>\n
![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/06\/5Power-Fx-Functions-Preview-in-Power-Apps.png\")
<\/p>\n
Step 4: Integrate above Power Fx Function in Canvas App<\/strong><\/p>\nWe\u2019ll now use this function in a simple app named GroceryDiscountApp.<\/p>\n
1. Add a Button to Create Sample Cart.<\/p>\n
Set its OnSelect<\/strong> property to:<\/p>\nClearCollect(<\/em>\r\n\r\n\u00a0\u00a0\u00a0 colCart,<\/em>\r\n\r\n\u00a0\u00a0\u00a0 { Item: \"Item1\", Quantity: 2, Price: 1000 },<\/em>\r\n\r\n\u00a0\u00a0\u00a0 { Item: \"Item2\", Quantity: 1, Price: 400 },<\/em>\r\n\r\n\u00a0\u00a0\u00a0 { Item: \"Item3\", Quantity: 3, Price: 100 }<\/em><\/pre>\n2. Add a Gallery to Display Cart Items.<\/p>\n
Set its Items property to:<\/p>\n
\u00a0colCart<\/em><\/p>\nInside the gallery, add labels to show:<\/p>\n
\n- Item<\/em><\/li>\n
- Quantity<\/em><\/li>\n
- Price<\/em><\/li>\n
- Quantity * ThisItem.Price<\/em><\/li>\n<\/ul>\n
3. Add a Button to Calculate Discount.<\/p>\n
Set its OnSelect property to:\r\n\r\nSet(invoiceTotal, Sum(colCart, Quantity * Price));<\/em>\r\n\r\nSet(discountResult, Environment.cr860_CalculateGroceryDiscount({ invoiceTotal: invoiceTotal }))<\/em><\/pre>\n4. Add two labels:<\/p>\n
Label 1 (Discount): \"Discount: \" & Text(discountResult.DiscountApplied * 100) & \"%\"<\/em>\r\nLabel 2 (Final Amount): \"Final Amount: \u20b9\" & Text(discountResult.FinalAmount)<\/em><\/pre>\nClick > Preview the app > generate the cart, run the function, and display the results!<\/p>\n
![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/06\/6Power-Fx-Functions-Preview-in-Power-Apps.png\")
<\/p>\n
This enables you to include the function in your Power Apps formulas, treating it like other standard Power Fx functions.<\/p>\n
Note : Currently, The Power Fx Function is in Preview State.<\/em><\/strong><\/p>\n
![\"Exploring](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/06\/Exploring-the-Potential-of-Power-Fx-Functions-Preview-in-Power-Apps.png\")
<\/p>\n![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/06\/1Power-Fx-Functions-in-Power-Apps.png\")
<\/p>\n![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/06\/2Power-Fx-Functions-Preview-in-Power-Apps.png\")
<\/p>\n