Power Apps: Filter Function
by 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 …
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: 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 …
PowerApps: 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 …
PowerApps: 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 …