PowerLibs Logo

PowerLibs

PowerFX Toolkit

Preview

Generate complex PowerFX formulas instantly. Select a function below to get started.

This tool is actively being improved with new PowerFX functions being added regularly. More features coming soon!

All Conditions Must Be True (And)

Combine multiple conditions with AND logic

Returns true only if all conditions are true. Perfect for checking multiple requirements at once

And()

Go to Previous Screen

Return to the last displayed screen

Returns to the previously displayed screen with optional transition. Perfect for back buttons

Back()

Create Blank Value

Return a blank/NULL value

Returns a blank value representing "no value" or NULL. Use to clear fields or store NULL in databases

Blank()

Clear Collection

Remove all items from a collection

Delete all records from a collection, leaving it empty

Clear()

Replace Collection Data

Clear and add new records

Remove all items from a collection and add new ones in one action

ClearCollect()

Return First Non-Blank Value

Get first non-empty value from a list

Returns the first value that is not blank or empty. Perfect for providing fallback or default values

Coalesce()

Add to Collection

Append records to a collection

Add new records to an existing collection without removing current items

Collect()

Combine Table Strings

Merge strings from all rows in a table

Summarizes text from a table or collection into one string. Like Sum but for text instead of numbers

Concat()

Combine Individual Strings

Join multiple text values together

Combines individual strings into one text value. Works like the & operator for merging text

Concatenate()

Run Formulas Simultaneously

Execute multiple formulas at the same time

Speeds up your app by running multiple formulas concurrently instead of sequentially. Perfect for OnStart

Concurrent()

Filter Multiple Records

Find all items matching conditions

Get multiple records that match your search criteria

Filter()

Get First Record

Return the first record from a table

Returns the first record from a table or collection. Perfect for getting the top item or most recent entry

First()

Get First N Records

Return the first set of records

Returns a table containing the first N records. Great for top results, pagination, or limiting data

FirstN()

Conditional Logic (If-Then-Else)

Show different results based on conditions

Test conditions and return different values or actions based on the result

If()

Get Record by Position

Return a specific record by index

Returns a record from a table based on its position. Record numbering starts at 1

Index()

Check If Value Is Blank

Test for blank or empty values

Returns true if a value is blank (NULL) or empty string. Essential for form validation

IsBlank()

Check If Table Is Empty

Test if table has no records

Returns true if a table or collection contains no records. Perfect for checking if data exists

IsEmpty()

Get Last Record

Return the last record from a table

Returns the last record from a table or collection. Perfect for getting the bottom item or most recent addition

Last()

Get Last N Records

Return the last set of records

Returns a table containing the last N records. Great for recent items, reverse pagination, or showing latest entries

LastN()

Find One Record

Search and retrieve a single item

Get a specific record from your data source based on conditions

LookUp()

Reverse a Condition (Not)

Negate or flip a Boolean value

Returns the opposite of a condition. Turns true to false and false to true

Not()

Go to a Screen

Navigate to a specific screen

Changes which screen is displayed with optional transitions and context variables. Essential for app navigation

Navigate()

Any Condition Can Be True (Or)

Check if at least one condition is true

Returns true if any condition is true. Perfect for checking if any requirement is met

Or()

Save Data to Database

Create or update records

Send data to SharePoint, Dataverse, SQL, or any data source

Patch()

Delete Specific Records

Remove record(s) from a data source

Removes specific record(s) from a data source or collection. Perfect for delete buttons and item removal

Remove()

Delete Records by Condition

Remove records matching criteria

Removes records from a data source based on conditions. Great for bulk deletion and data cleanup

RemoveIf()

Global Variable (Set)

Store values across all screens

Create or update a global variable that persists throughout your entire app

Set()

Search Text in Columns

Find records by text matching

Searches for a text string across multiple columns. Case-insensitive with partial matching. Perfect for search boxes

Search()

Multiple Choice Logic (Switch)

Match a value against multiple options

Evaluate a formula and return results based on matching values

Switch()

Screen Variable (UpdateContext)

Store values for current screen only

Create or update context variables that are scoped to the current screen

UpdateContext()
Free PowerFX Generator | PowerLibs | PowerLibs