Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
[This topic is pre-release documentation and is subject to change.]
The article helps you get started with functions in Microsoft Dataverse by integrating them into your apps. You'll understand that the authoring experience includes authoring Dataverse custom APIs backed by Power Fx expressions, which can trigger actions internal or external to Dataverse.
Important
You can test a Power Fx expression to verify it's working. This example uses the Abs()
function to return the non-negative value of its argument. If a number is negative, Abs
returns the positive equivalent.
Sign into Power Apps and select Functions from the left navigation. If the item isn’t in the side panel pane, select …More and then select the item you want. Open the unmanaged solution where you want to add a function.
Select New function.
On the New function pane, enter a Display name, such as Return non-negative value, and Description for your function.
Create a New output parameter to validate expected behavior, such as a string. For example, enter the Name of your New Output parameter Out.
Optionally, use input parameters to make testing easier, that makes sense with the formula. In this example, no input parameters are used.
In the Formula box, wrap the Out parameter in curly brackets: {Out: "" }
For example, you can test the Abs() function, which uses -5 to return the absolute value 5.
{Out: "Abs(-5)=5:"& Text(Abs(-5) = 5) }
Select Save.
To test the function, select the function and then select Test on the command bar. Then select Play. Based on the formula used in this example function, the response returns the value 5 as true.
This and more samples coming soon.
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Introduction to expressions in Power Automate - Training
Learn how to write expressions in Power Automate.
Certification
Microsoft Certified: Power Platform Fundamentals - Certifications
Demonstrate the business value and product capabilities of Microsoft Power Platform, such as Power Apps, data connections with Dataverse, and Power Automate.