Power App: Len Function
by 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 …
Category: Power Apps Function Reference
This Power Apps function reference has two main objectives. First, to explore the fundamental concepts and understand them better. The second is to provide some feedback on how to use them efficiently.
I don’t want this Power Apps function reference to replace the excellent Microsoft reference, but I want to augment it with some information that you only find once you use the tools.
Articles will come out every Thursday, always 1 pm Lisbon Time. Since I have three platforms to explore, you can expect Power Automate, SharePoint, and Power Apps articles every three weeks. Time permitting, I’ll increase the frequency, but I think this is the right balance so that I can keep on delivering valuable information in a defined schedule.
Power App: 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. …
Power App: 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 …
Power App: 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. …
Power Apps: 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 …
Power Apps: 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 …
Power Apps: 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 …
Power Apps: 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 …
Power Apps: 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 …
Power Apps: 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 …