Power Apps Functions
My way of explaining each entry 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 them.
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)
Choices
Returns the selectable values for a SharePoint or Dataverse choice column.
ViewGUID
Generates a GUID, or converts a string into a GUID.
ViewData Selection (4)
EndsWith
Checks whether a text string ends with another. Case insensitive; empty match text returns true.
ViewIf
Tests a condition and returns one of two values.
ViewStartsWith
Checks if a text string begins with another.
ViewSwitch
Evaluates a value against multiple matches and returns the matching result.
ViewDate (2)
Now
Returns the current date and time. Volatile.
ViewWeekNum
Returns the week number for a date. Start day is configurable.
ViewDate Manipulation (2)
DateAdd
Adds or subtracts time units from a date: minutes, hours, days, months, quarters, or years.
ViewDateTimeValue
Converts a string into a date-time value.
ViewDate Operator (1)
Go to topLogical Operator (2)
ISOWeekNum
Returns the ISO week number for a date. Monday is the first day; week 1 contains the first Thursday.
ViewIsToday
Returns true when a date-time falls on today.
ViewMath (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 (6)
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.
ViewLookUp
Returns the first record that matches a condition, or a single reduced value. Blank if nothing matches.
ViewTrimEnds
Removes leading and trailing spaces. Inner spaces stay intact.
ViewString Manipulation (3)
Concat
Combines values from a table into a single string using a formula.
ViewConcatenate
Joins text strings and single-column tables into one string.
ViewTrim
Removes leading, trailing, and extra internal spaces from text.
ViewTable Manipulation (2)
SortByColumns
Sorts a table by one or more columns.
ViewTable
Creates an in-memory table with multiple columns.
View