The Complete Power Apps Functions List

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/the-complete-power-apps-functions-list/. Author: Matthew Devaney.

The Complete Power Apps Functions List

Welcome to The Complete Power Apps Functions List.

On this page you will find a categorized list of 150+ Power Apps functions with links to the official documentation. Experimental functions like PDF are also included. Power Apps already has an official formulas reference so why did I do this? A few reasons:

I wanted a functions cheat sheet where I could quickly see all the functions and how to write them

Organizing all of the functions into categories makes it easier to discover new ones

Gaps in the official Power Apps documentation can be filled-in with my own commentary

I hope you enjoy the Power Apps Functions List. Download Free PDF   😺 Table of Contents AI Functions Color Functions Datasource Functions Date & Time Functions Error Functions Forms & Controls Functions Information Functions Logical Functions Math Functions Navigation Functions Offline Functions Other Functions Signals Functions Statistical Functions Table Functions Testing Functions Text Functions Trigonometry Functions Variable Functions Web Functions AI Functions AIClassify

Classifies text into a provided category text categories allowmultiplecategories AIExtract

Extracts all entities from text such as a person’s name or phone numbers text entity AIReply

Takes a message as input and drafts a reply text AISentiment

Detects positive, negative or neutral sentiment in a message text AISummarize Summarizes text source text AITranslate

Translates text from one language to another language text targetlanguage Color Functions Color

Sets a property to a built-in color value. ColorFade Fades a color value. color fade ColorValue

Translates a CSS color name or a hex code to a color value. color_text RGBA

Returns a color value for a set of red, green, blue, and alpha components. red_value green_value blue_value alpha_value Datasource Functions DataSourceInfo

Provides information about a data source source datasourceinfo_enum column_name Defaults

Returns the default values for a data source source RecordInfo

Provides information about a record of a data source record record_info_enum Refresh Refreshes the records of a data source connected_data_source Revert

Reloads and clears errors for the records of a data source source item Date & Time Functions Calendar

Retrieves information about the calendar for the current locale. Clock

Retrieves information about the clock for the current locale. Date

Returns a date/time value, based on Year, Month,and Day values. year month day DateAdd

Adds days, months, quarters, or years to a date/time value. start_date number_of_units units DateDiff

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

Converts a date and time string to a date/time value. time_text language_code DateValue

Converts a date-only string to a date/time value. date_text language_code Day

Retrieves the day portion of a date/time value. date EDate

Adds a given number of months to a date. date months EOMonth

Returns the last day of the month for a given date. date months Hour

Returns the hour portion of a date/time value. date_time ISOWeekNum

Returns the ISO week number of a date/time value. date Minute

Retrieves the minute portion of a date/time value. date_time Month

Retrieves the month portion of a date/time value. date Now Returns the current date/time value. Second

Retrieves the second portion of a date/time value. date_time Time

Returns a date/time value, based on Hour, Minute,and Second values. hour minute second TimeValue

Converts a time-only string to a date/time value. time_text language_code TimeZoneOffset

Returns the difference between UTC and the user’s local time in minutes. date Today Returns the current date value. UTCNow

Returns the current timezone independent date/time value UTCToday

Returns the current timezone independent date value Weekday

Retrieves the weekday portion of a date/time value. date WeekNum

Returns the week number of a date/time value. date Year

Retrieves the year portion of a date/time value. date Error Functions Errors

Provides error information for previous changes to a data source source Error

A record containing the custom values for the produced error. error_information IfError

Detects errors and provides an alternative value or takes action value1 replacement1 value2 replacement2 … default_result Forms & Controls Functions EditForm

Resets a form control for editing of an item. form NewForm

Resets a form control for creation of an item. form Reset

Resets an input control to its default value, discarding any user changes. control ResetForm

Resets a form control for editing of an existing item. form Select

Simulates a select action on a control, causing the OnSelect formula to be evaluated. control row_or_column child_control SetFocus

Moves input focus to a specific control. control SubmitForm

Saves the item in a form control to the data source. form ViewForm

Resets a form control for viewing of an existing item. form Information Functions IsBlank Checks for a blank value expression IsBlankOrError Checks for a blank value or error expression IsEmpty Checks for an empty table source IsError Checks for an error value IsMatch

Checks a string against a pattern. Regular expressions can be used text format extent IsNumeric Checks for a numeric value value IsToday

Checks whether a date/time value is sometime today date IsUTCToday

Checks whether a timezone independent date/time value is today IsType

Checks whether a record reference refers to a specific table type value typeTable Logical Functions If

Returns one value if a condition is true and another value if not. logical_test1 true_value1 logical_test2 true_value2 … elsevalue And

Boolean logic AND. Returns true if all arguments are true. You can also use the && operator. logical1 logical2 logical3 … EndsWith

Checks whether a text string ends with another text string. text end Match

Extracts a substring based on a pattern. Regular expressions can be used. text regular_expression options MatchAll

Extracts multiple substrings based on a pattern. Regular expressions can be used. text regular_expression options 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. logical Or

Boolean logic OR. Returns true if any of its arguments are true. You can also use the || operator. logical_test1 true_value1 logical_test2 true_value2 … elsevalue StartsWith

Checks if a text string begins with another text string. text start Switch

Matches with a set of values and then evaluates a corresponding formula. switch_value match_value1 match_result1 match_value2 match_result2 … default_result Math Functions Abs Absolute value of a number number Exp Constant e raised to a power number Dec2Hex

Converts a decimal number to a hexadecimal value number places Hex2Dec

Converts a hexadecimal value to a decimal number number Int Rounds down to the nearest integer number Ln Returns the natural log number Log

Returns the logarithm of a number for the given base. The default base is 10. number Mod

Remainder after a number is divided by a divisor number divisor Pi Returns the number π Power

Number raised to a power. You can also use the ^ operator base exponent Rand Returns a pseudo-random number RandBetween

Returns a random number between bottom and top, evenly distributed bottom top Round Rounds a number to the closest number number num_digits RoundDown

Rounds down to the largest previous number. number num_digits RoundUp Rounds up to the smallest next number. number num_digits Sqrt Returns the square root of a number number Sum

Calculates the sum of a table expression source expression Trunc

Truncates the number to only the integer portion by removing anydecimal portion number num_digits Navigation Functions Back Displays the previous screen. transition Exit

Exits the currently running app and optionally signs out the current user. logout Navigate Changes which screen is displayed. target transition context RequestHide Hides a SharePoint form. Offline Functions ClearData

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

Loads a collection from an app host such as a local device. collection name ignore_non_existent_file SaveData

Saves a collection to an app host such as a local device. collection name ShowHostInfo

Displays information about the app user in a pop-up notification host_info Other Functions AsType

Treats a record reference as a specific table type. value typeTable Blank

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

Replaces blank values while leaving non-blank values unchanged. value1 value2 … Concurrent

Evaluates multiple formulas concurrently with one another. formula1 formula2 formula3 … Notify Displays a banner message to the user. text notification_type timeout PDF * Export a screen or a container to a PDF target options Print

Open the web browser print dialog to print a screen or save as PDF ReadNFC

Reads a Near Field Communication (NFC) tag. Run

Starts a Power Automate Flow with the Power Apps trigger (no official documentation) parameter1 parameter2 … Signals Functions Acceleration

Reads the acceleration sensor in your device. App

Provides information about the currently running app and control over the app’s behavior. Compass Returns your compass heading. Connection

Returns information about your network connection. Disable

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

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

Returns the language tag of the current user. Location

Returns your location as a map coordinate by using the Global Positioning System (GPS) and other information. User

Returns information about the current user Statistical Functions Average

Calculates the sum of a table expression source expression Count

Counts a single column table of records that contain numbers source CountA

Counts a single column table of records that aren’t empty source CountIf

Counts table records that satisfy a condition source condition1 … CountRows Counts table records source Max Maximum value of a set of numbers source expression Min Minimum value of a set of numbers source expression StdevP

Standard deviation of a table of a table expression source expression VarP Returns the variance of its arguments source expression Table Functions AddColumns Returns a table with columns added. source column1 expression1 column2 expression2 … Choices

Returns a table of the possible values for a lookup column. column searchtext Clear Deletes all data from a collection. collection ClearCollect

Deletes all data from a collection and then adds a set of records. collection item1 item2 … Collect

Creates a collection or adds data to a data source. collection item1 item2 … Distinct

Summarizes records of a table, removing duplicates. source expression DropColumns

Returns a table with one or more columns removed. source column_name1 column_name2 … Filter

Returns a filtered table based on one or more criteria. source logical_test1 logical_test2 … First Returns the first record of a table. source FirstN

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

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

Returns a table with records grouped together. source column_name1 column_name2 … group_name Index

Returns a row from a table at the specified row number table index JSON

Generates a JSON text string for a table, a record, or a value. data format Last Returns the last record of a table. source LastN

Returns the last set of records (N records) of a table. source count LookUp

Looks up a single record in a table based on one or more criteria. source condition result Patch

Modifies or creates a record in a data source, or merges records outside of a data source. source record update1 update2 … Relate

Relates records of two tables through a one-to-many or many-to-many relationship. Entity1RelatedTable Entity2Record Remove

Removes one or more specific records from a data source. collection item1 item2 … RemoveIf

Removes records from a data source based on a condition. collection condition1 condition2 condition3 … RenameColumns Renames columns of a table. source old_column1 new_column1 old_column2 new_column2 … Search

Finds records in a table that contain a string in one of their columns. source text column1 column2 … Sequence

Generate a table of sequential numbers, useful when iterating with ForAll. records start step ShowColumns

Returns a table with only selected columns. source column_name1 column_name2 … Shuffle

Randomly reorders the records of a table. source Sort

Returns a sorted table based on a formula. source expression order SortByColumns

Returns a sorted table based on one or more columns. source column1 order1 column2 order2 … Table Creates a temporary table. record1 record2 record3 Ungroup Removes a grouping. source group_name Unrelate

Unrelates records of two tables from a one-to-many or many-to-many relationship. Entity1RelatedTable Entity2Record Update Replaces a record in a data source. collection old new all UpdateIf

Modifies a set of records in a data source based on a condition. collection condition1 item1 condition2 item2 … Testing Functions Assert Evaluates to true or false in a test. expression SetProperty

Simulates interactions with input controls. control_property value Trace

Provide additional information in your test results. message severity custom_record trace_options Text Functions Boolean Converts text to a true or false value text Char

Translates an ASCII character code into a string. number Concat Joins text strings from a data source. table expression separator Concatenate Joins text strings text1 text2 … Copy

Takes a text value and copies it to the clipboard text Decimal Converts a string to a decimal number value language Find

Checks whether one string appears within another and returns thelocation. find_text within_text start_num Float Converts a string to a float number value language GUID

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

Returns the left-most portion of a string. text num_chars Len Returns the length of a string. text Lower

Converts letters in a string of text to all lowercase. text Mid Returns the middle portion of a string. text start_number num_chars ParseJSON

Interprets a JSON string and returns an untyped object input Proper

Converts the first letter of each word in a string to uppercase, andconverts the rest to lowercase. text Replace

Replaces part of a string with another string, by starting position ofthe string. old_text start_num num_chars new_text Right

Returns the right-most portion of a string. text num_chars Split

Splits a text string into a table of substrings. text separator Substitute

Replaces part of a string with another string, by matching strings. text old_text new_text instance_number Text

Converts any value and formats a number or date/time value to a stringof text. value format_text language Trim

Removes extra spaces from the ends and interior of a string of text. text TrimEnds

Removes extra spaces from the ends of a string of text only. text UniChar

Translates a Unicode character code into a string. number Upper

Converts letters in a string of text to all uppercase. text Value Converts a string to a number. value language Trigonometry Functions Acos

Returns the arccosine of a number, in radians. number Acot

Returns the arccotangent of a number, in radians. number Asin

Returns the arcsine of a number, in radians. number Atan

Returns the arctangent of a number, in radians. number Atan2

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

Returns the cosine of an angle specified in radians. number Cot

Returns the cotangent of an angle specified in radians. number Degrees Converts radians to degrees. number Radians Converts degrees to radians. number Sin

Returns the sine of an angle specified in radians. number Tan

Returns the tangent of an angle specified in radians. number Variable Functions Set Sets the value of a global variable. variable value UpdateContext

Sets the value of one or more context variables of the current screen. context With

Calculates values and performs actions for a single record, including inline records of named values. scope formula Web Functions Download

Downloads a file from the web to the local device. address EncodeUrl

Encodes special characters using URL encoding. text HashTags

Extracts the hashtags (#strings) from a string. text Launch Launches a webpage or a canvas app. address parameter_name1 parameter_value1 parameter_name2 parameter_value2 target Param

Access parameters passed to a canvas app when launched. name PlainText

Removes HTML and XML tags from a string. text

* Experimental functions must be enabled in the Power Apps upcoming features menu Did You Enjoy This Article? 😺

Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up Questions?

If you have any questions about The Complete Power Apps Functions List please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion.