Skip to content

AddColumns.md

Latest commit

 

History

History
113 lines (86 loc) · 2.58 KB

AddColumns.md

File metadata and controls

113 lines (86 loc) · 2.58 KB
Raw

➕ AddColumns

Category: Data Transform | Works in: Canvas Apps

Overview

Returns a copy of a table with one or more new calculated columns added, without modifying the underlying data source.

Syntax

AddColumns( Table, "ColName", Formula [, "ColName2", Formula2, ...] )

Simple Examples

1. Add a computed total column

AddColumns(OrderItems, "LineTotal", Qty * UnitPrice)

2. Add a full name column

AddColumns(Employees, "FullName", FirstName & " " & LastName)

3. Add a boolean flag

AddColumns(Tasks, "IsOverdue", DueDate < Today())

Complex Examples

4. Multi-column enrichment with cache

ClearCollect(
    varEnrichedOrders,
    AddColumns(
        Filter(Orders, Status = "Pending"),
        "CustomerName",  LookUp(Customers, ID = CustomerID).Name,
        "DaysOpen",      DateDiff(OrderDate, Today(), Days),
        "IsOverdue",     DueDate < Today(),
        "StatusBadge",   If(DueDate < Today(), "🔴 Overdue", "🟢 On Track"),
        "TaxAmount",     Round(Total * 0.18, 2)
    )
)

5. Custom sort key for priority ordering

Sort(
    AddColumns(Tasks,
        "PriorityNum", Switch(Priority, "Critical",1, "High",2, "Medium",3, 4)
    ),
    PriorityNum, SortOrder.Ascending,
    DueDate,     SortOrder.Ascending
)

6. Prepare data for ForAll bulk save

ForAll(
    AddColumns(
        Filter(varSelectedItems, IsSelected = true),
        "Status",     "Approved",
        "ApprovedBy", User().Email,
        "ApprovedOn", Now()
    ),
    Patch(Requests, LookUp(Requests, ID = ID), {
        Status:     Status,
        ApprovedBy: ApprovedBy,
        ApprovedOn: ApprovedOn
    })
)

Best Practices

  • Validate inputs before using in write operations.
  • Combine with related functions for complete workflows.
  • Test with both empty and populated data sources.
  • Consider delegation when working with large data sets.

Related Functions

Function Relationship
Filter Related function
Sort Related function
ForAll Related function
GroupBy Related function
ClearCollect Related function

🔗 Official Documentation

AddColumns, DropColumns, ShowColumns – Microsoft Learn

← Back to Home | Power Apps Formulas Reference | Last updated: May 2026