1️⃣ With() — Cleaner, More Maintainable Logic

👉 Instead of repeating the same calculation multiple times, With() lets you define it once and reuse it.

Example

With(
    { totalCost: Quantity * Price },
    If(totalCost > 1000, totalCost * 0.9, totalCost)
)

💡 Use case:
Reducing repeated formulas inside nested If()

✅ Makes your app easier to read, debug, and maintain

2️⃣ Concurrent() — Boost App Performance

👉 Runs multiple operations at the same time instead of sequentially.

Example

Concurrent(
    ClearCollect(colUsers, UsersList),
    ClearCollect(colRoles, RolesList),
    ClearCollect(colDepartments, DepartmentsList)
)

💡 Use case:
Improving screen load time

✅ Huge performance improvement in data-heavy apps

3️⃣ JSON() — Bridge Between Power Apps & APIs/Flows

👉 Converts data into JSON format for passing to Power Automate or external APIs.

Example

Set(
    varPayload,
    JSON(colRepeatingData, JSONFormat.IncludeBinaryData)
)

💡 Use case:
Sending complex data like repeating sections to flows or external systems

✅ Very helpful for integrations

4️⃣ Office365Users Connector — Dynamic User Data

👉 Fetch user details directly from Microsoft 365.

Example

Office365Users.Manager(User().Email).DisplayName

💡 Use case:
Auto-fetch manager for approval workflows and org-based routing

✅ Great for people-based business apps

5️⃣ ParseJSON() — Handle Dynamic or Unstructured Data

👉 Converts JSON back into usable Power Apps data.

Example

Set(varData, ParseJSON(varResponse));
Text(varData.name)

💡 Use case:
Reading custom API responses or flow outputs

✅ Powerful when working with dynamic payloads

6️⃣ Patch() — Update or Create Records

👉 One of the most important functions for writing data.

Example

Patch(
    Requests,
    Defaults(Requests),
    {
        Title: txtTitle.Text,
        Status: "Submitted"
    }
)

💡 Use case:
Creating or updating SharePoint, Dataverse, or SQL records

✅ More flexible than SubmitForm()

7️⃣ SubmitForm() — Fast Form Submission

👉 Best when using an Edit Form control.

Example

SubmitForm(frmRequest)

💡 Use case:
Simple create/edit screens

✅ Easy validation and built-in form behavior

8️⃣ Defaults() — Create New Records Properly

👉 Used with Patch() to create a new item.

Example

Patch(Tasks, Defaults(Tasks), { Title: "New Task" })

💡 Use case:
Inserting new rows into a data source

✅ Essential for create operations

9️⃣ LookUp() — Find a Single Matching Record

👉 Pull one specific record based on a condition.

Example

LookUp(Employees, Email = User().Email)

💡 Use case:
Finding the current user’s profile or a related record

✅ One of the most-used lookup functions

🔟 Filter() — Return Multiple Matching Records

👉 Pull a table of records that match criteria.

Example

Filter(Requests, Status = "Open")

💡 Use case:
Gallery filtering and dynamic data views

✅ Core function for real-world apps

11️⃣ Search() — User-Friendly Text Search

👉 Lets users search records by keyword.

Example

Search(Employees, txtSearch.Text, FullName, Department)

💡 Use case:
Search boxes in galleries

✅ Great for user experience

12️⃣ Sort() — Basic Sorting

👉 Sort records ascending or descending.

Example

Sort(Tasks, Created, Descending)

💡 Use case:
Newest-first or alphabetic lists

✅ Keeps data organized

13️⃣ SortByColumns() — Advanced Sorting

👉 Better when sorting by named column strings.

Example

SortByColumns(Requests, "Priority", Descending)

💡 Use case:
Dynamic sort logic and reusable components

✅ Often cleaner than Sort()

14️⃣ AddColumns() — Add Calculated Columns to Data

👉 Enrich records without changing the source.

Example

AddColumns(Projects, "OpenTaskCount", CountRows(Filter(Tasks, ProjectId = ID)))

💡 Use case:
Displaying calculated values in galleries

✅ Very useful for dashboard-style apps

15️⃣ ShowColumns() — Keep Only Needed Columns

👉 Return a lighter version of your table.

Example

ShowColumns(Employees, "FullName", "Email")

💡 Use case:
Reducing payload and shaping data for collections

✅ Helpful for performance and clarity

16️⃣ DropColumns() — Remove Unneeded Columns

👉 Strip away fields you do not need.

Example

DropColumns(Employees, "Modified", "Editor")

💡 Use case:
Preparing leaner collections

✅ Good for cleanup before export or processing

17️⃣ RenameColumns() — Make Data Easier to Read

👉 Rename columns for cleaner app logic.

Example

RenameColumns(Employees, "displayName", "FullName")

💡 Use case:
Standardizing inconsistent source column names

✅ Makes formulas easier to understand

18️⃣ ClearCollect() — Reset and Reload a Collection

👉 Clears a collection, then fills it again.

Example

ClearCollect(colProjects, Projects)

💡 Use case:
Caching data on screen load

✅ Very common in production apps

19️⃣ Collect() — Add Items to a Collection

👉 Appends records to a collection.

Example

Collect(colCart, { Product: "Laptop", Qty: 1 })

💡 Use case:
Temporary carts, staged entries, multi-row forms

✅ Great for in-app temporary storage

20️⃣ Clear() — Empty a Collection

👉 Removes all items from a collection.

Example

Clear(colCart)

💡 Use case:
Resetting temporary data

✅ Simple but essential

21️⃣ UpdateIf() — Bulk Update Matching Records

👉 Updates every matching record in a source.

Example

UpdateIf(Tasks, Status = "Draft", { Status: "Submitted" })

💡 Use case:
Mass-updating a set of records

✅ Faster than patching one by one in many cases

22️⃣ RemoveIf() — Delete Matching Records

👉 Deletes records that meet a condition.

Example

RemoveIf(colTempRows, IsBlank(Title))

💡 Use case:
Cleaning incomplete temp data

✅ Handy in repeating section scenarios

23️⃣ ForAll() — Process Records One by One

👉 Loops through a table and performs logic.

Example

ForAll(
    colItems,
    Patch(Orders, Defaults(Orders), { Title: ThisRecord.Title })
)

💡 Use case:
Saving repeating rows or running batch actions

✅ Extremely useful, but use carefully for performance

24️⃣ Sequence() — Generate Numbered Rows

👉 Creates a numbered table automatically.

Example

Sequence(10)

💡 Use case:
Building temporary rows, pagination, row numbering

✅ Great helper function

25️⃣ CountRows() — Count Records Fast

👉 Returns the number of rows in a table.

Example

CountRows(colCart)

💡 Use case:
Badge counts, validation, summaries

✅ Simple and practical

26️⃣ Sum() — Total Numeric Values

👉 Adds values across records.

Example

Sum(colCart, Qty * Price)

💡 Use case:
Total cost, total hours, total quantity

✅ Essential for calculations

27️⃣ GroupBy() — Group Related Records

👉 Groups records into nested tables.

Example

GroupBy(Tasks, Department, GroupedTasks)

💡 Use case:
Building grouped dashboards and summaries

✅ Powerful for analytics-style screens

28️⃣ Ungroup() — Flatten Grouped Data

👉 Turns grouped data back into a normal table.

Example

Ungroup(colGroupedData, GroupedTasks)

💡 Use case:
Reversing GroupBy() results

✅ Useful in more advanced shaping

29️⃣ Distinct() — Get Unique Values

👉 Returns unique values from a column.

Example

Distinct(Employees, Department)

💡 Use case:
Dropdown filters and unique lists

✅ Very common in filter panels

30️⃣ IsBlank() — Check for Empty Values

👉 Helps validate missing input.

Example

If(IsBlank(txtEmail.Text), Notify("Email is required"))

💡 Use case:
Required field checks

✅ Basic but critical

31️⃣ Coalesce() — Return First Non-Blank Value

👉 Great for fallback logic.

Example

Coalesce(txtPhone.Text, txtMobile.Text, "No number")

💡 Use case:
Default values and null-safe formulas

✅ Cleaner than nested If(IsBlank())

32️⃣ IfError() — Safer Error Handling

👉 Capture and respond to failures gracefully.

Example

IfError(
    Patch(Requests, Defaults(Requests), { Title: txtTitle.Text }),
    Notify("Save failed", NotificationType.Error)
)

💡 Use case:
Protecting save logic

✅ Makes apps more professional

33️⃣ Notify() — User-Friendly Messages

👉 Show success, warning, or error messages.

Example

Notify("Request submitted successfully", NotificationType.Success)

💡 Use case:
Feedback after save, delete, or validation

✅ Essential for usability

34️⃣ Navigate() — Move Between Screens

👉 Sends users to another screen.

Example

Navigate(scrDetails, ScreenTransition.Fade)

💡 Use case:
Multi-screen apps

✅ Core navigation pattern

35️⃣ Set() — Create Global Variables

👉 Store values across screens.

Example

Set(varCurrentUser, User().FullName)

💡 Use case:
Global app state, selected IDs, mode flags

✅ Great for app-wide values

36️⃣ UpdateContext() — Screen-Level Variables

👉 Store values only for the current screen.

Example

UpdateContext({ showPopup: true })

💡 Use case:
Modals, toggles, screen UI behavior

✅ Cleaner for local state

37️⃣ Param() — Read URL Parameters

👉 Pull values passed into the app URL.

Example

Param("RequestID")

💡 Use case:
Deep linking from email, SharePoint, or Teams

✅ Great for launch scenarios

38️⃣ User() — Get Current User Information

👉 Returns current signed-in user details.

Example

User().Email

💡 Use case:
Security filters, personalization, defaults

✅ Used everywhere in enterprise apps

39️⃣ Today() — Get Today’s Date

👉 Returns current date only.

Example

Today()

💡 Use case:
Due dates, date filters, default values

✅ Simple and useful

40️⃣ Now() — Current Date and Time

👉 Returns the exact current timestamp.

Example

Now()

💡 Use case:
Audit timestamps, expiry logic, time tracking

✅ Useful for more precise workflows

41️⃣ DateAdd() — Add Days, Months, or Years

👉 Adjust a date dynamically.

Example

DateAdd(Today(), 7, Days)

💡 Use case:
Due dates and reminders

✅ Common in business apps

42️⃣ DateDiff() — Calculate Time Between Dates

👉 Compare two dates.

Example

DateDiff(StartDate, EndDate, Days)

💡 Use case:
SLA tracking, duration, aging reports

✅ Very practical

43️⃣ Text() — Format Values for Display

👉 Converts numbers and dates into readable text.

Example

Text(Today(), "[$-en-US]mmmm dd, yyyy")

💡 Use case:
Friendly labels, display formatting

✅ Important for polished apps

44️⃣ Value() — Convert Text to Number

👉 Turns numeric text into a real number.

Example

Value(txtAmount.Text)

💡 Use case:
Math on input fields

✅ Prevents calculation issues

45️⃣ Switch() — Cleaner Multi-Option Logic

👉 Better than stacked If() when checking many values.

Example

Switch(
    drpStatus.Selected.Value,
    "New", Color.Blue,
    "In Progress", Color.Orange,
    "Closed", Color.Green,
    Color.Gray
)

💡 Use case:
Status-based display logic

✅ Much easier to read than long nested If()

46️⃣ Choices() — Pull Choice or Lookup Options

👉 Retrieves available values from a choice or lookup column.

Example

Choices(Requests.Status)

💡 Use case:
Populating dropdowns and combo boxes

✅ Common with SharePoint and Dataverse

47️⃣ Refresh() — Reload a Data Source

👉 Pull the latest data from the source.

Example

Refresh(Requests)

💡 Use case:
After save, delete, or approval actions

✅ Keeps data current

48️⃣ Launch() — Open Links, Files, or Emails

👉 Opens a webpage, SharePoint item, Teams link, or email.

Example

Launch("https://contoso.sharepoint.com")

💡 Use case:
Open documents, send mail, jump to external systems

✅ Very useful for connected business apps

49️⃣ Power Automate Connector — Extend Beyond Power Apps

👉 Call flows directly from your app.

Example

MyFlow.Run(txtTitle.Text, User().Email)

💡 Use case:
Approvals, PDF generation, email notifications, complex automation

✅ A must-have in enterprise solutions

5️⃣0️⃣ Form Modes — NewForm(), EditForm(), ViewForm()

👉 Control how forms behave.

Example

NewForm(frmRequest)
EditForm(frmRequest)
ViewForm(frmRequest)

💡 Use case:
Switching between create, edit, and read-only modes

✅ Core pattern for structured app experiences