Power Fx Cheat Sheet

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

If(
    DateDiff(dt, Now(), TimeUnit.Minutes) < 60,
    Text(DateDiff(dt, Now(), TimeUnit.Minutes)) & " min ago",
    Text(DateDiff(dt, Now(), TimeUnit.Hours)) & " hr ago"
)

Filter(Items, Created >= DateAdd(Today(), -30, TimeUnit.Days))

// First day
Date(Year(Today()), Month(Today()), 1)

// Last day
DateAdd(Date(Year(Today()), Month(Today()) + 1, 1), -1, TimeUnit.Days)

With(
    {d1: startDate, d2: endDate},
    DateDiff(d1, d2, TimeUnit.Days)
    - 2 * Int(DateDiff(d1, d2, TimeUnit.Days) / 7)
)

Text(12500, "$#,###.00")  // → "$12,500.00"

If(
    v >= 1000000, Text(v / 1000000, "#.#") & "M",
    If(v >= 1000, Text(v / 1000, "#.#") & "K", Text(v))
)

If(Len(txt) > 50, Left(txt, 47) & "...", txt)

Upper(
    Left(name, 1) &
    If(Find(" ", name) > 0, Mid(name, Find(" ", name) + 1, 1), "")
)

Proper(Lower(text))

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

GroupBy(Items, "Category", "GroupItems")

Distinct(Items, Category)

SortByColumns(Items, "Priority", SortOrder.Ascending, "Date", SortOrder.Descending)

ForAll(Distinct(colItems, Title), LookUp(colItems, Title = Result))

// StartsWith is delegable — Contains is NOT
Filter(Items, StartsWith(Title, searchText))

// CountIf is delegable, CountRows is not
CountIf(Items, true)

ClearCollect(colLocal, Filter(DataSource, Status = "Active"))

Concurrent(
    ClearCollect(col1, Source1),
    ClearCollect(col2, Source2),
    ClearCollect(col3, Source3)
)

Set(varResult,
    Patch(
        YourSharePointList,
        Defaults(YourSharePointList),
        {
            Title: txtTitle.Value,
            Status: {Value: "Active"},
            AssignedTo: drpAssignee.Selected
        }
    )
);
If(
    IsError(varResult),
    Notify("Save failed: " & FirstError.Message, NotificationType.Error),
    Notify("Saved successfully", NotificationType.Success);
    Navigate(scrList, ScreenTransition.None)
)

Set(varResult,
    Patch(
        YourSharePointList,
        LookUp(YourSharePointList, ID = varSelectedId),
        {
            Title: txtTitle.Value,
            Status: {Value: drpStatus.Selected.Value}
        }
    )
);
If(IsError(varResult),
    Notify("Update failed: " & FirstError.Message, NotificationType.Error),
    Notify("Updated", NotificationType.Success)
)

IfError(
    LookUp(Items, ID = varId),
    Notify("Not found", NotificationType.Error);
    Blank()
)

If(
    IsBlank(txtTitle.Value),
    Notify("Title is required", NotificationType.Warning),
    IsBlank(drpStatus.Selected),
    Notify("Select a status", NotificationType.Warning),
    // All valid — save
    Patch(YourSharePointList, Defaults(YourSharePointList),
        {Title: txtTitle.Value, Status: drpStatus.Selected}
    );
    Notify("Saved", NotificationType.Success)
)

Coalesce(varUser, "Unknown")

Navigate(scrDetail, ScreenTransition.None, {selectedItem: ThisItem})

If(!IsBlank(Param("id")), Set(varId, Value(Param("id"))))

Back(ScreenTransition.UnCoverRight)

If(App.Width < 640, "mobile", If(App.Width < 1024, "tablet", "desktop"))

If(App.Width < 640, 12, 24)

If(App.Width < 640, 1, If(App.Width < 1024, 2, 4))

Min(Parent.Width - 48, 1200)

nfColors = {
    pageBg:  ColorValue("#F9FAFB"),
    cardBg:  ColorValue("#FFFFFF"),
    primary: ColorValue("#2563EB"),
    danger:  ColorValue("#DC2626")
};

nfIsMobile = App.Width < 640;

nfCurrentUser = {
    Name:     User().FullName,
    Email:    User().Email,
    Initials: Upper(Left(User().FullName, 1))
};