title | description | author | ms.topic | ms.custom | ms.reviewer | ms.date | ms.subservice | ms.author | search.audienceType | contributors | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Formula reference - Dataverse |
Reference information for functions, signals, and enumerations in Dataverse. |
gregli-msft |
reference |
canvas |
mkaur-msft |
09/10/2022 |
power-fx |
gregli |
|
|
In this article, learn about all the functions available in Microsoft Dataverse.
Abs – Absolute value of a number.
And – Boolean logic AND. Returns true if all arguments are true. You can also use the && operator.
Average – Calculates the average of a table expression or a set of arguments.
Blank – Returns a blank value that can be used to insert a NULL value in a data source.
Char – Translates a character code into a string.
Collect – Creates a collection or adds data to a data source.
Concatenate – Concatenates strings.
DateAdd – Adds days, months, quarters, or years to a date/time value.
DateDiff – Subtracts two date values, and shows the result in days, months, quarters, or years.
Day – Retrieves the day portion of a date/time value.
Defaults – Returns the default values for a data source.
EndsWith – Checks whether a text string ends with another text string.
GroupBy – Returns a table with records grouped together.
Hour – Returns the hour portion of a date/time value.
If – Returns one value if a condition is true and another value if not.
IfError – Detects errors and provides an alternative value or takes action.
Int – Rounds down to the nearest integer.
IsBlank – Checks for a blank value.
IsError – Checks for an error.
ISOWeekNum – Returns the ISO week number of a date/time value.
IsUTCToday – Checks whether a date/time value is sometime today in Coordinated Universal Time (UTC).
JSON – Generates a JSON text string for a table, a record, or a value.
Lower – Converts letters in a string of text to all lowercase.
Max – Maximum value of a table expression or a set of arguments.
Mid – Returns the middle portion of a string.
Min – Minimum value of a table expression or a set of arguments.
Minute – Retrieves the minute portion of a date/time value.
Mod – Returns the remainder after a dividend is divided by a divisor.
Month – Retrieves the month portion of a date/time value.
Not – Boolean logic NOT. Returns true if its argument is false, and returns false if its argument is true. You can also use the ! operator.
Or – Boolean logic OR. Returns true if any of its arguments are true. You can also use the || operator.
PlainText – Removes HTML and XML tags from a string.
Replace – Replaces part of a string with another string, by starting position of the string.
Right – Returns the right-most portion of a string.
Round – Rounds to the closest number.
RoundDown – Rounds down to the largest previous number.
RoundUp – Rounds up to the smallest next number.
Second – Retrieves the second portion of a date/time value.
Set – Sets the value of a global variable.
StartsWith – Checks if a text string begins with another text string.
Substitute – Replaces part of a string with another string, by matching strings.
Sum – Calculates the sum of a table expression or a set of arguments.
Switch – Matches with a set of values and then evaluates a corresponding formula.
Text – Converts any value and formats a number or date/time value to a string of text.
Trim – Removes extra spaces from the ends and interior of a string of text.
Trunc – Truncates the number to only the integer portion by removing any decimal portion.
TrimEnds – Removes extra spaces from the ends of a string of text only.
Upper – Converts letters in a string of text to all uppercase.
User – Returns information about the current user.
UTCNow – Returns the current date/time value in Coordinated Universal Time (UTC).
UTCToday – Returns the current date-only value in Coordinated Universal Time (UTC).
Value – Converts a string to a number.
Validate – Checks whether the value of a single column or a complete record is valid for a data source.
ViewForm – Resets a form control for viewing of an existing item.
WeekNum – Returns the week number of a date/time value.
Year – Retrieves the year portion of a date/time value.