PowerFX Toolkit for Power Apps

The PowerFX Toolkit is a wall of function cards. Each card opens a short form for one Power Fx function; you type your data source, columns or conditions into the boxes and copy the finished formula. Reach for it when you know what you want to do, such as save a record or filter a list, but not the exact syntax.

What it makes

• One card per function or operator, grouped by category. Each card shows a plain-language title such as "Save Data to Database", a description and a badge with the real function name, Patch().
• A search box that matches title, description, function name and hidden search terms, so "save" finds Patch and "find one" finds LookUp. There is no category filter.
• A dialog per card: a collapsible How to use panel with syntax and examples, the input boxes, and a Generated PowerFX box that rewrites itself as you type, with a Copy Code button.
• Operator cards (arithmetic and comparison operators, As, @, in and exactin, Self and Parent, &, ThisItem, ThisRecord) and the Color card open a reference panel only.

New to Power Apps Studio? Getting Started shows where pasted code goes.

Who can use it

The toolkit is free and works signed out: no plan, no daily limit, and Copy Code always copies. Signed-out and free accounts also see an upgrade sidebar, which changes nothing. AI assistants get the same catalogue through the MCP server on every plan as list_powerfx_functions, search_powerfx_functions and get_powerfx_function_details. See MCP integration.

After you paste

The toolkit produces Power Fx, not YAML, so each formula goes into one property of one control, not the Tree view. The Patch generator asks for a Data Source, an Action (Create New Record (Defaults) or Update Existing Record), a Record to Update box that only appears for updates, and Fields to Patch rows with a Column Name and a Value. Its default output goes in the OnSelect property of a button:

Patch(
  Users,
  Defaults(Users),
  {
    Title: "New Item"
  }
)

The Filter generator asks for a Data Source and a list of Conditions, one free-text box each, with Add Condition for more. Power Fx treats the commas as AND. Its default output goes in the Items property of a gallery:

Filter(
  Orders,
  Status = "Active",
  CreatedDate > Today() - 30
)

The LookUp generator asks for a Data Source, one Condition and a Result (Optional) column. With Result empty the output is a whole record, which suits a Set in App OnStart; with a Result it returns just that column, which suits the Text property of a label:

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

Good to know

• The boxes are free text. The generator assembles what you type and knows nothing about your data source, so a misspelled column or a missing quote only shows up as a red underline after you paste into Power Apps Studio.
• The aggregate and sorting generators (Sum, Average, Max, Min, CountIf, Sort, SortByColumns, AddColumns, ForAll, RemoveIf, First, Last, Choices) warn about delegation in their How to use panel. Filter and LookUp do not, so check your own conditions against the delegation rules of your data source.
• The If generator has a Mode select: Simple (If-Then-Else) with Condition, Then and Else boxes, or Advanced (Multiple Conditions) with condition and result pairs and a Default Result.
• Each generator ships with sample defaults (Products, Orders, Users). The Data Source box is plain text, so a collection name works there as well as a list name.
• Generators download one at a time when a card opens, so the first open can take a moment on a slow connection.

Related

Open the tool at PowerFX Toolkit. Related guides: Form Builder, which writes the Patch for a whole form at once, and MCP integration.