PowerApps Functions

The absolute value of a number.

Reads the acceleration sensor in your device.

Returns the arccosine of a number, in radians.

Returns the arccotangent of a number, in radians.

Returns a table with columns added.

Boolean logic AND. Returns true if all arguments are true. Same as using the && operator.

Provides information about the currently running app and control over the app’s behavior.

Returns the arcsine of a number, in radians.

Evaluates to true or false in a test.

Names the current record in a gallery, form, and record scope functions such as ForAll, With, and Sum.

Treats a record reference as a specific table type.

Tip: LIFESAVER for polymorphic table fields. Think lookup tables in Dataverse.

Returns the arctangent of a number, in radians.

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

Calculates the average of a table expression or a set of arguments.

Displays the previous screen.

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

Coverts a text string, number, or untyped value to a Boolean value.

Retrieves information about the calendar for the current locale.

Translates a character code into a string.

Returns a table of the possible values for a lookup column.

Deletes all data from a collection.

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

Clears a collection or all collections from an app host such as a local device.

Retrieves information about the clock for the current locale.

Replaces blank values while leaving non-blanks values unchanged.

Creates a collection or adds data to a data source.

Sets a property to a built-in color value.

Fades a color value.

Translate a CSS color name or a hex code to a color value.

Returns your compass heading.

Concatenates strings in a data source.

Concatenates strings.

Evaluates multiple formulas concurrently with one another.

Returns information about your network connection.

Counts table records that contain numbers.

Returns the cosine of an angle specified in radians.

Returns the cotangent of an angle specified in radians.

Counts table records that aren’t empty.

Count table records that satisfy a condition.

Counts table records.

Tip: This is a go-to for diplaying the number of records in a gallery or displaying the number of records that meets a condition such as if a status = ‘Completed’ to display some quick metrics to your app users.

Provides information about a data source.

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

Adds days, months, quarters, or years to a date/time value.

Subtracts two date values, and shows the result in days, months, quarters, or years.

Converts a date and time string to a date/time value.

Converts a date-only string to a date/time value.

Retrieves the day portion or a date/time value.

Returns the default values for a data source.

Converts radians to degrees.

Disables a signal, such as Location for reading the GPS.

Summarizes records of a table, removing duplicates.

Downloads a file from the web to the local device.

Returns a table with one or more columns removed.

Resets a form control for editing of an item.

Enables a signal, such as Location for reading the GPS.

Encodes special characters using URL encoding.

Checks whether a text string ends with another text string.

Create a custom error or pass through an error.

Provides error information for previous changes to a data source.

Checks if a text string is contained with another text string or table, case dependant. Also used to check if a record is in a table.

Exits the currently running app and optionally signs out the current user.

Returns e raised to a power.

Returns a filtered table based on one or more criteria.

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

Returns the first record of a table.

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

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

Returns a table with records grouped together.

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

Extracts the hashtags (#strings) from a string.

Return the hour portion of a date/time value.

Returns one value if a condition is true and another value if not.

Detects errors and provides an alternative value or takes action.

Checks if a text string is contained within another text string or table, case independent. Also used to check if a record is in a table.

Returns a record from a table based on ordered position.

Rounds down to the nearest integer.

Checks for a blank value.

Tip: Remember an exclamation point is the ‘not’ property in functions, for example:

textvalue1 is not blank = !IsBlank(textvalue1.text)

Checks for a blank value or error.