Power Apps Functions List.

Reference 1Reference 2 (Microsoft Official)
Table Of Contents:•  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

Color Functions

Color	Sets a property to a built-in color value.
ColorFade	Fades a color value.	colorfade
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_valuegreen_valueblue_valuealpha_value

Datasource Functions

DataSourceInfo	Provides information about a data source	sourcedatasourceinfo_enumcolumn_name
Defaults	Returns the default values for a data source	source
RecordInfo	Provides information about a record of a data source	recordrecord_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	sourceitem

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.	yearmonthday
DateAdd	Adds days, months, quarters, or years to a date/time value.	start_datenumber_of_unitsunits
DateDiff	Subtracts two date values, and shows the result in days, months,quarters, or years.	start_dateend_dateunits
DateTimeValue	Converts a date and time string to a date/time value.	time_textlanguage_code
DateValue	Converts a date-only string to a date/time value.	date_textlanguage_code
Day	Retrieves the day portion of a date/time value.	date
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.	hourminutesecond
TimeValue	Converts a time-only string to a date/time value.	time_textlanguage_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	value1replacement1value2replacement2…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.	controlrow_or_columnchild_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	textformatextent
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	valuetypeTable

Logical Functions

If	Returns one value if a condition is true and another value if not.	logical_test1true_value1logical_test2true_value2…elsevalue
And	Boolean logic AND. Returns true if all arguments are true. You can also use the && operator.	logical1logical2logical3…
EndsWith	Checks whether a text string ends with another text string.	textend
Match	Extracts a substring based on a pattern. Regular expressions can be used.	textregular_expressionoptions
MatchAll	Extracts multiple substrings based on a pattern. Regular expressions can be used.	textregular_expressionoptions
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_test1true_value1logical_test2true_value2…elsevalue
StartsWith	Checks if a text string begins with another text string.	textstart
Switch	Matches with a set of values and then evaluates a corresponding formula.	switch_valuematch_value1match_result1match_value2match_result2…default_result

Math Functions

Abs	Absolute value of a number	number
Exp	Constant e raised to a power	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	numberdivisor
Pi	Returns the number π
Power	Number raised to a power. You can also use the ^ operator	baseexponent
Rand	Returns a pseudo-random number
RandBetween	Returns a random number between bottom and top, evenly distributed	bottomtop
Round	Rounds a number to the closest number	numbernum_digits
RoundDown	Rounds down to the largest previous number.	numbernum_digits
RoundUp	Rounds up to the smallest next number.	numbernum_digits
Sqrt	Returns the square root of a number	number
Sum	Calculates the sum of a table expression	sourceexpression
Trunc	Truncates the number to only the integer portion by removing anydecimal portion	numbernum_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.	targettransitioncontext
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.	collectionnameignore_non_existent_file
SaveData	Saves a collection to an app host such as a local device.	collectionname

Other Functions

AsType	Treats a record reference as a specific table type.	valuetypeTable
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.	value1value2…
Concurrent	Evaluates multiple formulas concurrently with one another.	formula1formula2formula3…
Notify	Displays a banner message to the user.	textnotification_typetimeout
PDF*	Export a screen or a container to a PDF	targetoptions
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)	parameter1parameter2…

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	sourceexpression
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	sourcecondition1…
CountRows	Counts table records	source
Max	Maximum value of a set of numbers	sourceexpression
Min	Minimum value of a set of numbers	sourceexpression
StdevP	Standard deviation of a table of a table expression	sourceexpression
VarP	Returns the variance of its arguments	sourceexpression

Table Functions

AddColumns	Returns a table with columns added.	sourcecolumn1expression1column2expression2…
Choices	Returns a table of the possible values for a lookup column.	columnsearchtext
Clear	Deletes all data from a collection.	collection
ClearCollect	Deletes all data from a collection and then adds a set of records.	collectionitem1item2…
Collect	Creates a collection or adds data to a data source.	collectionitem1item2…
Distinct	Summarizes records of a table, removing duplicates.	sourceexpression
DropColumns	Returns a table with one or more columns removed.	sourcecolumn_name1column_name2…
Filter	Returns a filtered table based on one or more criteria.	sourcelogical_test1logical_test2…
First	Returns the first record of a table.	source
FirstN	Returns the first set of records (N records) of a table.	sourcecount
ForAll	Calculates values and performs actions for all records of a table.	sourcecount
GroupBy	Returns a table with records grouped together.	sourcecolumn_name1column_name2…group_name
Index	Returns a row from a table at the specified row number	tableindex
JSON	Generates a JSON text string for a table, a record, or a value.	dataformat
Last	Returns the last record of a table.	source
LastN	Returns the last set of records (N records) of a table.	sourcecount
LookUp	Looks up a single record in a table based on one or more criteria.	sourceconditionresult
Patch	Modifies or creates a record in a data source, or merges records outside of a data source.	sourcerecordupdate1update2…
Relate	Relates records of two tables through a one-to-many or many-to-many relationship.	Entity1RelatedTableEntity2Record
Remove	Removes one or more specific records from a data source.	collectionitem1item2…
RemoveIf	Removes records from a data source based on a condition.	collectioncondition1condition1condition2…
RenameColumns	Renames columns of a table.	sourceold_column1new_column1old_column2new_column2…
Search	Finds records in a table that contain a string in one of their columns.	sourcetextcolumn1column2…
Sequence	Generate a table of sequential numbers, useful when iterating with ForAll.	recordsstartstep
ShowColumns	Returns a table with only selected columns.	sourcecolumn_name1column_name2…
Shuffle	Randomly reorders the records of a table.	source
Sort	Returns a sorted table based on a formula.	sourceexpressionorder
SortByColumns	Returns a sorted table based on one or more columns.	sourcecolumn1order1column2order2…
Table	Creates a temporary table.	record1record2record3
Ungroup	Removes a grouping.	sourcegroup_name
Unrelate	Unrelates records of two tables from a one-to-many or many-to-many relationship.	Entity1RelatedTableEntity2Record
Update	Replaces a record in a data source.	collectionoldnewall
UpdateIf	Modifies a set of records in a data source based on a condition.	collectioncondition1item1condition2item2…

Testing Functions

Assert	Evaluates to true or false in a test.	expression
SetProperty	Simulates interactions with input controls.	control_propertyvalue
Trace	Provide additional information in your test results.	messagecondition1item1condition2

Text Functions

Boolean	Converts text to a true or false value	text
Char	Translates a character code into a string.	number
Concat	Joins text strings from a data source.	tableexpressionseparator
Concatenate	Joins text strings	text1text2…
Find	Checks whether one string appears within another and returns thelocation.	find_textwithin_textstart_num
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.	textnum_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.	textstart_numbernum_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_textstart_numnum_charsnew_text
Right	Returns the right-most portion of a string.	textnum_chars
Split	Splits a text string into a table of substrings.	textseparator
Substitute	Replaces part of a string with another string, by matching strings.	textold_textnew_textinstance_number
Text	Converts any value and formats a number or date/time value to a stringof text.	valueformat_textlanguage
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
Upper	Converts letters in a string of text to all uppercase.	text
Value	Converts a string to a number.	valuelanguage

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_coordinatey_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.	variablevalue
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.	scopeformula

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