# Formula reference - Power Platform CLI

Use these commands to interact with data in Dataverse using a command line or script. Reduce the time and complexity of your Dataverse operations by using Power fx pac power-fx

## A

**Abs** – Absolute value of a number.

**Acos** – Returns the arccosine of a number, in radians.

**Acot** – Returns the arccotangent of a number, in radians.

**AddColumns** – Returns a table with columns added.

**And** – Boolean logic AND. Returns **true** if all arguments are **true**. You can also use the **&&** operator.

**Asin** – Returns the arcsine of a number, in radians.

**AsType** – Treats a record reference as a specific table type.

**Atan** – Returns the arctangent of a number, in radians.

**Atan2** – Returns the arctangent based on an (*x*,*y*) coordinate, in radians.

**Average** – Calculates the average of a table expression or a set of arguments.

## B

**Blank** – Returns a *blank* value that can be used to insert a NULL value in a data source.

**Boolean** – Converts a text string, number, or untyped value to a Boolean value.

## C

**Char** – Translates a character code into a string.

**Clear** – Deletes all data from a collection.

**ClearCollect** – Deletes all data from a collection and then adds a set of records.

**Coalesce** – Replaces *blank* values while leaving non-*blank* values unchanged.

**Collect** – Creates a collection or adds data to a data source.

**ColorFade** – Fades a color value.

**ColorValue** – Translates a CSS color name or a hex code to a color value.

**Column** – Retrieves column names and values from an Untyped object data type.

**ColumnNames** – Retrieves column names and values from an Untyped object data type.

**Concat** – Concatenates strings in a data source.

**Concatenate** – Concatenates strings.

**Cos** – Returns the cosine of an angle specified in radians.

**Cot** – Returns the cotangent of an angle specified in radians.

**Count** – Counts the number of records that contain a number in a single-column table.

**CountA** – Counts table records that aren't empty.

**CountIf** – Counts table records that satisfy a condition.

**CountRows** – Counts table records.

## D

**Date** – Returns a date/time value, based on **Year**, **Month**, and **Day** values.

**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.

**DateTime** – Returns a date/time value, based on both date and time components.

**DateTimeValue** – Converts a date and time string to a date/time value.

**DateValue** – Converts a date-only string to a date/time value.

**Day** – Retrieves the day portion of a date/time value.

**Dec2Hex** – Convert a number to a hexadecimal text string.

**Decimal** – Converts a string to a decimal number.

**Degrees** – Converts radians to degrees.

**Distinct** – Summarizes records of a table, removing duplicates.

**DropColumns** – Returns a table with one or more columns removed.

## E

**EDate** – Adds or subtracts months to a date, without changing the day of the month.

**EncodeHTML** – Encodes characters that need to be escaped to be used in a HTML context.

**EncodeUrl** – Encodes special characters using URL encoding.

**EndsWith** – Checks whether a text string ends with another text string.

**EOMonth** – Adds or subtracts months to a date, returning the last day of that month.

**Error** – Create a custom error or pass through an error.

**Exp** – Returns *e* raised to a power.

## F

**Filter** – Returns a filtered table based on one or more criteria.

**Find** – Checks whether one string appears within another and returns the location.

**First** – Returns the first record of a table.

**FirstN** – Returns the first set of records (N records) of a table.

**Float** – Converts a string to a floating point number.

**ForAll** – Calculates values and performs actions for all records of a table.

## G

**GUID** – Converts a GUID string to a GUID value or creates a new GUID value.

## H

**Help** – Displays help information for command line Power Fx hosts.

**Hex2Dec** – Convert a hexadecimal text string to a number.

**Hour** – Returns the hour portion of a date/time value.

## I

**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.

**Index** – Returns a record from a table based on ordered position.

**Int** – Rounds down to the nearest integer.

**IsBlank** – Checks for a blank value.

**IsBlankOrError** – Checks for a blank value or error.

**IsEmpty** – Checks for an empty table.

**IsError** – Checks for an error.

**IsMatch** – Checks a string against a pattern. Regular expressions can be used.

**IsNumeric** – Checks for a numeric value.

**IsToday** – Checks whether a date/time value is sometime today in the user's time zone.

## L

**Language** – Returns the language tag of the current user.

**Last** – Returns the last record of a table.

**LastN** – Returns the last set of records (N records) of a table.

**Left** – Returns the left-most portion of a string.

**Len** – Returns the length of a string.

**Ln** – Returns the natural log.

**Log** – Returns the logarithm in any base of a number.

**LookUp** – Looks up a single record in a table based on one or more criteria.

**Lower** – Converts letters in a string of text to all lowercase.

## M

**Match** – Extracts a substring based on a pattern. Regular expressions can be used.

**MatchAll** – Extracts multiple substrings based on a pattern. Regular expressions can be used.

**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.

## N

**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.

**Notify** – Displays a banner message to the user.

**Now** – Returns the current date/time value in the user's time zone.

## O

**Or** – Boolean logic OR. Returns **true** if any of its arguments are **true**. You can also use the **||** operator.

## P

**ParseJSON** – Converts JSON document represented as text to an Untyped object value.

**Patch** – Modifies or creates a record in a data source, or merges records outside of a data source.

**Pi** – Returns the number π.

**PlainText** – Removes HTML and XML tags from a string.

**Power** – Returns a number raised to a power. You can also use the **^** operator.

**Proper** – Converts the first letter of each word in a string to uppercase, and converts the rest to lowercase.

## R

**Radians** – Converts degrees to radians.

**Rand** – Returns a pseudo-random number between 0 and 1.

**RandBetween** – Returns a pseudo-random number between two numbers.

**Refresh** – Refreshes the records of a data source.

**Remove** – Removes one or more specific records from a data source.

**RemoveIf** – Removes records from a data source based on a condition.

**RenameColumns** – Renames columns of a table.

**Replace** – Replaces part of a string with another string, by starting position of the string.

**RGBA** – Returns a color value for a set of red, green, blue, and alpha components.

**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.

## S

**Second** – Retrieves the second portion of a date/time value.

**Sequence** – Generate a table of sequential numbers, useful when iterating with **ForAll**.

**Set** – Sets the value of a global variable.

**ShowColumns** – Returns a table with only selected columns.

**Shuffle** – Randomly reorders the records of a table.

**Sin** – Returns the sine of an angle specified in radians.

**Sort** – Returns a sorted table based on a formula.

**Split** – Splits a text string into a table of substrings.

**Sqrt** – Returns the square root of a number.

**StartsWith** – Checks if a text string begins with another text string.

**StdevP** – Returns the standard deviation of its arguments.

**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.

## T

**Table** – Creates a temporary table.

**Tan** – Returns the tangent of an angle specified in radians.

**Text** – Converts any value and formats a number or date/time value to a string of text.

**Time** – Returns a date/time value, based on **Hour**, **Minute**, and **Second** values.

**TimeValue** – Converts a time-only string to a date/time value.

**TimeZoneOffset** – Returns the difference between UTC and the user's local time in minutes.

**Today** – Returns the current date-only value.

**Trace** – Provide additional information in your test results.

**Trim** – Removes extra spaces from the ends and interior of a string of text.

**TrimEnds** – Removes extra spaces from the ends of a string of text only.

**Trunc** – Truncates the number to only the integer portion by removing any decimal portion.

## U

**UniChar** – Translates a Unicode code into a string.

**Upper** – Converts letters in a string of text to all uppercase.

## V

**Value** – Converts a string to a number.

**VarP** – Returns the variance of its arguments.

## W

**Weekday** – Retrieves the weekday portion of a date/time value.

**With** – Calculates values and performs actions for a single record, including inline records of named values.

## Y

**Year** – Retrieves the year portion of a date/time value.

## Feedback

https://aka.ms/ContentUserFeedback.

Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for