1. Text Functions
| Function | Description | Syntax |
|---|---|---|
| Len() | Returns the number of characters in a string. | Len("Power Apps") → 10 |
| Left() | Extracts characters from the start of a string. | Left("PowerApps", 5) → "Power" |
| Right() | Extracts characters from the end of a string. | Right("PowerApps", 4) → "Apps" |
| Mid() | Extracts a substring from the middle. | Mid("PowerApps", 2, 4) → "ower" |
| Upper() | Converts text to uppercase. | Upper("power") → "POWER" |
| Lower() | Converts text to lowercase. | Lower("POWER") → "power" |
| Trim() | Removes leading & trailing spaces. | Trim(" Power ") → "Power" |
| Substitute() | Replaces part of text with another. | Substitute("Power Apps","Apps","FX") → "Power FX" |
| Concatenate() | Joins multiple text strings. | Concatenate("Power"," ","Apps") → "Power Apps" |
| Text() | Formats numbers/dates as text. | Text(Today(),"dd-mm-yyyy") |
2. Math Functions
| Function | Description | Syntax |
|---|---|---|
| Abs() | Returns absolute value. | Abs(-5) → 5 |
| Round() | Rounds to nearest value. | Round(10.75,1) → 10.8 |
| RoundUp() | Rounds up. | RoundUp(10.25,1) → 10.3 |
| RoundDown() | Rounds down. | RoundDown(10.75,1) → 10.7 |
| Sqrt() | Square root. | Sqrt(25) → 5 |
| Rand() | Returns random number (0–1). | Rand() |
| RandBetween() | Random number between range. | RandBetween(1,100) |
3. Date & Time Functions
| Function | Description | Syntax |
|---|---|---|
| Now() | Current date & time. | Now() |
| Today() | Current date. | Today() |
| DateAdd() | Adds/subtracts days. | DateAdd(Today(),5) |
| DateDiff() | Difference between dates. | DateDiff(Today(),"2025-12-31") |
| Year() | Extracts year. | Year(Today()) |
| Month() | Extracts month. | Month(Today()) |
| Day() | Extracts day. | Day(Today()) |
| Hour() | Extracts hour. | Hour(Now()) |
| Minute() | Extracts minute. | Minute(Now()) |
4. Logical Functions
| Function | Description | Syntax |
|---|---|---|
| If() | Conditional logic. | If(Score>=50,"Pass","Fail") |
| IfError() | Handles errors. | IfError(1/0,"Error") |
| Switch() | Multiple conditions. | Switch(Color,"R","Red","G","Green") |
| IsBlank() | Checks if value is blank. | IsBlank(TextInput1.Text) |
| IsEmpty() | Checks if table/collection is empty. | IsEmpty(MyCollection) |
| Coalesce() | Returns first non-blank value. | Coalesce("", "Default") |
5. Table & Collection Functions
| Function | Description | Syntax |
|---|---|---|
| ClearCollect() | Creates/clears & loads data in collection. | ClearCollect(MyColl, {ID:1, Name:"A"}) |
| Collect() | Adds data to collection. | Collect(MyColl, {ID:2, Name:"B"}) |
| Clear() | Clears all data in collection. | Clear(MyColl) |
| Update() | Updates a record. | Update(MyColl, {ID:1}, {Name:"Updated"}) |
| Remove() | Removes record(s). | Remove(MyColl, {ID:1}) |
| Patch() | Creates/updates records in data source. | Patch(Employees, Defaults(Employees), {Name:"John"}) |
| ForAll() | Iterates over table/collection. | ForAll(MyColl, Patch(...)) |
| LookUp() | Finds first record that matches condition. | LookUp(Employees, EmpId=101, Name) |
| Filter() | Returns filtered records. | Filter(Employees, Department="IT") |
| Search() | Searches for text. | Search(Employees, "John", "Name") |
| Sort() | Sorts data. | Sort(Employees, Salary, Descending) |
| SortByColumns() | Sorts by column name. | SortByColumns(Employees, "Salary", Ascending) |
| AddColumns() | Adds calculated columns. | AddColumns(Employees,"Bonus", Salary*0.1) |
| DropColumns() | Removes columns. | DropColumns(Employees,"ManagerId") |
| RenameColumns() | Renames columns. | RenameColumns(Employees,"Name","FullName") |
| ShowColumns() | Keeps only specific columns. | ShowColumns(Employees,"Name","Salary") |
| GroupBy() | Groups records. | GroupBy(Employees,"Department","DeptGroup") |
| Ungroup() | Breaks grouped records. | Ungroup(MyGroupedData,"DeptGroup") |
| Distinct() | Returns unique values. | Distinct(Employees, Department) |
6. Record Functions
| Function | Description | Syntax |
|---|---|---|
| Defaults() | Creates a new record template. | Defaults(Employees) |
| First() | Returns first record. | First(Employees) |
| Last() | Returns last record. | Last(Employees) |
| FirstN() | Returns first N records. | FirstN(Employees, 3) |
| LastN() | Returns last N records. | LastN(Employees, 3) |
| UpdateContext() | Creates/updates local variable. | UpdateContext({varName:"Value"}) |
| Set() | Creates/updates global variable. | Set(varGlobal,"Hello") |
7. Color Functions
| Function | Description | Syntax |
|---|---|---|
| Color() | Creates a color by specifying RGBA values. | Color(255,0,0) → Red |
| RGBA() | Defines a color with Red, Green, Blue, and Alpha (0–1). | RGBA(0, 128, 0, 1) → Green |
| ColorFade() | Lightens or darkens a color. | ColorFade(Color.Red, -20%) |
| ColorValue() | Converts a color name or hex code to a color value. | ColorValue("#FF5733") or ColorValue("Blue") |
| ColorBrightness() | Adjusts brightness of a color. (Preview in some environments) | ColorBrightness(Color.Red, 0.5) |
| IsDark() | Returns true if a color is dark. (Preview) |
IsDark(ColorValue("#000000")) |
| IsLight() | Returns true if a color is light. (Preview) |
IsLight(ColorValue("#FFFFFF")) |
8. Information Functions
| Function | Description | Syntax / Example |
|---|---|---|
| IsBlank() | Checks if a value is blank. | IsBlank(TextInput1.Text) |
| IsEmpty() | Checks if a table/collection has no records. | IsEmpty(Employees) |
| IsNumeric() | Checks if a value is numeric. | IsNumeric("123") → true |
| IsToday() | Checks if a date is today. | IsToday(Today()) → true |
| IsError() | Checks if an expression results in an error. | IsError(Value("abc")) |
| IfError() | Handles and returns alternate value if error occurs. | IfError(1/0, "Error") |
| Len() | Returns the length of a string (can be used for data validation). | Len(TextInput1.Text) |
| IsMatch() | Checks if text matches a regex pattern. | IsMatch("abc123", "[a-z]+[0-9]+") |
| IsBlankOrError() | Checks if value is blank or error. | IsBlankOrError(TextInput1.Text) |
| IsToday() | Checks if a date value equals today. | IsToday(DateValue("2025-08-26")) |
9. Navigation Functions
| Function | Description | Syntax / Example |
|---|---|---|
| Navigate() | Moves the user from one screen to another. Supports transitions. | Navigate(Screen2, ScreenTransition.Fade) |
| Back() | Returns the user to the previous screen. | Back() |
| Exit() | Closes the app. | Exit() |
| Exit(Boolean) | Closes the app and optionally prompts to save data. | Exit(true) → Save changes before exit |
| Launch() | Opens a website or another app. | Launch("https://powerapps.microsoft.com") |
10. Forms and Control Functions
| Function | Description | Syntax / Example |
|---|---|---|
| SubmitForm() | Submits the form data to the data source. | SubmitForm(EditForm1) |
| ResetForm() | Resets a form to its default values. | ResetForm(EditForm1) |
| EditForm() | Sets a form control into Edit mode. | EditForm(EditForm1) |
| NewForm() | Sets a form control into New mode. | NewForm(EditForm1) |
| ViewForm() | Sets a form control into View (read-only) mode. | ViewForm(EditForm1) |
| Reset() | Resets a control to its default value. | Reset(TextInput1) |
| Refresh() | Refreshes a data source and fetches the latest records. | Refresh(Employees) |
| Recalculate() | Forces recalculation of a data source (like SharePoint/Excel). | Recalculate() |
| Validate() | Validates whether a record contains valid values before submission. | Validate(Employees, Defaults(Employees), {Name:""}) |
11. Other Functions
| Function | Description | Syntax / Example |
|---|---|---|
| Notify() | Displays a notification message to the user (info, success, warning, error). | Notify("Saved!", NotificationType.Success) |
| Print() | Prints the current screen (works in supported browsers). | Print() |
| AsType() | Converts a record to a specific data type (useful with Dataverse, Option Sets). | AsType(ThisItem, 'Employee Type') |
| Trace() | Sends debug info to Monitor tool (for troubleshooting). | Trace("Debug Message", TraceSeverity.Information) |
| Self | Refers to the current control. | Self.Text |
| Parent | Refers to the parent container/control. | Parent.Fill |
| App | Refers to the overall app object (properties like App.ActiveScreen). | App.ActiveScreen.Name |
Also Read..
