An ever-growing Power Apps Function Reference
My way of explaining each function with as much detail as I can. You’ll find suggestions, best practices, things to avoid, and limitations.
Here are the sections where you can find articles. There are more in Microsoft’s reference, but I only include the ones I wrote about in the past.
- Data Conversion
- Data Generator
- Data Selection
- Date
- Date Manipulation
- Date Operator
- Logical Operator
- Math
- String
- String Manipulation
- Table Manipulation
Data Conversion
TEXT function
The Text function is widely used in PowerApps and for a good reason. It converts any value to a text field to display. For numbers …Full Reference
Data Generator
CHOICES function
The choices function returns a table of elements that we can choose from. Note the return “table,” meaning that we can use other functions like …Full Reference
GUID function
GUID stands for Global Unique IDentifier, and it’s a market standard that is represented by “xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx “. Alternatively, since the structure is always the same, …Full Reference
Data Selection
IF function
“If” is one of the most used functions in any programming language and PowerApps is not the exception. The If function tests if the first condition is met …Full Reference
STARTSWITH function
The StartsWith is a handy function that allows you to check if a text string starts with another. Usage It follows a simple pattern. Text …Full Reference
SWITCH function
The Switch function evaluates a formula and tries to find it in the list of matches defined. It stops in the first match that validates …Full Reference
Date
WEEKNUM function
The week number is a function that represents the week’s count starting on the 1st of January. So the week that contains the first day …Full Reference
NOW function
The Power Apps Now function will return the current moment’s date, including the time. Power Apps converts the value automatically to the user’s regional settings when …Full Reference
Date Manipulation
DATEADD function
Dealing with dates is a standard action, especially when it comes to user-facing applications. Today we’ll focus on the DateAdd function and how we can …Full Reference
DATETIMEVALUE function
Converting dates is challenging and having a function that does that for us is pretty amazing. The DateTimeValue function does that for us. It converts …Full Reference
Date Operator
DATEDIFF function
The DateDiff function returns the difference between 2 dates in the specified unit. DateDiff function defaults to Days, but you can choose between Milliseconds, Seconds, Minutes, Hours, …Full Reference
Logical Operator
ISOWEEKNUM function
Week numbers are useful but not for everyone, I reckon. They represent the number of the week of the year starting at the beginning of …Full Reference
ISTODAY function
IsToday function is what I can a “nice to have” function, and I’m happy it exists. Although you could do the math yourself, having a …Full Reference
Math
MOD function
The Mod function is a mathematical function that calculates the remainder of a number divided by a divisor. It may not be apparent its usage, …Full Reference
ROUND function
The Round function performs the mathematical round of a number to a specific number of decimal places. It uses the rules defined “Half Round-Up” where it rounds …Full Reference
ROUNDDOWN function
The RoundDown function rounds a number to a specific number of decimal places, always to the nearest lower number. The round is still down regardless of …Full Reference
ROUNDUP function
The RoundUp function rounds a number to a specific number of decimal places, always to the nearest higher number. The round is still up regardless of …Full Reference
TODAY function
The Power Apps Today function will return the date for the current day with the time as 00:00:00. Power Apps converts the value automatically to the …Full Reference
String
COLOR function
Color makes everything better, and it’s an amazing way to help highlight elements, make the UI easier to use and read, and much more. The …Full Reference
COUNT function
There are several count functions in Power Apps, and all of them draw inspiration from Excel. I will detail them all in this reference but, if …Full Reference
LEN function
The Len function is highly versatile and super useful. It is also a function used in all programming languages that I know since it serves …Full Reference
FILTER function
The filter function searches in a collection for one or more conditions and removes all items that don’t fit that condition. Usage It follows a …Full Reference
TRIMENDS function
The TrimEnds function is one handy function that is often confused by the Trim function since it works closer to the way developers are used …Full Reference
String Manipulation
CONCAT function
It’s funny that there are two functions to perform concatenation of “stuff.” Some people get confused when thinking about using one or the other, but …Full Reference
CONCATENATE function
Every programming language has a variation of the “concatenate function,” but I like a lot the Power App’s implementation of it. Concatenation means creating a …Full Reference
TRIM function
The Trim function is one handy function that most don’t understand the proper usage since it only serves one purpose. It is removing spaces. It …Full Reference
Table Manipulation
SORTBYCOLUMNS function
Sorting is essential for any app’s good navigation, but most of the time, we want to define a column to be the “default” sorting column. …Full Reference
TABLE function
Not all data lives in data sources and, once in a while; it’s useful to generate a table of objects that lives in your App. …Full Reference