An ever-growing Power Apps Functions
My way of explaining each function with as much detail as I can. You'll find suggestions, best practices, things to avoid, and limitations.
Last updated
I'll include all my experiences (good and bad) working with the functions.
I want people to use it and share it. So I won't put any restriction on it on this reference.
Please contribute! The better I can make it, the better it will be for everyone.
I learn from lots of places, so some things may be found elsewhere.
Data Conversion (1)
Go to topData Generator (2)
Go to topData Selection (3)
Go to topDate (2)
Go to topDate Manipulation (2)
Go to topDate Operator (1)
Go to topLogical Operator (2)
Go to topMath (5)
Mod
Returns the remainder of a division.
ViewRound
Rounds a number to a given decimal place using half-round-up.
ViewRoundDown
Rounds a number down to the next lower decimal place.
ViewRoundUp
Rounds a number up to the next higher decimal place.
ViewToday
Returns today's date with time set to midnight. Volatile.
ViewString (5)
Color
Returns a named color value like Color.Burlywood instead of an RGBA code.
ViewCount
Returns the number of rows in a single-column table.
ViewFilter
Returns rows from a collection that match a condition. Supports AND/OR.
ViewLen
Returns the number of characters in a string.
ViewTrimEnds
Removes leading and trailing spaces. Inner spaces stay intact.
View