Power App: Count Function
by 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 …
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.
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 …
Power Apps: 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, …
Power Apps: 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 …