Power Apps: Trim Function
by 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 …
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 Friday, always 7 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 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 …
Power Apps: 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, …
Power Apps: 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 …
Power Apps: 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 …
Power Apps: 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 …
Power Apps: 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 …