September 25, 2022

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.
Experience
I’ll include all my experiences (good and bad) working with the functions.
For eveyone
I want people to use it and share it. So I won’t put any restriction on it on this reference.
By everyone
Please contribute! The better I can make it, the better it will be for everyone.
Lots of places
I learn from lots of places, so some things may be found elsewhere.

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

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